Note: While our most popular guides have been translated into Spanish, some guides are only available in English.
Importing products from a .csv

You can use our standard .csv to import products from any platform into your Squarespace store. The .csv helps you create a Squarespace-friendly format for all of your existing product data, including variants, prices, stock, tags, and categories.

Download the .csv.

Before you begin

The importer scans the .csv for certain formatting. Keep in mind:

  • When completing your .csv file, your column headers and entries must match the standard formatting in the file.
  • If you’re coming from Big Cartel, Etsy, or Shopify, use our direct import options instead.
  • If you already have a .csv of your products (for example, an export from a different eCommerce platform or software), that file might not import into Squarespace as-is. We recommend copying the data into our formatted file for the best results.

Limitations:

  • The importer is for adding new products. It doesn’t work for exporting or editing existing products.
  • This is a one-time import. Any updates to your original store or .csv won't automatically sync to Squarespace after the import.
  • The import is only for physical and service products. Digital products won’t import.
  • It’s not possible to schedule products with an import, only publish or hide.

Step 1 - Open the Import/Export panel

  1. In the Home Menu, click Settings. 
  2. Click Advanced, and then click Import / Export.
  3. Click Import.
  4. Select Products via .csv from the Import Site menu.

products_via_csv.jpg

Step 2 - Download the .csv

  1. Download the .csv file from the box that appears by clicking the link. You can also download the file here.
  2. Open the file from your computer.

Import.png

Step 3 - Complete the .csv file

Next, you’ll enter your products into our standard .csv file. The .csv spreadsheet contains sample text, which guides you through formatting your product information.

To complete the spreadsheet:

  1. Open the .csv file in a spreadsheet editor, like Google Sheets or Microsoft Excel.
  2. Add your products one row at a time, following the example rows and tips in the table below.
  3. Save the file.

When you enter your products in the .csv file, ensure that you:

  • Complete all required columns for each product.
  • Don’t change or delete any column headers.
  • Don’t delete any columns. You can leave optional columns blank instead.
  • Delete all sample rows after using them as a reference for formatting your data.
  • If you’re importing variants, see Formatting variants for the import.
  • Save the file as a .csv.

Use the table below to help format your entries.

Note: The .csv doesn’t support columns other than those listed here, with the exception of more Option Name and Option Value columns for variants. Adding unsupported columns may cause your import to fail.

Column

Description and format tips

Product URL

  • Required
  • The URL slug the product will have on your site, without the /. This creates a direct URL to the product item page.
  • Between 3 and 250 characters.
  • Separate words with dashes (-).
  • Don’t include spaces or special characters other than dashes.
  • Capital letters will automatically become lowercase on your site.
  • If the product has variants, enter each variant on a new line and use the same product URL for each variant.
  • Example: v-neck-t-shirt

Title

  • Required
  • Up to 200 characters.
  • If the product has variants, only enter the product title in the first variant’s row.
  • Example: V-Neck T-Shirt

Description

  • Optional
  • If the product has variants, only enter the description in the first variant row.
  • Example: Made of our softest blend of cotton.

Product Type

  • Required
  • The product type. Enter Physical or Service.
  • The .csv doesn’t support digital products.

Tags

  • Optional
  • Up to 80 characters per tag.
  • Separate tags by commas.
  • If the product has variants, only enter tags in the first variant row.
  • Example: organic, soft

Categories

  • Optional
  • Up to 25 characters per category.
  • Separate categories by commas.
  • If the product has variants, only enter categories in the first variant row.
  • Example: Tops

Visible

  • Required
  • Enter TRUE to make the product visible after importing or FALSE to keep it hidden.
  • If the product has variants, only enter the visibility in the first variant row.

Hosted Image URLs

  • Optional
  • Web-hosted product image link(s). Paste the image’s full URL. Ensure the URL leads directly to the image, not a page that includes the image. Check if the URL ends in an image file extension—like .jpg, .gif, or .png—instead of .com or .html.
  • Separate multiple images with spaces or line breaks. (Google Sheets: Alt+Enter or Excel: Ctrl+Alt-Enter)
  • If the product has variants, only enter image URLs in the first variant row.
  • It’s not possible to upload images from your hard drive into this .csv.
  • After importing, Squarespace becomes the host for these image files. Changing or deleting the hosted image URLs won't affect your images.
Tip: If your images are only on your computer, you can leave this column blank and upload images to the products once they’re imported to your site.

SKU

  • Optional
  • Up to 20 characters per SKU.
  • If you leave this blank, Squarespace will automatically generate SKUs for each product/variant.
  • Example: SQ3579

Option Name 1

  • Optional
  • The label of a drop-down menu.
  • Each pair of an Option Name # and Option Value # creates a variant. Add a new row for every possible combination of options in the product. For more help, see Formatting variants for the import.
  • Example: Color

Option Value 1

  • Optional
  • An option inside of a drop-down menu.
  • Examples: Blue, Red, Black

Option Name 2

  • Optional
  • The label of a drop-down menu.
  • Each pair of an Option Name # and Option Value # creates a variant. Add a new row for every possible combination of options in the product. For more help, see Formatting variants for the import.
  • Example: Size

Option Value 2

  • Optional
  • An option inside of a drop-down menu.
  • Examples: Small, Medium, Large

Option Name 3

  • Optional
  • The label of a drop-down menu.
  • Each pair of an Option Name # and Option Value # creates a variant. Add a new row for every possible combination of options in the product. For more help, see Formatting variants for the import.
  • Example: Sleeve Length

Option Value 3

  • Optional
  • An option inside of a drop-down menu.
  • Examples: Long Sleeve, Short Sleeve

Price

  • Optional
  • The price of the product or variant.
  • Enter numbers and decimal points (.) only. After the import, prices will display in your store’s currency.
  • Example: 10 or 10.50

Sale Price

    • Optional
    • If the product is on sale, this is its sale price.
    • Only enter a sale price if the sale status is set as TRUE (next column).
    • Leave this field blank to only display the standard price.
    • Enter numbers and decimal points (.) only. After the import, prices will display in your store’s currency.
    • Example: 7 or 7.50
Note: Sale price must be lower than listed price.

On Sale

  • Optional
  • The product or variant’s sale status. Enter TRUE if the product or variant should display a sale price.
  • If the status is TRUE, the product will display a Sale label, the sale price, and the original price with a strikethrough. See an example.
  • Leave the field blank to only display the standard price.

Weight

  • Optional
  • Enter numbers and decimal points (.) only. After the import, dimensions will match your store’s measurement standard.
  • Example: 5 or 5.5

Length

  • Optional
  • Enter numbers and decimal points (.) only. After the import, dimensions will match your store’s measurement standard.
  • Example: 5 or 5.5

Width

  • Optional
  • Enter numbers and decimal points (.) only. After the import, dimensions will match your store’s measurement standard.
  • Example: 5 or 5.5

Height

  • Optional
  • Enter numbers and decimal points (.) only. After the import, dimensions will match your store’s measurement standard.
  • Example: 5 or 5.5

Stock

  • Optional
  • The number of products or variants in stock. Enter unlimited for items with unlimited stock.
  • Example: 35
Tip: Adding data to optional columns will help you have a more complete Products Page after importing. However, you may find it helpful to only complete the required columns and leave the optional columns blank. You can always add the rest of the product information on the Products Page later.

Formatting variants for the import

Variants are variations of a product with different attributes, like size or color. Learn more about basic and complex variants.

If your product has variants, enter a new row in the .csv for each possible combination of options. Complete all relevant fields for the main item, then create a new row for each variant, repeating the same Product URL. This lets Squarespace import them as different versions of the same product, and adds them to drop-down menus on the same product item page.

For each variant, keep these fields blank so they inherit the same values for the main item:

  • Title
  • Short Description
  • Product Type
  • Tags
  • Categories
  • Hosted Image URLs

You can complete all other optional columns for each variant.

Note: A single product can have up to 100 variants.

Completing the combination rows

For example, you’re selling a tote bag that comes in blue and red. On your site, this product will have one Color drop-down menu.

  • First variant row: Enter Color as Option Name 1, then Red as Option Value 1.
  • Second variant row: Enter Color as Option Name 1 and Blue as Option Value 1.

Variant_example_-_Handbag.png

As another example, you’re selling a shirt that comes in black or white, and you sell sizes Medium or Large. On your site, this product will have two drop-down menus: Color and Size. You’ll create four variant rows to cover the different combinations:

Untitled_spreadsheet_-_Google_Sheets.png

As a third example, you’re selling a shoes that come in brown or black, sizes 6 through 10, and M or W width. On your site, this product will have three drop-down menus: Color, Size, and Width. You’ll create many rows that cover the different combinations of options. The first few rows should look like this:

Variant_Example_-_Shoes.png

Adding more columns

To add more drop-down menus and variants, insert multiples of two columns to the right of Option Value 3. The columns must follow the sample pattern: Option Name 4, Option Value 4, and so on.

Step 4 - Upload the file

  1. Drag and drop the completed .csv into the Add a file box.
  2. Click Begin Import.
  3. When the import is complete, a Success message will display in the Import/Export panel.

Step 5 - Enable your content

Your imported content will appear in a new Products Page in the Not Linked section of the Pages panel. This page is disabled by default. This means that it's hidden from your navigation menus, and visitors can't see it until you're ready to move and enable it.

Tip: If you don't see a Imported Products page in the Pages panel, refresh your browser.

not_linked_section.jpg

Next steps

From here, you can customize the Products Page:

FAQ

Why did my import fail?

If your import failed, review your completed .csv file to ensure that all fields are properly formatted.

Check that:

  • All column headers match the table above.
  • All rows follow the formatting rules in the table above.
  • The file doesn't have any columns or headers other than those shown above, with the exception of extra Option Name or Option Value columns.
  • All variants of a product share the same product URL and are listed in adjacent rows.
  • The required columns of each product row are complete.
  • The file is saved as a .csv (comma-separated values), not .scsv or tsv.

Fix any of the issues above, save the file as a .csv, and try importing again.

What if I accidentally imported the sample products?

If the products from the example rows in the .csv imported, you can delete them.

Can I import products from another Squarespace site?

Yes. To import products from one Squarespace site to another, you’ll need to complete the .csv manually based on your Products Pages. Squarespace doesn’t support exporting products to a .csv.

Will importing more .csv files erase any existing products on my site?

No. You can import as many .csv files as you need. Each import creates a new Products Page in the Not Linked section of your site.

Can I import customers?

No. Products via .csv only supports product imports.

Can I import alt text for product images?

No. Products via .csv doesn’t support alt text, but you can add this to your product images after importing.

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

Yes. Products via .csv supports up to 200 main products. Each product can support up to 100 variants.

Was this article helpful?
4 out of 10 found this helpful
Importing products from a .csv