File Formats for Exporting Product Data

Ablestar Bulk Product Editor allows several options and file formats to export your Shopify product data to a spreadsheet. Each option has pro's and con's, depending on the type of content you are working with.

CSV File

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 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 the CSV 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.

Excel files are also compressed so beneficial if you uploading a lot of data.

Learn how to increase speed on uploads by skipping unchanged values on spreadsheets.

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.

Tab Separated TSV

The Google Shopping Feed generates a 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)