How to Import Inventory Into Square With CSV or Excel
The safest way to import inventory into Square is to export Square's current Excel template, update that file without changing its required headers, test a small batch, and choose the update option rather than replacing the full library unless replacement is truly intended.
Choose the correct import goal
- New library: create items in a new or empty account.
- Update existing library: change selected fields while preserving the rest of the catalog.
- Move items between accounts: export from one account and adapt the file for the destination.
These are different operations. Save an untouched export before changing anything.
1. Export Square's current template
In Square Dashboard, go to Items & services > Items > Item library, then Actions > Export Library. Square's bulk import guide recommends the Excel format because it preserves structure more reliably than CSV.
2. Protect identifiers
Format the SKU column as text before editing. Spreadsheet software can remove leading zeros or display long identifiers in scientific notation. A changed SKU can create a new variation instead of updating the intended one. Keep product names, variation names, category labels, and location columns consistent.
3. Prepare the data
- Use one row per variation.
- Do not reuse a SKU for different variations.
- Separate item name from variation name.
- Use Square's exact tax-column heading format.
- Populate the correct New Quantity column for each location.
- Keep Y/N fields and accepted values exactly as the template describes.
- Remove hidden formulas and unsupported formatting.
4. Import and map columns
Return to the Item library, choose Actions > Import library, upload the file, and confirm Square's field mapping. Read the summary before committing. If the interface offers modify/update versus replace, use replacement only when deleting and rebuilding the complete library is deliberate.
5. Test before the full import
Import five to ten representative records first: one simple item, one item with variations, one item assigned to multiple locations, one SKU with leading zeros, and one taxable item. Verify names, prices, SKUs, quantities, locations, and online visibility.
Common import errors
| Problem | Check |
|---|---|
| Leading zeros disappear | Format SKU as text before opening/saving |
| Duplicate items appear | Match tokens, SKUs, item names, and variation structure |
| Wrong location quantity | Use the location-specific quantity column |
| File will not validate | Restore exact headers and accepted field values |
Square maintains a separate import troubleshooting guide for CSV delimiters, SKU formatting, and validation errors.
After the import
- Count a sample of physical stock.
- Run a test sale at each location.
- Confirm the correct variation decreases.
- Review channel visibility.
- Export again and compare the resulting library with the intended source.
Where Stash fits
Square can handle the POS inventory action described above. Businesses that need a dedicated workflow for forecasting, purchasing, physical counts, ingredient-level tracking, or multi-location inventory can also connect Square with Stash for Square inventory management, which explains the combined workflow and when a dedicated inventory layer may make sense without replacing Square at checkout.
Frequently asked questions
Can Square import CSV files?
Yes. Square supports CSV and Excel item-library imports, although its support documentation recommends Excel for the template workflow.
Can I update inventory without replacing everything?
Yes. Use the modify or update workflow and include only intended changes. Keep a backup export before every bulk operation.
Why did Square create duplicate items?
Identifiers or variation structure may not have matched the existing library. Review SKUs, item tokens where provided, item names, and variation names.
Can I import opening quantities by location?
Yes, using the location-specific quantity fields in Square's current template. Verify a sample after import.
Related Square inventory guides
- Square Item Library Setup: Items, Variations, SKUs and Categories
- How to Set Up Inventory in Square: Step-by-Step Guide
- Square Inventory Not Updating: Troubleshooting Checklist
Last reviewed: August 8, 2026. Square menus, plan names, feature availability, and regional interfaces can change; confirm the current workflow in Square's official documentation.
Turn better inventory decisions into a better operating system
Stash connects inventory tracking, forecasting, purchasing, suppliers, and multi-location visibility so growing physical businesses can act on the numbers with less manual work.
