Export to CSV

Overview

Any search can be exported to a CSV file simply by clicking the Export button in the upper right corner of the screen.

The export file will contain a row for each store matching the current search. To export all stores that your plan has access to, simply click the Export button without adding any search filters. Be careful when exporting a large number of stores since it is very easy to generate a file that is too big to open in Google Sheets or Microsoft Excel.

Note: The export feature is only available on the Pro, Elite or Enterprise plans.

Export Columns

After clicking the Export button, you will see the Export dialog which is used to select which columns to includes in the CSV file. The dialog also lets you configure various export options.

Click the columns that you want to include in the CSV file, then click the Export button in the bottom-right corner of the dialog box to start the export. If you are running a large export (several million stores), then it can take several minutes for the export to begin. If you are only exporting a few hundred thousand stores (or fewer), then it should take less than 1 minute to generate your CSV file.

Note that there are over 100 columns that can be included in the CSV file. Columns are grouped together to make them easier to find. If you're interested in product data, for instance, then be sure to click the "Product Fields" section to see the full list of product-related columns that can be included in the CSV file.

Export Options

Open the Export Options section to reveal options that modify the content of the CSV file.

The following options are available.

• Only include a single email per store
  Check this option to include only a single email per store in the CSV file.
• Excel Support
  Check this option if you plan to open the CSV file in Excel. This fixes language encoding issues when opened in Excel.
• Do not export every merchant subdomain
  Check this option to include only a single subdomain per merchant. For instance, if a merchant has several domains (e.g., www.merchant.com, merchant.ca and www.merchant.co.uk), then only the first subdomain will be included in the CSV file.
• Do not include currency symbols
  Prevents inclusion of currency symbols in the CSV file in columns that represent money. Currency symbols should be removed if you plan to do mathematical operations on these columns.
• Multiple value separator
  If a column contains multiple values (for instance, the list of Shopify Apps installed on the store), this value will be used to separate each value within the column. By default, values are separated within a colon. (:)