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 the button, 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 the button, 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 the button, 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 the button, 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.