Excel & CSV

Excel Inventory Import & Export

Drop in a spreadsheet from anywhere — Shopify, QuickBooks, Zoho, or your own homemade sheet — and AI maps the columns for you.

  • AI column mapping: name, qty, price, SKU, cost, supplier, expiry
  • Duplicate handling you choose: add quantity, skip, or create new
  • Full review screen before a single row is saved
  • Export your filtered view to Excel on any plan, including free
Excel inventory import mapping spreadsheet columns with AI

Migrating from a spreadsheet without retyping

Every business moving to inventory software has the same fear: that the migration will mean retyping everything, or discovering halfway through that the importer wanted columns in an exact order nobody documented.

This importer reads whatever you have. AI inspects your headers and maps them to the right fields — name, quantity, price, barcode or UPC, SKU, cost price, supplier, category, reorder level, unit, expiry date and lot number — regardless of what you called them or what order they are in. You review everything before it commits.

It is equally useful afterwards. Weekly supplier sheets can be imported to add quantities to existing items, matched by barcode, SKU or name, so restocking is a file drop rather than an evening of data entry.

What you get

Your columns, not ours

No template to conform to — AI figures out what your headers mean.

Rich fields come along

SKU, cost, supplier, reorder level, unit, expiry and lot are all imported, not just name and quantity.

Restocking imports

Match by barcode, SKU or name and add quantities to existing items.

You choose duplicate behaviour

Add quantity, skip the row, or create it as a new item — per import.

Fields auto-enabled

Columns you actually used are switched on in your item editor automatically.

Export whenever

Download your current filtered view as Excel on every plan — your data is never locked in.

The migration is the whole decision

Most inventory projects are abandoned during data entry. If your spreadsheet imports cleanly in one sitting, everything after that is easy.

How it works

1

Export from wherever you are

Any .xlsx or .csv — from another system, or the sheet you have kept for years.

2

Drop it in

Upload it (or drag it straight into the AI Onboarding Officer chat) and let the AI map columns.

3

Review and commit

Check the parsed rows, choose how duplicates are handled, and save the batch.

Frequently asked questions

How do I import my inventory spreadsheet into new software?

Export it as .xlsx or .csv and upload it — there is no required template. The AI reads your headers and maps them to the right fields even if you called them "Qty on hand" or "Part #". You see every parsed row before anything is written, so a bad mapping costs you a click rather than a cleanup.

Can I import a supplier price list to update quantities?

Yes, and it is one of the most common uses. Rows matching existing items by barcode, SKU or name can add their quantity to what you already have, so a weekly delivery sheet becomes a thirty-second import instead of manual entry.

What if my spreadsheet has extra columns you do not support?

Standard fields are mapped automatically; anything else can be captured through custom item fields, which you can create with any name and type. Columns that are genuinely irrelevant are simply left out.

Can I get my data back out later?

Yes — Excel export is available on every plan including free, and includes your fields, locations and batch details. We consider hostage-taking a dark pattern, so the export button is not behind an upgrade.

Is there a limit to how many rows I can import?

Your plan’s item limit applies — 50 on free, 1,000 on Pro, up to 500,000 on the largest plan — and you are warned before an import would exceed it rather than failing halfway through.

Explore related features

Ready to try it?

Start free with 50 items — no credit card, no trial countdown. Import your spreadsheet and you have a working system in minutes.