Download Squarespace Product Import Template (CSV) - Free
Download a free Squarespace product import CSV template with example data. Includes a column-by-column guide to help you bulk import products into Squarespace Commerce.
Download Squarespace Product Import Template (CSV)
Need to bulk import products into Squarespace Commerce? Squarespace's CSV import format uses a specific column structure - with separate rows for each variant, Option Name/Value columns for product options, and fields for SEO, weight, and dimensions that aren't always obvious.
We've built a free Squarespace product import CSV template based on the exact format Squarespace expects. It includes 3 example products with real data - including multi-variant products with colours and sizes, sale pricing, SEO fields, and proper category tagging - so you can see exactly how every column should be filled in.
Download it, replace the examples with your own products, and import directly into your Squarespace store.
What's in the Squarespace CSV template?
The Squarespace product import template includes all the columns Squarespace Commerce expects, pre-filled with 3 example products:
- A multi-variant product (Canvas Tote Bag) with 3 colour options, SEO fields, and proper categorisation
- A product with scent and size variants (Hand-Poured Soy Candle) - 3 scent options across 2 sizes
- A product with size variants and a sale price (Minimalist Art Print) in A4, A3, and A2
Delete the example rows, replace them with your own products, and import directly into Squarespace.
Squarespace CSV column guide: every field explained
Here's what every column in the Squarespace product import CSV template does and how to fill it in correctly:
System fields
| Column | Required? | What it does |
|---|---|---|
| Product ID [Non Editable] | No | Squarespace's internal product ID. Leave blank for new products - only populated in exports. |
| Variant ID [Non Editable] | No | Squarespace's internal variant ID. Leave blank for new products. |
| Product Type [Non Editable] | Yes | Must be PHYSICAL, DIGITAL, or SERVICE. |
Product identity
| Column | Required? | What it does |
|---|---|---|
| Title | Yes | The product name displayed on your store. Repeated on every variant row for the same product. |
| Description | Recommended | The full product description. Supports HTML tags for formatting (e.g. <p>, <strong>). |
| SKU | Recommended | A unique stock-keeping unit identifier. Each variant row should have its own unique SKU. |
| Product Page | No | The store page this product belongs to. Leave blank to use the default shop page. |
| Product URL | Recommended | The URL slug for the product page (e.g. canvas-tote-bag). Squarespace auto-generates one if blank. |
Variants & options
Squarespace supports up to 3 option dimensions per product (e.g. Size, Colour, Material). Each variant is its own row in the CSV, sharing the same Title:
| Column | What it does |
|---|---|
| Option Name 1 | The name of the first option dimension (e.g. Color, Size). |
| Option Value 1 | The specific value for this variant (e.g. Black, Large). |
| Option Name 2 / Value 2 | Second option dimension and value (e.g. Size / 12oz). |
| Option Name 3 / Value 3 | Third option dimension and value. Leave blank if not needed. |
Pricing & inventory
| Column | Format | What it does |
|---|---|---|
| Price | Number | The selling price (e.g. 29.99). No currency symbol - Squarespace uses your store's currency. |
| Sale Price | Number | A discounted price. Only shown when On Sale is set to Yes. |
| On Sale | Yes / No | Whether this product/variant is currently on sale. Must be Yes for the sale price to display. |
| Stock | Number or Unlimited | Inventory quantity. Use Unlimited if you don't track stock for this product. |
Organisation
| Column | Format | What it does |
|---|---|---|
| Categories | Comma-separated | Product categories (e.g. Bags, Accessories). Squarespace creates categories automatically if they don't exist. |
| Tags | Comma-separated | Tags for filtering and search (e.g. tote, canvas, eco-friendly). |
| Visible | Yes / No | Whether the product is visible on your storefront. Set to No to create hidden/draft products. |
Shipping & dimensions
| Column | Format | What it does |
|---|---|---|
| Weight | Number (lbs) | Product weight used for shipping rate calculations. |
| Length / Width / Height | Numbers (inches) | Product dimensions. Used for dimensional weight shipping calculations. |
Images & SEO
| Column | What it does |
|---|---|
| Hosted Image URLs | Comma-separated URLs to product images. Images must be publicly accessible. Squarespace downloads and hosts them. |
| SEO Title | Custom page title for search results. Falls back to the product Title if blank. |
| SEO Description | Custom meta description for search results. Important for click-through rates. |
How to import products into Squarespace using a CSV file
Once you've filled in the template, follow these steps to import your products into Squarespace Commerce:
- Log in to your Squarespace dashboard.
- Go to Commerce > Inventory in the left sidebar (or Settings > Import & Export).
- Click Import.
- Select Products as the import type.
- Upload your completed CSV file.
- Review the import preview - Squarespace shows how many products and variants it found.
- Click Import and wait for the process to finish.
- Check your Products panel to verify everything imported correctly.
Tips for a successful Squarespace product CSV import
- Each variant gets its own row: Repeat the Title and Description on every row. Change the Option Value and SKU per row to create variants.
- Up to 3 option dimensions: Squarespace supports a maximum of 3 option types per product (e.g. Size, Colour, Material). You can't add more via CSV.
- Use Yes/No, not TRUE/FALSE: Squarespace uses
YesandNofor boolean fields like On Sale and Visible, unlike other platforms that use TRUE/FALSE. - Stock can be "Unlimited": If you don't track inventory, set the Stock column to
Unlimitedinstead of a number. - Categories are created automatically: Unlike BigCommerce, Squarespace creates categories from the names you provide - no need to look up IDs.
- HTML descriptions: The Description field supports HTML, so you can include
<p>,<strong>,<ul>and other tags for rich formatting. - UTF-8 encoding: Save your CSV as UTF-8 to avoid character issues with accents and special characters.
- Set Visible to No first: Import with visibility off, review your products, then make them visible once you're satisfied.
Skip the spreadsheet - use Product Upload instead
CSV imports work, but they're tedious - especially when you're duplicating rows for every variant and making sure option names match exactly. One typo and your variants break.
Product Upload lets you import products directly from any supplier website into Squarespace - no CSV files needed. Visit a product page, click import, and Product Upload pulls in the title, description, images, variants, and pricing automatically.
It's faster than spreadsheets, more accurate than manual entry, and you can customise every detail with AI-powered tools before publishing.
Frequently Asked Questions
Where can I download a Squarespace product CSV template?
You can download a free Squarespace product CSV import template from this page. It includes all the columns Squarespace expects, pre-filled with 3 example products and variants so you can see exactly how to format your data.
What format does Squarespace use for product CSV imports?
Squarespace uses a CSV format with columns like Title, Description, SKU, Price, Sale Price, Stock, Categories, Tags, Option Name/Value fields for variants, Weight, Dimensions, and SEO fields. Our free template has the exact format ready to use.
How do I import a CSV file into Squarespace?
In your Squarespace dashboard, go to Commerce, click Inventory, then Import. Upload your CSV file and Squarespace will create all products from the file. You can also use Settings, Import & Export for bulk operations.
How do Squarespace CSV product variants work?
Squarespace uses separate rows for each variant, sharing the same Title. Each row has Option Name and Option Value columns (up to 3 option dimensions). For example, Option Name 1 = 'Color' and Option Value 1 = 'Black' on one row, with a different value on the next row.
Is the Squarespace CSV import template free to download?
Yes. Our Squarespace product import CSV template is completely free to download and use. No signup or credit card required.