GA4 to Excel

Sessions, total users and key events from Google Analytics 4, by any dimension your property has, in a worksheet in your own OneDrive.

  • Each report writes to a worksheet you choose, in a workbook in your OneDrive.
  • Refreshes every week on Free, every day on Plus, every 6 hours on Pro and every hour on Max.
  • Up to 30,000 rows a report.

Your first scheduled report starts 30 days of Plus, free. No card needed.

Sign in with Google or a work or school Microsoft account, then connect Excel. You only need Google for a Google source such as GA4.

Google Analytics 4
Microsoft Excel

How to connect GA4 to Excel

To get Google Analytics 4 to Excel you need a work or school Microsoft account with OneDrive, and access to the GA4 property.

  1. 01On the Sources page, choose Connect Google and sign in with the Google account that can see your GA4 property.
  2. 02In Fresh Sheets, go to Destinations, choose Connect Microsoft Excel and sign in with your work or school Microsoft account.
  3. 03Choose New report, pick Google Analytics 4 and the account, then the fields and date range.
  4. 04Under Destination, pick the workbook and worksheet. Under Schedule, pick how often. Then Save and run.

Columns Google Analytics 4 writes to Microsoft Excel

Row one holds the column names. Money shows its currency symbol when a report has only one currency.

ColumnFormat
DateDate
Channel groupText
Session sourceText
Session campaignText
CountryText
Device categoryText
SessionsWhole number
Total usersWhole number
ConversionsNumber
Total revenueMoney
Key eventsNumber
Engagement ratePercentage
Avg. session durationNumber
Bounce ratePercentage
Cart-to-view ratePercentage
Purchase-to-view ratePercentage

These are common fields. You can choose any dimension or metric your property has, including custom dimensions, custom metrics and key events.

An example

Insert a PivotTable on a separate worksheet that reads from the Sessions by channel worksheet, with Channel group in Rows and Sessions in Values.

Scheduling and refresh

How often depends on your plan: every week on Free, every day on Plus, every 6 hours on Pro and every hour on Max.

Each run that succeeds counts once towards your plan, wherever it sends.

Each run replaces the worksheet with the latest figures.

Other ways to do it

GA4 can download a report as a CSV or PDF file, or export it to Google Sheets, from Share this report.

Source: Analytics Help: Share and export reports

This GA4 Excel integration writes the report straight into your worksheet instead.

What Fresh Sheets touches

Only the worksheets your reports use

While you choose where a report goes, Fresh Sheets reads the names of the files and folders in your OneDrive and shows you only folders and workbooks. When a report refreshes, it reads and replaces that report's own worksheet. It creates a new workbook only when you ask it to, and doesn't change or delete anything else in your OneDrive.

FAQ

Questions

How do I export data from GA4 to Excel?

Connect Google on the Sources page and Microsoft Excel on the Destinations page, then build a GA4 report that writes to a worksheet in your workbook. It refreshes on the schedule you pick, so there's no file to download each time.

How do I automate GA4 reports?

Build the report once and pick how often under Schedule. How often depends on your plan, and each run replaces the worksheet with the latest figures.

Get your GA4 data into Excel

Excel is on every plan, Free included. Sign in on the web with Google or a work or school Microsoft account, connect Microsoft Excel and build your first report.

Your first scheduled report starts 30 days of Plus, free. No card needed.

Sign in with Google or a work or school Microsoft account, then connect Excel. You only need Google for a Google source such as GA4.

Paid plans from £12 a month, billed annually. After 30 days, choose a plan or stay free: one report keeps refreshing weekly, the rest pause, and nothing is deleted.