Importing from a spreadsheet

When you’re logging a lot of gear at once — say, a whole shelf — it’s faster to list it in a spreadsheet and import it than to add each item by hand. Snipe-IT reads a CSV and creates the assets (and, if needed, the categories, manufacturers, and models it hasn’t seen before).

The spreadsheet

Make a CSV with one row per physical item and a header row. These columns cover most of what we track:

Category,Manufacturer,Model Name,Asset Name,Serial,Status,Location,Ownership
VR HMD,Meta,Quest 3,,ABC123,Ready to Deploy,Storage Cabinet A,NUILAB
VR HMD,Meta,Quest 3,,DEF456,Ready to Deploy,Storage Cabinet A,NUILAB
Cameras,Sony,ZV-1,,SN9911,Ready to Deploy,Lab 215,Ortega

A few things worth knowing:

• Leave Asset Tag out (or leave it blank). The system assigns the next tag (NUI-000007, and so on) automatically.
• Category, Manufacturer, and Model are created for you if they don’t exist yet — so spell them exactly the way you want them, and reuse existing names rather than inventing variants (see the conventions ).
• Serial can be blank if the item has no serial.
• Ownership is a custom field; if you leave it out, new items default to NUILAB.

Running the import

1. Open the importer (top of the Assets list, or Import).
2. Upload your CSV.
3. On the mapping screen, match each of your columns to the matching Snipe-IT field. The names above map cleanly; check that Ownership maps to the custom field.
4. Run the import, then spot-check a few of the new assets.

Try a small file first. Import three or four rows, confirm they look right, then run the full list. Fixing a mapping mistake across 100 rows is more work than a two-row test.

If you want a starter template or you’re importing something unusual, ask Francisco.