Import a spreadsheet
Review spreadsheet columns and proposed equipment or customer records before importing them.
What magic import can do
If your inventory, customers, or catalog live in a spreadsheet today, you do not need to retype anything. Magic import accepts CSV or Excel files (.csv, .xlsx, or .xls) up to 8 MB and processes the first 10,000 data rows per upload. It proposes a data type and column mapping for you to review before anything is created.
You can import five kinds of data:
- Units: individual physical inventory identified by a barcode, a manufacturer serial number, or both. Include a stable barcode when you want to identify the unit in the scan workflow.
- Product types: catalog entries like "Standard wheelchair". Product imports can choose serialized or quantity tracking and set a starting in-warehouse quantity.
- Customers: names plus contact details, phone, and delivery address.
- Locations: warehouses, bins, and trucks.
- Categories: your equipment category list.
Run an import
- Go to Import, under Company settings.
- Optionally tell it what the file contains, or leave it on "Let magic figure it out".
- Choose your file. TrackDME analyzes the column headers and a sample of rows, then tells you what the file looks like and whether it can be imported.
- Review the column mapping. Every column in your file is listed with an example value and the TrackDME field it will import into. Change any column, or set it to Ignore.
- If you change a mapping, select Preview import to refresh the plan.
- Check the preview: how many new records will be created, how many already exist, duplicate rows with their row numbers and identifiers, and any rows that cannot be imported.
- Select the import button, labeled with the count and type, such as Import 5 units. Nothing is written until you confirm.
When a file can't be imported as-is
Magic import is honest about what it can and cannot use:
- If the file matches a data type but is missing something essential (for example, a single column of barcodes with no product information), it tells you exactly what column to add.
- If the file looks like rental orders or invoices, it explains that order import is not supported yet and suggests importing your customer list and units instead.
- If the file is unrelated data (say, a bank statement uploaded by accident), it says so and reminds you what you can import.
Safe to re-run
Duplicates are skipped, never overwritten. Units are matched by barcode and serial number, while catalog records are matched by their stable name or Product number. If an import stops partway or you fix a few bad rows, upload the same file again and only the missing records are added. When you import units, any product types, categories, and locations named in the file are created automatically, and the preview counts them before you confirm.
Exporting your data
Company settings has an Export section with CSV downloads for units, equipment types, and customers. See Export your data.