Exporting reports

You can export your reports to a different file format from your Shopify admin. Exported reports are saved in the default downloads folder on your device. After the download is complete, you can open the report using a spreadsheet program, such as Excel or Numbers, or a text editor.

You can export most reports in any of the following file formats:

  • Comma Separated Values (CSV)
  • Extensible Markup Language (XML)
  • JSON Lines (JSONL)
  • Apache Parquet (.parquet)

For some of the legacy Finances reports (Sales, Taxes, and Payments), the default file format is a CSV, but you can select the type of report to export:

  • Current page exports data for the columns that are currently displayed.
  • Full report exports data for all the displayed columns, but includes additional columns that aren't displayed by default.

If you want a PDF file of a report, then you can print the report instead of exporting.

Export a report

You can export a report to your device. Exported report files are saved in your default downloads folder.

Steps:

Desktop
  1. From your Shopify admin, go to Analytics > Reports.

  2. Click the report that you want to export.

  3. Click > ↥ Export.

  4. If available, in the Export report dialog, select the file format that you want to use.

  5. Click Export.

iPhone
  1. From the Shopify app, tap Overflow menu , and then tap Analytics.
  2. Tap Reports.
  3. Tap the report that you want to export.
  4. Tap > Export.
  5. If available, in the Export report dialog, select the file format that you want to use.
  6. Tap Export.
Android
  1. From the Shopify app, tap Overflow menu , and then tap Analytics.
  2. Tap Reports.
  3. Tap the report that you want to export.
  4. Tap > Export.
  5. If available, in the Export report dialog, select the file format that you want to use.
  6. Tap Export.

To export a report to a PDF file, you can print the report instead of exporting it.

On a device that uses Windows 10 or higher, or on a Mac, you can automatically save to PDF when printing. For earlier versions of Windows, you need to install a PDF printer or converter, such as Adobe Acrobat Reader.

Steps:

Desktop
  1. From your Shopify admin, go to Analytics > Reports.

  2. Click the report that you want to export.

  3. Click > Print.

  4. In the Print dialog, set your preferred printing settings.

  5. Click Save or Print.

iPhone
  1. From the Shopify app, tap Overflow menu , and then tap Analytics.
  2. Tap Reports.
  3. Tap the report that you want to export.
  4. Tap > Print.
  5. In the Print dialog, set your preferred printing settings.
  6. Tap Save or Print.
Android
  1. From the Shopify app, tap Overflow menu , and then tap Analytics.
  2. Tap Reports.
  3. Tap the report that you want to export.
  4. Tap > Print.
  5. In the Print dialog, set your preferred printing settings.
  6. Tap Save or Print.
Can’t find the answers you’re looking for? We’re here to help.