Stackroom lets you bring your existing inventory in from a CSV (comma-separated values) file. It uses a template-based approach with validation, so your data lands cleanly and nothing is silently dropped.
Just switching from another tool? Export your data from it as CSV first — most tools and spreadsheets can. Then follow this guide, or ask us for a white-glove migration from the Migration Center.
Before you start
- Export or build a spreadsheet with one row per asset.
- Save it as .csv (UTF-8 encoding is safest).
- Keep the header row — column names are how Stackroom maps your data.
Standard columns
These columns map to core asset fields. Only name is required; the rest are optional but recommended.
- Column
nameRequiredYesExampleDeWalt Impact Driver - Column
categoryRequiredNoExamplePower tools - Column
brandRequiredNoExampleDeWalt - Column
modelRequiredNoExampleDCF887 - Column
serialRequiredNoExampleSN-48213 - Column
locationRequiredNoExampleNorth Site - Column
purchasePriceRequiredNoExample199.00
| Column | Required | Example |
|---|---|---|
name | Yes | DeWalt Impact Driver |
category | No | Power tools |
brand | No | DeWalt |
model | No | DCF887 |
serial | No | SN-48213 |
location | No | North Site |
purchasePrice | No | 199.00 |
Custom fields
Any extra column you include becomes a custom field on the imported assets, so your own attributes come across too — add as many as you need.
Import in four steps
- 1Upload your file
Choose your .csv in the importer. Stackroom reads the header row to detect your columns.
- 2Map your columns
Confirm how each column maps to a Stackroom field, or leave extras as custom fields.
- 3Review validation
The importer flags rows with issues before anything is created, so you can fix and re-upload.
- 4Confirm the import
Approve, and your assets are created — ready to label, assign and track.
Troubleshooting
- Rows rejected? Check for missing names or malformed numbers in price fields.
- Odd characters? Re-save the file as UTF-8 CSV.
- Wrong mapping? Rename the header to match the standard column, or remap during import.
Migrating a large or complex catalog? Send us your export and we'll handle the import with you — see the Migration Center.