How to Convert a Google Analytics Export CSV to Excel

To convert a Google Analytics (GA4) export CSV to Excel, export the report from GA4 as a CSV file, then open it in Excel or convert it with a free online converter. The result is a spreadsheet you can sort, filter, chart, and share — far easier to read than the raw export.

GA4 does not export directly to Excel. Every GA4 download is a CSV (or PDF). The conversion step is what turns that export into a workbook you can actually work with: clean column headers, numeric metrics, sortable dates, and charts built from your own traffic data.

Why Convert GA4 Exports to Excel?

GA4's built-in interface is good for exploring data, but it is not always the best place to build a report. Converting to Excel helps when you need to:

• Build a client or manager report. A formatted Excel sheet with your top pages, traffic sources, and conversions is easier to share than a GA4 screenshot.
• Compare periods. Put this month and last month side by side, or combine several exports into one trend table.
• Clean the data. GA4 exports often include rows such as "(not set)" and "(other)" that need explaining or filtering before a report goes out.
• Chart the numbers. Excel charts — line charts for sessions over time, bar charts for traffic sources — turn a table of numbers into a story.
• Combine with other data. Merge GA4 traffic with sales, ad spend, or email data to see the full picture in one workbook.

If you report on traffic regularly, a repeatable export-and-convert routine saves time every month.

What Is Inside a GA4 CSV Export?

A GA4 export is a flat table. The first columns are usually dimensions — things like Date, Page path, Session source, Country, or Device category. The remaining columns are metrics — numbers such as Sessions, Users, Views, Engagement rate, Conversions, and Revenue.

Common quirks of GA4 CSV exports:

• Header rows. Some exports include extra header or title lines above the column names. Excel will treat those as data unless you remove them.
• "(not set)" rows. GA4 uses "(not set)" when it could not determine a dimension value. These rows are real, but they usually need a note in a report.
• "(other)" rows. When a report has many distinct values, GA4 groups the smallest ones into "(other)". This row is an aggregate, not a single page or source.
• Percentages as text. Engagement rate and similar metrics may export with a percent sign, which Excel treats as text until you convert it.
• Dates as plain text. GA4 dates often export as 20261005 or Oct 5, 2026, which Excel may not recognize as dates until you reformat them.

Knowing these quirks in advance makes cleanup fast. You are not fixing broken data — you are reshaping GA4's export format into a spreadsheet format.

Step 1: Export a Report From GA4 as CSV

Export a Standard Report

1. In GA4, open Reports and choose the report you need — for example, Traffic acquisition or Pages and screens.
2. Set the date range in the top right.
3. Click the Share icon (the download arrow) at the top of the report.
4. Choose Download CSV. The file downloads to your computer.

Export an Exploration

1. In GA4, open Explore and open or build your exploration.
2. Click the download icon in the exploration toolbar.
3. Choose the CSV format. The export downloads the current exploration table.

Export Tips

• Set the date range first. GA4 exports only the visible date range, so confirm it before downloading.
• Note the report name and date range in the file name when you save it, such as ga4-traffic-acquisition-2026-09.csv. You will thank yourself when you have six exports in one folder.
• Check the row count. If a report shows more rows in GA4 than in the exported file, the export may have been truncated. Re-export with a narrower date range or a filter to get a complete file.
• Keep the original export. Work on a copy so you can always re-export or compare against the source.

Method 1: Convert With a Free Online Converter (Fastest for One-Off Reports)

For a quick conversion:

1. Go to the CSV to Excel converter.
2. Upload your GA4 CSV export.
3. Download the XLSX file.
4. Open it in Excel and run the cleanup steps below.

GA4 exports are usually not sensitive at the level of individual users — they are aggregate counts. Even so, if your export contains page paths with personal data in URLs, or if your organization's policy restricts uploading analytics data, convert it locally with Excel or Google Sheets instead. When in doubt, keep analytics files on your own machine.

Method 2: Open the GA4 CSV Directly in Excel

Excel can open a GA4 CSV directly, but the import preview gives you more control:

1. In Excel, go to Data > From Text/CSV.
2. Select your GA4 CSV file.
3. In the preview, confirm the delimiter (usually comma) and that headers are detected.
4. If the export has extra title lines above the real headers, remove them after loading, or adjust the import so the header row is the first row.
5. Set metric columns to Number type and date columns to Date type in the preview if Excel misreads them.
6. Click Load and save as XLSX.

The preview step is where you prevent the most common problems: dates that sort alphabetically, percentages stored as text, and numbers with thousands separators that Excel treats as text.

Method 3: Build a Repeatable Report With Power Query

If you export the same GA4 report every month, Power Query turns the monthly chore into a refresh:

1. Save each month's GA4 export into one folder with a consistent name pattern, such as ga4-traffic-2026-09.csv.
2. In Excel, load one export with Data > Get Data > From File > From Text/CSV.
3. In the Power Query Editor, remove extra header lines, set column types, and rename columns to plain names such as Date, Source, Sessions, Conversions.
4. Close and load to a worksheet.
5. Next month, replace the source file and click Data > Refresh All.

For a year of monthly exports, combine the files instead of loading them one by one. The guide on combining multiple CSV files with Power Query shows how to merge a folder of CSVs into one table.

Cleaning Up the Converted GA4 File

Remove Extra Header and Title Lines

Some GA4 exports put a report title or a date-range line above the column headers. Delete those rows so the header row is row 1. Then turn on filters with Ctrl+Shift+L.

Fix Dates

GA4 dates may export as 20261005 (YYYYMMDD) or as text such as Oct 5, 2026. To make them sortable:

1. Select the date column.
2. If the values are YYYYMMDD numbers, use Data > Text to Columns, choose Date, and select the YMD format.
3. If the values are month-name text, use Text to Columns with Date format MDY, or use a formula to parse them.
4. Format the column as a real date and confirm the dates sort oldest to newest.

A date column that sorts alphabetically — April before August before December — is still text. Convert it before charting, or your trend chart will be wrong.

Fix Numbers and Percentages

Metrics such as Sessions, Users, and Views should be numbers. If they align left and will not sum, they are stored as text. Select the column, set the format to Number, and use Text to Columns to force conversion. Remove thousands separators if Excel stored them as text.

Engagement rate and similar percentages may export with a % sign. Select the column, set the format to Percentage, and confirm the values look right — a value stored as 52 with a percent format shows as 5200%, which means the underlying value needs dividing by 100. Check one value against the GA4 interface to confirm.

Handle "(not set)" and "(other)" Rows

Do not delete these rows silently. They represent real traffic that GA4 could not classify or grouped for size. In a report, either:

• Keep them with a short note explaining what they mean, or
• Filter them out and state clearly that the totals exclude "(not set)" and "(other)" rows.

If you filter them out without saying so, your report totals will not match GA4's totals, and someone checking your work will find a gap.

Rename Columns for Readers

GA4 column names can be technical. Rename them to plain language for a shared report: "Session source / medium" becomes "Traffic source", "Event count" becomes "Events", and so on. Keep a note of the original names if you need to match the report back to GA4 later.

Building Charts and a Simple Report From the Converted File

Sessions Over Time

1. Select the Date and Sessions columns.
2. Go to Insert > Line Chart.
3. Add a chart title with the date range, such as "Sessions, September 2026".

Traffic Sources

1. Select the source and Sessions columns.
2. Go to Insert > Bar Chart and sort descending.
3. Add data labels so readers see the numbers without guessing.

Top Pages

1. Select the Page path and Views columns.
2. Sort by Views descending.
3. Keep the top 10 or 20 rows for a summary table, and keep the full table on a separate sheet.

Comparing Periods

To compare two months, convert both exports, then place them side by side in one sheet with a Month column, or build a pivot table with Month in Columns and the metric in Values. For a walkthrough of pivot tables after a CSV conversion, see the guide on creating a pivot table after converting CSV to Excel.

Common Mistakes With GA4 CSV Exports

Charting Text Dates

If dates are still text, a line chart will plot them in alphabetical order, not calendar order. Always convert dates to real date values before charting.

Mixing Metrics That Do Not Add Up

Some GA4 metrics are not additive. Users counted across two months is not the sum of each month's users, because the same person can appear in both months. Sessions and views add up across periods; users and engaged sessions often do not. Say which metrics you summed and which you did not.

Deleting "(not set)" Rows Without a Note

Removing "(not set)" rows changes totals. If you remove them, say so in the report. If you keep them, add one line explaining what "(not set)" means.

Comparing Different Date Ranges Without Saying So

A report that compares "this month" to "last month" must use equal-length periods. Comparing a 31-day month to a 28-day month without adjusting will make the shorter month look worse. Use equal date ranges or show daily averages.

Forgetting the Export Is a Snapshot

A GA4 export is a snapshot of the data at download time. GA4 data can change as late events arrive. If you re-export the same range later, the numbers can shift slightly. Date your exports and note when they were downloaded.

Frequently Asked Questions

Can Google Analytics export directly to Excel?

No. GA4 exports CSV (or PDF). You convert the CSV to Excel by opening it in Excel, using Power Query, or using an online converter such as the CSV to Excel converter. The result is a standard XLSX workbook.

Why does my GA4 export have extra header rows?

Some GA4 exports include a report title or date-range line above the column headers. Delete those rows so the header row is row 1, then turn on filters. The data itself is unaffected.

Why do my GA4 dates sort alphabetically instead of chronologically?

The date column is stored as text. Convert it to a real date type with Text to Columns or Power Query, then confirm the dates sort oldest to newest before charting.

What does "(not set)" mean in a GA4 export?

"(not set)" means GA4 could not determine a value for that dimension on those sessions or events. The rows are real traffic. Keep them with a note, or filter them out and state clearly that totals exclude them.

Is it safe to upload a GA4 export to an online converter?

GA4 exports are aggregate counts, not individual user records, so they are lower risk than customer files. Even so, if the export contains page paths with personal data in URLs, or if your organization's policy restricts it, convert the file locally with Excel or Google Sheets.

Final Checklist

Before you share a GA4 report built from a converted export:

• Header row is row 1, with no title lines above it.
• Dates are real dates and sort chronologically.
• Metrics are numbers and sum correctly.
• "(not set)" and "(other)" rows are handled with a note.
• Charts use date order, not alphabetical order.
• The date range and download date are stated on the report.
• The original GA4 export is saved as a backup.

If every check passes, your GA4 report is ready to share.