File formats for exporting product data

You have several options when exporting your Shopify product data to a spreadsheet:

CSV File for Excel

CSV files are a very common format, and many applications support them. If you plan to modify the spreadsheet manually, we recommend using the CSV File for Excel format.

This is a standard CSV file, except long numeric IDs will be preserved and not converted to scientific notation. In other words, Excel will often switch a number like 30111927763025 into 3.01E+13. Using this format prevents this.

Excel Format

Not as many programs support the Excel format; however, the format has better support for non-English characters (like д, ü, or 商). If you need a way to edit Excel files, you can use Google Sheets for free.

Matrixify Excel (formerly Excelify)

An Excel file in the same format as a product export from Matrixify. Files can be re-uploaded to the Bulk Product Editor however we're still working on supporting the 'command' columns

Matrixify CSV Zip (formerly Excelify)

A zip file containing Products.csv and Export Summary.csv in the same format as a product export from Matrixify. As with the Matrixify Excel format, files can be re-uploaded to the Bulk Product Editor but we're still working on supporting the 'command' columns.

Plain CSV File

This is a plain CSV file that's best used if you're sending the spreadsheet to another program that needs to read numeric IDs.

Google Shopping Feed

This generates a tab-separated (TSV) file that can be added to Google Merchant Center. The individual fields for a product are extracted from product fields and metafields.

(03.116)