Import data via CSV upload

You can import historical analytics data into Pageviews using CSV files. This is useful if you're migrating from another analytics tool or have data exported in spreadsheet format.

How to import

  1. Go to Site Settings → Imports.
  2. Click the Upload CSV button.
  3. Upload one or more CSV files for the data types you want to import (see below).
  4. Set the date range that the CSV data covers.
  5. Click Start Import.

{screenshot: CSV upload modal with file inputs}

Supported CSV file types

You can upload any combination of the following files. All files are optional — upload only what you have:

Daily Stats (visitors & pageviews)

Columns: date, visitors, pageviews

date,visitors,pageviews
2024-01-01,150,420
2024-01-02,175,510

Pages

Columns: date, path, visitors

date,path,visitors
2024-01-01,/,80
2024-01-01,/pricing,45

Traffic Sources

Columns: date, source, medium, visitors

date,source,medium,visitors
2024-01-01,google,organic,90
2024-01-01,twitter,social,30

Countries & Cities

Columns: date, country, city, visitors

date,country,city,visitors
2024-01-01,US,New York,40
2024-01-01,GB,London,25

The country column must use two-letter ISO country codes (e.g., US, GB, DE). Rows with invalid country codes will have the country set to blank.

Devices, Browsers & OS

Columns: date, device_type, browser, os, visitors

date,device_type,browser,os,visitors
2024-01-01,Desktop,Chrome,Windows,65
2024-01-01,Mobile,Safari,iOS,40

File format requirements

  • Files must be CSV format with .csv or .txt extension.
  • The first row must be the column headers.
  • Dates must be in YYYY-MM-DD format (e.g., 2024-01-15).
  • Numeric values (visitors, pageviews) must be whole numbers.

Viewing imported data

Once the import is complete, the data is merged with your native Pageviews data. Select a date range in the dashboard that covers the imported period to see the combined results.

Limitations

  • The same limitations as Google Analytics imports apply — imported data is aggregate, so cross-day visitor deduplication isn't possible.
  • Only the data types listed above are supported. Custom events, goals, and session-level metrics cannot be imported via CSV.

Deleting an import

To remove imported CSV data, go to Site Settings → Imports, find the import in the list, and click the delete button. Only the imported data is removed — your native data remains untouched.