Export statistics to CSV for Excel and Google Sheets
Every important table has a CSV button. The files open directly in Excel, LibreOffice and Google Sheets.
The exports
| Where | File content |
|---|---|
| Pages → CSV | Every page with page views, visitors, average time, entries, bounces and exits |
| Sources → CSV | Channel, source, visits and visitors |
| Locations → CSV | Country code, country, visits and visitors |
| Visits → CSV | One row per visit: start, duration, page views, country, IP, new visitor, channel, source, referrer, entry and exit page, device, browser, system, language, user agent |
| Settings → Data → Export last 30 days | Raw data: one row per page view with all stored fields (including UTM terms, screen size, time zone, scroll depth, page title) |
| Settings → Data → Export daily totals | One row per day: visitors, visits, page views, bounces, new visits |
Details
- The period is the one selected in the Choosing the date range of a report (daily totals: all days; raw data: last 30 days; at most 400 days per export).
- Files are UTF-8 with a byte-order mark, so accented and non-Latin characters show correctly in Excel.
- Values that start with
=,+,-or@are prefixed with an apostrophe so a spreadsheet never executes them as formulas. - Only logged-in administrators can download exports.
Ideas
- Build your own pivot tables and charts in a spreadsheet.
- Join the daily totals with sales data to calculate revenue per visitor.
- Archive monthly raw data before you delete it (Your data: where statistics are stored, backup and deleting data).
Last updated