{"id":146,"date":"2005-04-20T20:15:00","date_gmt":"2005-04-20T14:45:00","guid":{"rendered":"https:\/\/www.quickonlinetips.com\/archives\/2005\/04\/20\/create-adsense-earning-charts-graphs-with-excel\/"},"modified":"2026-10-21T15:11:10","modified_gmt":"2026-10-21T09:41:10","slug":"create-adsense-earning-charts-graphs-with-excel","status":"publish","type":"post","link":"https:\/\/www.quickonlinetips.com\/archives\/2005\/04\/create-adsense-earning-charts-graphs-with-excel\/","title":{"rendered":"How to Make an AdSense Earnings Chart in Excel or Google Sheets (2026)"},"content":{"rendered":"<p>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 <strong>AdSense earnings chart<\/strong> in Excel or Google Sheets in 2026, plus the two tips from that original method that still save you from a messy graph.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-67721\" src=\"https:\/\/www.quickonlinetips.com\/archives\/wp-content\/uploads\/adsense-earnings-chart-excel-2026.webp\" alt=\"AdSense earnings chart: orange and blue 3D bar chart\" width=\"1200\" height=\"630\" srcset=\"https:\/\/www.quickonlinetips.com\/archives\/wp-content\/uploads\/adsense-earnings-chart-excel-2026.webp 1200w, https:\/\/www.quickonlinetips.com\/archives\/wp-content\/uploads\/adsense-earnings-chart-excel-2026-300x158.webp 300w, https:\/\/www.quickonlinetips.com\/archives\/wp-content\/uploads\/adsense-earnings-chart-excel-2026-1024x538.webp 1024w, https:\/\/www.quickonlinetips.com\/archives\/wp-content\/uploads\/adsense-earnings-chart-excel-2026-150x79.webp 150w, https:\/\/www.quickonlinetips.com\/archives\/wp-content\/uploads\/adsense-earnings-chart-excel-2026-768x403.webp 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/p>\n<p><strong>Quick answer:<\/strong> 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.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_89 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6af00aa14ee0b\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #1a202c;color:#1a202c\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #1a202c;color:#1a202c\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6af00aa14ee0b\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2005\/04\/create-adsense-earning-charts-graphs-with-excel\/#Why_chart_your_AdSense_data\" >Why chart your AdSense data?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2005\/04\/create-adsense-earning-charts-graphs-with-excel\/#Step_1_Export_your_AdSense_report\" >Step 1: Export your AdSense report<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2005\/04\/create-adsense-earning-charts-graphs-with-excel\/#Step_2_Clean_the_data\" >Step 2: Clean the data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2005\/04\/create-adsense-earning-charts-graphs-with-excel\/#Step_3_Build_the_chart\" >Step 3: Build the chart<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2005\/04\/create-adsense-earning-charts-graphs-with-excel\/#In_Microsoft_Excel\" >In Microsoft Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2005\/04\/create-adsense-earning-charts-graphs-with-excel\/#In_Google_Sheets\" >In Google Sheets<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2005\/04\/create-adsense-earning-charts-graphs-with-excel\/#Useful_charts_to_make\" >Useful charts to make<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2005\/04\/create-adsense-earning-charts-graphs-with-excel\/#FAQ\" >FAQ<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2005\/04\/create-adsense-earning-charts-graphs-with-excel\/#Can_I_download_AdSense_reports_as_Excel\" >Can I download AdSense reports as Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2005\/04\/create-adsense-earning-charts-graphs-with-excel\/#Why_does_my_chart_look_flat\" >Why does my chart look flat?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2005\/04\/create-adsense-earning-charts-graphs-with-excel\/#Which_chart_type_is_best_for_AdSense_earnings\" >Which chart type is best for AdSense earnings?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.quickonlinetips.com\/archives\/2005\/04\/create-adsense-earning-charts-graphs-with-excel\/#Can_I_automate_the_chart\" >Can I automate the chart?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Why_chart_your_AdSense_data\"><\/span>Why chart your AdSense data?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>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.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step_1_Export_your_AdSense_report\"><\/span>Step 1: Export your AdSense report<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Google&#8217;s help page on <a href=\"https:\/\/support.google.com\/adsense\/answer\/9830628\" target=\"_blank\" rel=\"noopener\">exporting AdSense reports<\/a> lists three options:<\/p>\n<ol>\n<li>Sign in to <a href=\"https:\/\/adsense.google.com\/\" target=\"_blank\" rel=\"noopener\">Google AdSense<\/a> and click Reports.<\/li>\n<li>Choose a report and set the date range and breakdown (by day or by month).<\/li>\n<li>Click the three-dot menu next to Save.<\/li>\n<li>Pick <strong>Export report to Google Sheets<\/strong>, <strong>Download report as Excel spreadsheet<\/strong> (XLSX) or <strong>Download report as CSV file<\/strong>.<\/li>\n<\/ol>\n<p>If you want figures in rupees, euros or another currency, change the reporting currency first; see <a href=\"https:\/\/www.quickonlinetips.com\/archives\/2013\/12\/adsense-earnings-currency\/\">how to change AdSense report currency<\/a>.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step_2_Clean_the_data\"><\/span>Step 2: Clean the data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>These two tips from the original 2005 method still matter:<\/p>\n<ul>\n<li><strong>Remove the Totals row.<\/strong> 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.<\/li>\n<li><strong>Keep the date column, fix the header only if needed.<\/strong> Older guides told you to delete the &#8220;Date&#8221; 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&#8217;t delete the whole date column, as we did by mistake back then.<\/li>\n<\/ul>\n<p>Also check that numbers are stored as numbers, not text (currency symbols in a CSV can cause this), and sort by date oldest first.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step_3_Build_the_chart\"><\/span>Step 3: Build the chart<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"In_Microsoft_Excel\"><\/span>In Microsoft Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li>Select the date column and one metric column (hold Ctrl to select non-adjacent columns).<\/li>\n<li>Go to Insert and choose a Line chart for daily data or a Column chart for monthly totals. Recommended Charts will also suggest options.<\/li>\n<li>Add a chart title and axis titles, and right-click the line to add a trendline (a moving average smooths noisy daily data).<\/li>\n<\/ol>\n<h3><span class=\"ez-toc-section\" id=\"In_Google_Sheets\"><\/span>In Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li>Export straight to <a href=\"https:\/\/workspace.google.com\/products\/sheets\/\" target=\"_blank\" rel=\"noopener\">Google Sheets<\/a> or import the CSV.<\/li>\n<li>Select the date and metric columns, then Insert &gt; Chart.<\/li>\n<li>In the chart editor, choose Line or Column, and customize colours, titles and a trendline.<\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Useful_charts_to_make\"><\/span>Useful charts to make<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><strong>Daily earnings with a 7-day moving average<\/strong> to see the real trend.<\/li>\n<li><strong>Monthly earnings by year<\/strong> as clustered columns to compare seasons.<\/li>\n<li><strong>Page RPM over time<\/strong> to see whether traffic or ad value changed.<\/li>\n<li><strong>Earnings vs page views<\/strong> on two axes (combo chart).<\/li>\n<\/ul>\n<p>When a chart shows a sudden drop, check <a href=\"https:\/\/www.quickonlinetips.com\/archives\/2012\/01\/google-adsense-bug-showing-no-ads\/\">why AdSense ads may not be showing<\/a>; when it shows a spike in clicks without matching traffic, review <a href=\"https:\/\/www.quickonlinetips.com\/archives\/2012\/12\/google-adsense-invalid-click-activity\/\">invalid click activity<\/a>. Before publishing a chart of your stats online, check the confidentiality section of the AdSense Terms and Conditions.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"FAQ\"><\/span>FAQ<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Can_I_download_AdSense_reports_as_Excel\"><\/span>Can I download AdSense reports as Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes. AdSense offers Excel (XLSX) and CSV downloads plus a direct export to Google Sheets.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Why_does_my_chart_look_flat\"><\/span>Why does my chart look flat?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Usually a Totals row is included in the data. Delete it and re-select the range.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Which_chart_type_is_best_for_AdSense_earnings\"><\/span>Which chart type is best for AdSense earnings?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>A line chart works best for daily data; a column chart is clearer for monthly or yearly totals.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Can_I_automate_the_chart\"><\/span>Can I automate the chart?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>AdSense lets you save and schedule reports, and exporting to Google Sheets keeps the data in Drive where you can build on it.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In 2005 every blogger seemed to show off neat graphs of their AdSense income, but few explained how they made&#8230;<\/p>\n","protected":false},"author":4,"featured_media":67721,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[43],"tags":[13],"class_list":["post-146","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-money","tag-adsense"],"_links":{"self":[{"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/posts\/146","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/comments?post=146"}],"version-history":[{"count":3,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/posts\/146\/revisions"}],"predecessor-version":[{"id":67734,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/posts\/146\/revisions\/67734"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/media\/67721"}],"wp:attachment":[{"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/media?parent=146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/categories?post=146"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/tags?post=146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}