How to Make an AdSense Earnings Chart in Excel or Google Sheets (2026)

In 2005 every blogger seemed to show off neat graphs of their AdSense income, but few explained how they made them. We followed a simple method shared by another blog: download your earnings as a CSV file and chart it in Microsoft Excel. It worked well then and still does. Here is how to build an AdSense earnings chart in Excel or Google Sheets in 2026, plus the two tips from that original method that still save you from a messy graph.

Quick answer: In AdSense, open Reports, pick or build a report by date, click the three-dot menu next to Save and choose Export to Google Sheets, Download as Excel spreadsheet or Download as CSV. Open the file, delete any Totals row, select the date column plus the metric you want (earnings, page RPM, CTR) and insert a line chart. Use a column chart for monthly totals.

Why chart your AdSense data?

The AdSense dashboard already has graphs, but your own chart lets you compare years side by side, add notes for site changes, combine AdSense with other income and keep a record beyond the report date ranges you check every day. It is also the easiest way to spot seasonal dips (many sites see earnings rise toward the end of the year) before you panic about a bad week.

Step 1: Export your AdSense report

Google’s help page on exporting AdSense reports lists three options:

1. Sign in to Google AdSense and click Reports.
2. Choose a report and set the date range and breakdown (by day or by month).
3. Click the three-dot menu next to Save.
4. Pick Export report to Google Sheets, Download report as Excel spreadsheet (XLSX) or Download report as CSV file.

If you want figures in rupees, euros or another currency, change the reporting currency first; see how to change AdSense report currency.

Step 2: Clean the data

These two tips from the original 2005 method still matter:

• Remove the Totals row. A summary row at the bottom makes the y-axis jump so high that daily changes look flat. Delete it so only daily or monthly figures are charted.
• Keep the date column, fix the header only if needed. Older guides told you to delete the “Date” heading so Excel would treat the column as labels. Modern Excel and Sheets usually detect dates correctly, so keep the column and only edit the heading if your chart plots dates as a data series. Don’t delete the whole date column, as we did by mistake back then.

Also check that numbers are stored as numbers, not text (currency symbols in a CSV can cause this), and sort by date oldest first.

Step 3: Build the chart

In Microsoft Excel

1. Select the date column and one metric column (hold Ctrl to select non-adjacent columns).
2. Go to Insert and choose a Line chart for daily data or a Column chart for monthly totals. Recommended Charts will also suggest options.
3. Add a chart title and axis titles, and right-click the line to add a trendline (a moving average smooths noisy daily data).

In Google Sheets

1. Export straight to Google Sheets or import the CSV.
2. Select the date and metric columns, then Insert > Chart.
3. In the chart editor, choose Line or Column, and customize colours, titles and a trendline.

Useful charts to make

• Daily earnings with a 7-day moving average to see the real trend.
• Monthly earnings by year as clustered columns to compare seasons.
• Page RPM over time to see whether traffic or ad value changed.
• Earnings vs page views on two axes (combo chart).

When a chart shows a sudden drop, check why AdSense ads may not be showing; when it shows a spike in clicks without matching traffic, review invalid click activity. Before publishing a chart of your stats online, check the confidentiality section of the AdSense Terms and Conditions.

FAQ

Can I download AdSense reports as Excel?

Yes. AdSense offers Excel (XLSX) and CSV downloads plus a direct export to Google Sheets.

Why does my chart look flat?

Usually a Totals row is included in the data. Delete it and re-select the range.

Which chart type is best for AdSense earnings?

A line chart works best for daily data; a column chart is clearer for monthly or yearly totals.

Can I automate the chart?

AdSense lets you save and schedule reports, and exporting to Google Sheets keeps the data in Drive where you can build on it.