Import your inventory from Excel or CSV
Bring your whole stock list into HomyScan from a spreadsheet you already have. Map your columns once, fix nothing by hand, and start scanning the same day.
Your stock list already exists. Don't retype it.
You have a spreadsheet with a few hundred items in it. Retyping them into a new app is an afternoon nobody wants. An import reads your file, matches your columns to the right fields, and builds your catalog in one pass. You walk in with a spreadsheet and walk out with a live inventory.
Import your inventory in four steps
Export your current list
Get your stock out of your old tool as .xlsx or .csv. From another app, use its export button. From scratch, a sheet with one column of names is enough to start.
Match your columns
Upload the file and tell HomyScan which column is the name, which is the quantity, which is the SKU. Your headers don't have to match ours. You map them once.
Review before it lands
HomyScan shows you a preview and flags rows that look off: a missing name, a price typed as text, a duplicate SKU. You fix them in place or skip them.
Confirm
Approve the import and your items appear, with their quantities, locations and photo-ready entries. Scanning works the same minute.
What goes in each column
One row per item. The only column you can't skip is the name. Everything else is optional and maps to a field you can fill later.
| Column | Required | Example | Notes |
|---|---|---|---|
| Name | Yes | Cordless Drill 18V | What your team calls it |
| SKU | No | DRL-18V | Your own code, letters and numbers |
| Barcode | No | 3701234567890 | UPC, EAN or your QR value |
| Quantity | No | 12 | Whole number, starting count |
| Location | No | Van 1 | Created automatically if new |
| Min quantity | No | 5 | Triggers your low-stock alert |
| Unit price | No | 189.00 | Use a dot, no currency symbol |
| Supplier | No | ToolPro | Created automatically if new |
A few ways Excel breaks your import (and how to dodge them)
Leading zeros vanish
A barcode like 0123456789 becomes 123456789 because Excel treats it as a number and drops the zero.
Format the column as Text before you type, or set the column to text before saving as CSV.
Long codes turn into 4.001E+11
Excel shows long barcodes in scientific notation, like 4.001E+11, and saves them that way.
Set the column to Text, not Number, before you enter the codes.
Prices become dates
Type 5-10 and Excel reads it as the 5th of October.
Keep prices as plain numbers with a dot for decimals. Skip dashes and slashes in number fields.
Accents turn to gibberish
Names with accents or symbols break if the file isn't saved in the right encoding.
Save your CSV as CSV UTF-8 and HomyScan reads it cleanly.
Coming from Sortly, a spreadsheet, or another app?
Most tools export to CSV or Excel from a button in their settings. Export your items there, drop the file into HomyScan, map the columns, and you're moved. Your old data lands as a clean catalog, no retyping, no copy-paste between tabs.
Import questions
What file formats can I import?
Excel (.xlsx) and CSV. If your data lives in Google Sheets, export it as .csv or .xlsx first.
Do my column headers have to match yours?
No. You map your columns to HomyScan fields during import, so any layout works. You only do it once per file.
My barcodes lose their first digit. Why?
Excel drops leading zeros on numbers. Format the barcode column as Text before entering the codes, then save and import.
How many items can I import at once?
Thousands in one file. For very large lists, split them into a couple of files and import in sequence.
Can I update existing items by re-importing?
Yes. Match on SKU or barcode and a new import updates quantities and details instead of creating duplicates.
After the import
Bring your inventory in today
Import your own file and start scanning the same day. Free for 15 days, no card.