Export a report

Analytics

Needed permissions: owner, manage, edit & publish, edit or view

When you want to use your data in a spreadsheet or other tool, you can export it from a report. In this article, we’ll explain how.

To export data from a report, follow these steps:

  1. Go to Menu > Analytics.
  2. Navigate to Reports or Custom reports.
  3. On the left, pick a report you want to work with.
  4. Choose dates for your data export.
    Export a report (dates)
  5. In the right upper corner, click Export.
    Export a report (click on a button)
  6. In some report types, you can choose to: Export chart data or Export table data.
  7. In the dialog window, you can choose additional export options:
    • Report type: CSV, XML, JSON, JSON (KV)
    • Use column names instead of IDs
    • Export only this level of the nested table (only in reports with nested tables)
    • Set the row limit
    Export a report in Piwik PRO

    Tip: If you want to use data in a spreadsheet, you can export the report to a CSV or XML file. For more advanced tools, use a JSON or JSON (KV) file format.

  8. Click OK.
  9. Click Download now once the file is ready.
  10. Open the exported file in a spreadsheet — Excel, Google Spreadsheet, Numbers or the like.

    Note: For an advanced export, you can use API.

Was this article helpful?

Technical support

If you still have some questions, visit our community.
There’s always someone ready to help!

Back to help center