How do I export GA4 data to Excel or Google Sheets?

by · Published · Updated

Applies to: Google Analytics 4 (GA4)
Last updated: May 2025

Problem

You want to share or further analyze GA4 data in Excel or Google Sheets, but the export options aren’t as obvious or flexible as in Universal Analytics.

Solution

GA4 provides several methods to export data, including native exports from reports, the Google Analytics Add-on for Google Sheets, and advanced exports using BigQuery. The right method depends on your needs—quick download vs. automated updates.

Option 1: Export from GA4 Report Interface

Step 1: Open the Desired Report

Step 2: Export Data

  • Click the Share icon (upper-right) of the report
  • Choose Download file
    • Format options:
      • CSV (open in Excel)
      • PDF (for static sharing)

This method exports only the visible data (up to ~5,000 rows).

Option 2: Use the Google Analytics Add-on for Google Sheets

Ideal for scheduled, query-based exports.

Step 1: Install the Add-on

  1. Open Google Sheets
  2. Go to Extensions > Add-ons > Get Add-ons
  3. Search for Google Analytics and install it

Step 2: Authorize and Create a Report

  1. Go to Extensions > Google Analytics > Create new report
  2. Choose your GA4 property
  3. Set dimensions and metrics (e.g., pagePath, sessions, eventName)
  4. Click Run Reports to pull the data

This add-on supports scheduled refreshes and multiple queries.

Option 3: Export to BigQuery (Advanced Users)

For high-volume, raw data access:

  1. Go to Admin > BigQuery Links
  2. Link your GA4 property to a BigQuery project
  3. GA4 will automatically export daily event-level data
  4. Use BigQuery SQL queries to analyze and export results to:
    • Google Sheets
    • CSV files
    • External tools like Excel

Notes

  • CSV exports are best for quick snapshots
  • Google Sheets Add-on is great for automated dashboards
  • BigQuery is ideal for custom, large-scale analysis
  • You can also connect GA4 to tools like Looker Studio, Power BI, or Supermetrics for ongoing reporting

Tags:

You may also like...