Collection inventory worksheet
A folder-level list of what is in the boxes, with formats, dates, counts and condition, which every later estimate depends on.
Worksheet
The rows are a fictional example. Edit any cell, add or remove rows, then download a CSV for your team. Nothing leaves your browser.
| Box | Folder | Description | Format | Dates | Item count | Condition | Notes | Remove |
|---|---|---|---|---|---|---|---|---|
Every digitization estimate starts with the same question: what is actually in the boxes? Until someone counts, a budget is a guess and a timeline is a hope. This worksheet is a plain inventory, one row per folder or group of like material, with the facts a project plan needs: what it is, what format it is in, when it dates from, how many items there are and what condition they are in.
It is not a finding aid. It is a working list you can fill in over a few afternoons, then hand to a funder, a vendor or your own volunteers.
How to fill it in
Work box by box, in the order the material sits on the shelf. Do not rearrange anything while you count; original order is evidence, and it is much easier to keep than to rebuild.
- Box. The number on the box as it is shelved. If boxes have no numbers, number them now in pencil on a label.
- Folder. A single folder number, a range such as “1 to 14” when a run of folders holds the same kind of material, or “n/a” for an item that is not in a folder, such as a bound volume.
- Description. A short, plain phrase a stranger would understand: whose papers, what kind of record, which business or event.
- Format. Pick the closest of nine choices: letters and manuscripts, bound volume, photographic prints, negatives or slides, glass plates, maps or oversize, newspapers or clippings, objects, or mixed. Format decides how each item will be captured, so split a folder into two rows if it holds prints and letters together.
- Dates. A range (“1893 to 1896”) or an approximate date (“about 1895”). Approximate is fine at this stage; the catalog will refine it.
- Item count. Letters, photographs or volumes, counted. For bound volumes, add the page count in the notes, because a volume is one item but many images.
- Condition. Good, Fair, Fragile, or Needs conservation first. Use the condition assessment checklist to decide. “Needs conservation first” means the item should not be handled for capture until a conservator has looked at it.
- Notes. Anything that changes handling or time: folded letters in envelopes, writing on the backs of photographs, a split spine, fasteners, restrictions from a donor.
Folder-level rows are enough for a first pass on most collections. Go to item level for small, valuable groups, such as a run of photographs that will be cataloged one by one.
Example (fictional). The worksheet’s example rows describe material from the Aster County Historical Society’s Okerlund family papers and the Wren Gulch Mercantile ledger:
- Folders 1 to 14 hold 41 Okerlund family letters, 1893 to 1896, in fair condition, some still folded in their envelopes.
- Folder 15 holds 18 cabinet cards from the Halvorsen Studio, about 1895, in good condition with pencil notes on the backs.
- The Wren Gulch Mercantile day book, 1894 to 1895, is one fragile volume: the spine is split and it opens to about 110 degrees.
- Nine Courier clippings and a telegram, 1894 to 1896, are fragile, on acidic newsprint with brittle edges.
That is 69 items in four rows. The counts alone would understate the work: the day book has 212 pages, the 41 letters run to 96 pages, and the cabinet cards need their backs captured because of the pencil notes.
Using the inventory in a project
A finished inventory answers the first questions in any plan.
| Question | Where the answer comes from |
|---|---|
| How many images? | Item counts and page counts, times images per item (fronts, backs, envelopes) |
| How long and how much? | Images and items entered in the digitization budget calculator and the project timeline calculator |
| Which capture methods? | The Format column: flat documents, bound volumes, prints, film and oversize all need different setups |
| What needs care first? | Rows marked Fragile or Needs conservation first |
| What can be published? | Dates and formats, which start the rights review |
| What should the files be called? | Box, folder and item numbers, which become the file naming pattern |
Funders also ask for this. A grant narrative that says “about 1,500 items in 22 boxes, mostly letters and photographs, 1880 to 1940” is far stronger when an inventory stands behind it. Several of the columns line up with elements in DACS, the archival description standard, such as dates and extent, so the inventory is a head start on description too.
Download the CSV when you finish each box. It opens in any spreadsheet and travels well in an email.
How we use it
An inventory like this is the first step of a collection assessment, the Assess stage of our method. We complete it with you, add a condition survey and a rights review, and turn the counts into a budget and timeline. If you have already filled it in, bring it to the conversation when you plan a pilot box. The Reading Room’s planning and funding section has more on scoping a project.
Send one box first.
A pilot box shows you the images, the recognized text and the catalog records before you commit a whole collection. Tell us what is in the box and what you want people to find.
Studio and contacts
24 South Weber Street, Suite 225Colorado Springs, CO 80903(719) 244-8450sales@dastok.com