Table of Contents
- How to Import Products into Squarespace Using CSV Files
- TL;DR: Key Points
- Getting Your CSV File Ready
- If You Already Have Products in Squarespace
- Starting From Scratch
- Filling Out Your CSV File
- Importing Your Products
- Common Import Problems (And How to Fix Them)
- Import Limits
- Platform-Specific Imports
- Quick Definitions
- Before You Start
.png?table=block&id=219105a2-9d95-8145-b9d2-e68365554017&cache=v2)
Last Edited Time
Jun 25, 2025 09:35 PM
Do not index
Do not index
Suggested Tag
Squarespace
product management
csv import
ecommerce
squarespace commerce
Tags Synced
Tags Synced
AI summary
Quickly import products into Squarespace using CSV files by following the correct format, ensuring image URLs are valid, and addressing common errors. Test with a small batch before a full import to avoid issues. Direct imports are available from Shopify and Etsy.
Last edited by
Platform
Category
Topic
How to Import Products into Squarespace Using CSV Files
Import hundreds or thousands of products into your Squarespace store quickly using CSV files. Here's exactly how to do it without the usual headaches.
TL;DR: Key Points
- Import up to 10,000 products on Squarespace 7.1 and 200 on 7.0
- Use Squarespace's CSV template for the correct structure
- Your image URLs must link directly to image files (ending in .jpg, .png, etc.)
- Check for common errors like broken URLs or missing categories before importing
- Shopify and Etsy have direct import options that skip the CSV step entirely
Getting Your CSV File Ready
You need a properly formatted CSV file before you start. CSV stands for "comma-separated values" and it's basically a simple spreadsheet that any system can read.
If You Already Have Products in Squarespace
- Go to your Products panel in Squarespace
- Click 'Export all' to download your existing products as a CSV
- Use this as your template or edit it to add new products
Starting From Scratch
- In your Products panel, click 'Import'
- Click 'Download CSV template'
- This gives you the correct column structure that Squarespace expects
Filling Out Your CSV File
Open the CSV in Excel, Google Sheets, or any spreadsheet program. You'll need:
Basic product info:
- Product names and descriptions
- Prices and SKUs
- Categories (these must already exist in your Squarespace store)
Variants:
- Different sizes, colours, or other options
- Up to 250 variants per product
Images:
- Direct URLs to images hosted online
- URLs must end with the image file extension (.jpg, .png, .webp)
- Don't use Dropbox share links or Google Drive links - they won't work
Important: Your image files need to be hosted somewhere accessible on the web. Upload them to your existing website, use a service like Imgur, or host them on a CDN.
Importing Your Products
Once your CSV is complete:
- Go to Products > Import
- Drag your CSV file into the 'Upload Squarespace CSV' box
- Uncheck 'Update product quantities' if you don't want to change existing stock levels
- Review any errors that appear (more on this below)
- Fix errors in your CSV file if needed, then re-upload
- Click 'Save' to complete the import
Common Import Problems (And How to Fix Them)
"Product page not found" errors:
Your CSV probably has URL slugs that don't match your site. Either create the missing product pages first, or remove the URL slug column from your CSV and let Squarespace generate them automatically.
Missing category errors:
Create all your product categories in Squarespace before importing. The category names in your CSV must match exactly.
Image won't load:
Check that your image URLs work by pasting them into a browser. If they don't show the image directly, they won't work in Squarespace either.
File too large:
If you're hitting import limits, split your CSV into smaller files and import them separately.
Import Limits
- Squarespace 7.1: Up to 10,000 products per import
- Squarespace 7.0: Up to 200 products per import
- Both versions: Up to 250 variants per product
Platform-Specific Imports
From Shopify or Etsy: Don't bother with CSV files. Squarespace has direct import tools for these platforms that are much easier to use.
From other platforms: Export your products as CSV from your current platform, then reformat the data to match Squarespace's template.
Quick Definitions
CSV file: A simple file format that stores data in rows and columns, like a basic spreadsheet
Product variants: Different options for the same product (size, colour, material, etc.)
URL slug: The part of a web address that identifies a specific page (like "red-cotton-shirt" in yoursite.com/products/red-cotton-shirt)
Hosted image URL: A direct link to an image file on the internet that ends with .jpg, .png, or similar
Before You Start
Test with a small batch first. Import 5-10 products to make sure everything works correctly before doing your full catalogue. It's much easier to fix problems with a small test than with hundreds of products.
Check that all your product categories exist in Squarespace before importing. Create them manually if they don't - it'll save you time later.
This method works well for large catalogues, but if you only have a few dozen products, it might be quicker to add them manually through Squarespace's interface.