CSV Files

CSV stands for Comma Separated Value, which is a file format (like .doc, .jpg, .xls, .csv) for spreadsheets. Shopify accepts the import and export of CSV files for the Products, Orders (export only), and Customers of your store.

This is useful for stores that:

  • are switching to Shopify from another e-commerce platform
  • have a list of loyal Customer Accounts
  • prefer to upload Products via a spreadsheet
  • temporarily have limited internet connectivity.

Click to learn more about:

Import a CSV file into Google Sheets

When you export a CSV file from your Shopify admin, it opens as a .csv file in your computer's native text editor. You can also use an alternative text editor, but it's recommended that you use a spreadsheet program to view and edit your CSV files instead.


You can download Shopify's sample CSV templates for products and customers.

Shopify recommends using Google Sheets to view a formatted version of your CSVs. To use Google Sheets, you must import the CSV file in to the program, then export it as a .csv file to your computer.

To import a .csv in to Google Sheets:

  1. Log in to your Google account.

  2. On the Google Sheets page, click Blank in the Start a new spreadsheet section:

    Sheets start blank

  3. From the Untitled Spreadsheet page, go to File > Import...:

    File import

  4. Locate and select the CSV file that you want to edit.

  5. In the Import file dialog, select your preferred options under the Import action, Separator character, and Convert text to numbers and dates sections.

  6. Click Import:

    Import file dialog

Your CSV will look similar to this after you've uploaded it:

Csv sheets example

From here you can edit your CSV. When you are done, you can export it from Google Sheets as a .csv file.

Advanced: CSV product imports with shipping required and taxable variants

If you need to edit the settings for a large number of products, you might want to perform a bulk update. For this, export the products that need to be updated as a .csv file, then edit the columns shown in the table:

Variant Requires Shipping Set to true or left blank if the variant is a tangible item. Set to false otherwise.
Variant Taxable Set to true or left blank if the variant is taxable. Set to false otherwise.
Variant Grams Enter a non-zero value if Variant Requires Shipping is set to true or left blank.
Leave blank or set to zero if Variant Requires Shipping is set to false.

When you've finished editing your .csv file, import it to your store. Be sure to check the option: Overwrite existing products that have the same handle.

Want to discuss this page?

Visit the Shopify Community

Ready to start selling online with Shopify?

Try it free