Squarespace CSV: Products, Orders, and Mailing List Imports

Squarespace Stores Look Simple — Product CSV Is Still Strict

Creators and retailers in the US, UK, Australia, Canada, and Europe run Squarespace Commerce and need CSV for bulk product edits, migrations from Shopify/Wix, order exports for accountants, and mailing-list moves. Wrong headers or Excel-smashed SKUs produce blank storefronts and support tickets.

What You Can Move with CSV

Know the surface.

Step-by-Step: Product Import

Catalog path.

• Download Squarespace’s current product CSV template.
• Map title, SKU, price, stock, and variant fields exactly.
• Keep SKUs as text; preserve leading zeros.
• Use plain decimal prices — no currency symbols in cells.
• Validate image URLs if the template includes them.
• Clean in Online CSV Editor; drop incomplete product rows.
• Import a small pilot; verify PDPs; then full catalog.

Product Name,SKU,Price,Stock
Ceramic Mug,MUG-01,28.00,40
Ceramic Mug,MUG-01-BLU,28.00,15

Orders Export for Accountants

Finance handoff.

• Export orders for the tax period.
• Archive raw as squarespace-orders-YYYY-MM-DD.csv.
• Convert to Excel for bookkeepers if needed.
• Do not edit totals without an audit trail.
• Map to Xero/MYOB/QuickBooks using those products’ import guides.

Mailing List Imports and Consent

Compliance first.

• Only import contacts with a lawful basis to email.
• Include consent/status columns when the template supports them.
• Deduplicate on email.
• EU/UK GDPR and US CAN-SPAM still apply on Squarespace lists.

Migrating from Shopify or Wix

Remap — do not rename the file and hope.

• Shopify/Wix headers ≠ Squarespace headers.
• Variant rows often need restructuring.
• Re-host or re-point images to URLs Squarespace can fetch.
• See Shopify and Wix CSV guides for source-side cleanup.

Locale Notes

Cross-border shops.

• UTF-8 for product titles with accents.
• European semicolon Excel → convert to comma if the template expects commas.
• Weight/dimension units must match store settings.
• VAT-inclusive pricing: document whether CSV prices are tax-inclusive.

Common Mistakes

Launch-week failures.

• Uploading a Shopify export unchanged.
• Excel turning SKUs into scientific notation.
• Broken image links after leaving a temporary host.
• Importing mailing lists bought from brokers.
• Bulk price edits without a backup export.

Best Practices

Catalog discipline.

• Export a backup before every bulk import.
• Version files with store + date.
• Keep an external SKU registry.
• Pilot seasonal drops.
• Cleanse CSVs in-browser when agencies edit client catalogs.

Why Use Convert CSV Online?

Convert CSV Online is free, browser-based, and requires no account for everyday conversions. Remap product sheets to Squarespace templates, protect SKUs, and convert order exports to Excel — useful for US, UK, AU, CA, and EU merchants.

Conclusion

Squarespace CSV works when you follow the live product template, protect SKUs, respect consent on lists, and remap carefully from other platforms. Backup, pilot, then scale.