The Museum Template That Finally Stopped Us From Losing Files Between Departments

A working museum template for Google Sheets — track collections, loan agreements, condition reports, and conservation photos without drowning in shared drives.

Last spring, a visiting curator from a partner institution asked me for the condition report on a ceramic vessel we'd loaned them in 2019. I said "sure, give me five minutes." Forty-five minutes later I was still digging through a shared drive with folder names like "Loans 2019 FINAL" and "Loans 2019 FINAL (2)" and a subfolder someone had helpfully labeled "misc." The condition report was a scan buried inside a folder for a completely different loan. The curator was polite about it. I was not polite to myself.

That was the week I finally built a proper museum template in Google Sheets — not a collections management system pretending to be enterprise software, and not a bare spreadsheet with thirty columns and no files attached to anything. Something in between. Something that actually works for a small-to-mid-size museum where three people do the jobs of twelve and nobody has budget for a $40,000 CMS license.

Why Most Museum Collection Tracking Falls Apart

Here's the thing nobody talks about at AAM conferences: most small museums aren't running PastPerfect or TMS or Axiell. They're running Google Sheets, or Excel files on someone's desktop, or — and I say this with love — a filing cabinet and a prayer. The big institutions have dedicated registrars and database administrators. The rest of us have a collections manager who's also the education coordinator who's also writing the next grant application at 10 PM.

The spreadsheet part isn't the problem. Google Sheets handles object records, accession numbers, and location tracking perfectly well. The problem is the FILES. Every object in your collection has a constellation of documents orbiting it: deed of gift, condition report, conservation photos, insurance appraisal, exhibition history, provenance research. Those files live in Google Drive, in email attachments, on a USB drive in someone's desk drawer, and on the phone of the intern who left two years ago.

So you end up with a spreadsheet that's accurate for about six weeks after you build it, and then slowly drifts into fiction because nobody can find the actual documents it's supposed to reference.

The Core Tracker: One Row Per Object, Everything Attached

The foundation of our system is a Collections tab where each row is one accession. The columns aren't fancy — they're the same fields you'd find in any museum database, just arranged so that the stuff you look up most often is visible without scrolling:

• Accession Number (our primary key — everything else links back to this)
• Object Name / Title
• Creator / Culture / Date
• Medium / Materials
• Dimensions
• Current Location (gallery, storage bay, or "On Loan — [institution]")
• Condition (Excellent / Good / Fair / Poor)
• Last Condition Report Date
• Status dropdown (Accessioned, Pending Review, Deaccessioned, On Loan)
• Files column — this is where everything lives

That last column is the game-changer. Instead of hyperlinking to a Google Drive folder that may or may not still be organized correctly, I drag the actual files — condition report PDFs, high-res photography, donor correspondence, deeds of gift — directly into the cell for that object. When the visiting curator asks for a condition report, I filter to the accession number and it's right there. Five seconds, not forty-five minutes.

Museum Loan Tracking Without Losing Your Mind

Loans are where things get genuinely dangerous. You have legal agreements with specific terms, insurance requirements, condition reports going out and coming back, shipping documents, courier reports. Miss a return date and you've got a conservation liability. Miss an insurance renewal and you've got a personal nightmare.

Our Loans tab tracks each loan as a single row with these columns:

• Loan Number (outgoing: OL-2024-001, incoming: IL-2024-001)
• Borrowing / Lending Institution
• Object(s) — accession numbers, comma-separated, each linking back to the Collections tab
• Loan Start Date and Loan End Date
• Insurance Value and Policy Number
• Status: Proposed → Approved → In Transit → Active → Return Pending → Returned → Closed
• Files: loan agreement PDF, condition reports (outgoing and return), shipping manifests, insurance certificates, courier reports

The status dropdown is doing heavy lifting here. Every Monday morning I filter to "Return Pending" and "Active" and check dates. If a loan end date is within 60 days, I start the return process. If it's within 30 days and I haven't heard from the borrower, I'm on the phone. This is not sophisticated. It's a dropdown and a date column. But before I had it, loans would just... linger. We had a painting at a university gallery for three years past its loan term because nobody flagged it.

Condition Reports and Conservation Photography

If you've ever tried to document the condition of 200 objects going into a traveling exhibition using a Word template and a folder of JPEGs, you know the pain. The template works fine for one object. By object 47 you're saving files with names like "IMG_3847_detail_crack_maybe.jpg" and questioning your career choices.

Our Condition Reports tab is linked to the Collections tab by accession number. Each row is one condition assessment, not one object — because the same object gets assessed multiple times (before loan, after loan, annual survey, after that time the HVAC went down and humidity hit 78% in Gallery C). Columns:

• Accession Number
• Assessment Date
• Assessed By
• Occasion (Pre-Loan, Post-Loan, Annual Survey, Incident)
• Overall Condition rating
• Notes — free text, as detailed as needed
• Photos — drag in raking light shots, detail photos, UV documentation, whatever you've got
• Condition Report PDF — the formal document

The photos column is where FileFox genuinely saves hours. Our conservator used to shoot condition photos, transfer them to her laptop, rename them, upload them to Drive, then paste a link into the spreadsheet. Now she AirDrops them to her laptop and drops them straight into the row. It sounds like a small thing until you're doing it 200 times for an exhibition changeover.

A formula I use constantly: pulling the most recent condition assessment for any object on the Collections tab.

This pulls the overall condition rating from the most recent assessment date for the accession number in A2. It's an array formula (Ctrl+Shift+Enter in older Sheets, or it auto-detects in newer versions). It means the Collections tab always shows the current condition without anyone manually updating it.

Exhibition Planning: The Tab Nobody Thinks They Need Until They're Panicking

Every exhibition I've worked on has the same arc: six months of relaxed planning, then three weeks of frantic chaos where everyone suddenly needs the same information at the same time. The curator needs the checklist. The preparator needs dimensions and mount types. The registrar needs insurance values. Marketing needs images. Education needs interpretive content. And all of it lives in different places.

Our Exhibitions tab isn't object-level — it's show-level. One row per exhibition. But each row has attached files that contain everything the team needs:

• Exhibition title, dates, venue (gallery number or traveling)
• Curator and project lead
• Budget: estimated vs. actual (linked to a budget detail tab if the show is complex enough)
• Status: Concept → Approved → In Development → Installed → Active → Deinstalled → Archived
• Checklist file: the detailed object-by-object list with locations, mount specs, label copy
• Design files: floor plans, elevation drawings, graphic design comps
• Contracts: loan agreements for borrowed objects, venue agreements for traveling shows
• Marketing assets: press images, wall text, didactic panel copy

For larger exhibitions, I'll spin up a dedicated tab that's basically a mini project plan — every task from "finalize checklist" to "install lighting" to "print labels" with assigned staff, due dates, and status. But for most of our shows, one well-organized row with the right files attached is enough.

The Dashboard Tab: What Needs Attention Right Now

With four tabs running (Collections, Loans, Condition Reports, Exhibitions), you need a fifth that tells you what's on fire. Our Dashboard tab is the first thing I open on Monday mornings. It uses COUNTIFS and QUERY functions to surface:

• Loans with return dates in the next 60 days
• Objects with condition rated "Poor" that haven't been assessed in 12+ months
• Exhibitions in "In Development" status with tasks past due
• Pending accessions — objects physically in the building but not yet formally accessioned (this number should scare you into action)
• Deaccession candidates flagged for review

That formula counts active loans with end dates within 60 days. Simple, but it replaced a system where I was manually scrolling through loans hoping I wouldn't miss something. The dashboard doesn't need to be beautiful — it needs to be honest. If you've got 14 objects in "Pending Review" limbo, you should see that number staring back at you every week.

Making It Work With a Small Team (or a Team of One)

I know what you're thinking: this sounds like a lot of setup for a museum where "the team" is you plus a part-time collections assistant and some dedicated volunteers. Fair. Here's how I'd prioritize if I were starting from scratch today:

• Start with the Collections tab. Get your accession numbers, object names, locations, and conditions into rows. Don't try to backfill every historical document on day one — just start attaching files going forward.
• Add the Loans tab as soon as you have any active loans. This is where legal and financial risk lives, so it gets priority over everything else.
• Build condition reporting into your routine. Even if it's just ten objects a week during a slow Tuesday, you're building a record that didn't exist before.
• Add the Exhibitions tab when your next show enters development. Don't build it for past exhibitions unless you have a specific reason to archive them.
• The Dashboard comes last, once you have enough data in the other tabs to make it meaningful.

One more thing: share the sheet with your team, but use Google Sheets' built-in Protected Ranges to lock down the accession number column and any formulas. Volunteers are enthusiastic and wonderful and they will accidentally overwrite your MAXIFS formula with the word "yes" if given the chance. Ask me how I know.

The honest truth is that most museum professionals don't need more software — they need the system they already have to actually hold their files. The spreadsheet was always capable. The missing piece was connecting documents to the data they belong with, instead of praying that the folder structure in Google Drive stays organized forever. (It won't. It never does.)

If you're staring at a shared drive right now with a folder called "To Be Filed" that has 300 items in it, start with one tab. One object type. Get those rows built, get those files attached, and work outward from there. The system doesn't have to be finished to be useful. It just has to be started.

Frequently Asked Questions

How do I track museum collections in Google Sheets?

Create a Collections tab with one row per accession number. Include columns for object name, creator, medium, dimensions, current location, condition rating, and status. Attach condition reports, deeds of gift, and photos directly to each row using a file attachment tool like FileFox. Use COUNTIFS and status dropdowns to surface objects that need attention.

Is Google Sheets good enough for museum inventory management?

For small-to-mid-size museums (under ~10,000 objects), Google Sheets handles inventory tracking well — especially if you pair it with file attachments for documentation. It won't replace enterprise CMS platforms like TMS or PastPerfect for very large institutions, but it's a solid working system when budget is limited and your team is small.

How do I track museum loan agreements and return dates?

Build a dedicated Loans tab with columns for loan number, borrowing institution, object accession numbers, start/end dates, insurance value, and a status dropdown. Attach signed loan agreement PDFs and condition reports directly to each row. Use a dashboard formula like COUNTIFS to flag loans with return dates approaching within 60 days.

What's the best free museum template for Google Sheets?

There isn't a single perfect one, but you can adapt a project tracker or contract management template to museum workflows. The key columns to add are accession number, object location, condition rating, and a file attachment column for deeds of gift, condition reports, and conservation photos. Start simple and add tabs for loans and exhibitions as you need them.

How do small museums manage collections without expensive software?

Most small museums use Google Sheets or Excel as their primary collections database. The key is pairing your spreadsheet with a consistent file management system — attach documents directly to object rows instead of relying on folder structures in Google Drive. Add status dropdowns, date-based formulas, and a dashboard tab to flag what needs attention. It's not enterprise software, but it works.