Free Search Console CSV Analyzer

Core Freelancers · organic performance analysis from your GSC export
Processed in your browser — nothing is uploaded

1 · Load your Search Console export

In GSC go to Performance → Export → Download CSV, then drag the whole ZIP straight into the box below — no need to unzip it yourself. Handles Queries, Pages, Dates, Countries and Devices — exported in either English or Indonesian.

Primary period

Required · e.g. last 28 days

    Comparison period

    Optional · e.g. the 28 days before that

      Not sure the file is the problem? Load the sample to confirm the dashboard itself works.
        CTR is recalculated from clicks ÷ impressions rather than read from the CSV column, so local number formats (comma vs dot decimals) can never be misread.

        Daily trend

        From Dates.csv / Tanggal.csv

        Clicks Impressions

        This week’s priorities

        Derived automatically from your query data. Estimated extra clicks use an average CTR-by-position curve — treat these as a priority order, not a forecast.

        Striking distance (positions 4–20)

        Already earning impressions — these just need a push to the top of page 1.

          Below-normal CTR

          Ranking well but rarely clicked — usually a title tag and meta description problem.

            Biggest gains

            Against the comparison period.

              Biggest losses

              Worth investigating first.

                Detailed data

                Click a column header to sort. Whatever is on screen can be re-exported as CSV.

                SEO priorities — AI briefing

                Claude reads the tables above — striking distance, CTR gaps, movers, top pages — and returns a ranked action list for the next 30 days.

                The key stays in memory for this tab only — it is never written to this file or your disk. Running the analysis sends the summarised query data to the Anthropic API, so get a client's agreement before using theirs.

                
    
                

  
                Core Freelancers · free tool · your data is never uploaded
                

                

                


		
                
	
                

			
                 
		
                
	
                 

                
		
                
	
                
		
                
			
                
				
	
                
		
                
			


                


                
  
                
    
                This free Search Console CSV analyzer turns a raw Google Search Console export into a ranked list of things to fix. Drop in the ZIP or CSV files, and it finds your striking-distance keywords, the pages ranking well but losing clicks to a weak title, and what moved since last month — then asks Claude for a prioritised plan.
                
    
                There is no account to create and no Google permission to grant. The file reads your export in the browser, so your query data never reaches our servers. That matters if you run SEO for clients and cannot hand a third-party tool access to their Search Console property.
                
  
                

                


                
  
                
    
                How the Search Console CSV analyzer works
                
    
                  
      
                1. Export from Google Search Console. Open Performance, set your date range, and click Export → Download CSV. Google gives you a ZIP containing Queries, Pages, Dates, Countries, Devices and Search appearance.
                  2. 
      
                2. Drop the ZIP into the tool. No need to unzip it. Exports in English or Indonesian both work — the analyzer reads either set of column headers and handles comma or dot decimal formats.
                  3. 
      
                3. Add a comparison period. Optional, but this is where the value is: export the previous period too and every metric gains a delta, so you see what actually changed.
                  4. 
      
                4. Read the priorities. The tool surfaces the opportunities, then Claude turns them into a ranked 30-day action list with reasoning.
                  5. 
    
                
  
                

                


                
  
                
    
                What the analysis looks for
                
    
                
      
                
        
                Striking distance keywords
                
        
                Queries sitting between positions 4 and 20 already earn impressions. The tool ranks them by how many extra clicks a move to position 3 would plausibly earn, so effort goes where the volume already exists rather than where a keyword tool says it might.
                
      
                
      
                
        
                CTR gaps
                
        
                A page at position 3 taking 2% of clicks is not a ranking problem, it is a title tag problem. Each query is compared against a typical CTR for its position, and anything well below is flagged as a copy fix rather than a link-building job.
                
      
                
      
                
        
                Gains and losses
                
        
                With a comparison period loaded, queries are matched across both exports and sorted by click change. Sudden drops usually point at a lost featured snippet, a cannibalised page, or a seasonal swing worth checking before anyone panics.
                
      
                
      
                
        
                AI SEO recommendations
                
        
                The summarised tables go to Claude, which returns a ranked action list naming specific queries and pages, the reasoning behind each, and one thing that is not worth doing yet. Judgement on the numbers, not generic advice.
                
      
                
    
                
  
                

                


                
  
                
    
                Why a CSV tool instead of a connected one
                
    
                Most Google Search Console analysis tools ask you to sign in with Google and grant read access to your properties. That is convenient, and for your own site it is usually fine. For agency work it often is not: many clients will not approve a third-party app on their Search Console, and some are contractually unable to.
                
    
                A CSV export sidesteps the problem. The client sends a file, or you download it from the property you already have access to, and nothing else changes hands. Because the analysis runs client-side, there is also no vendor holding a copy of their query data afterwards.
                
    
                The honest trade-off: you re-import each time. This tool reads a snapshot, it does not track history. If you need automatic month-on-month reporting, connect Search Console to Looker Studio instead — it is free, and it does that job better. Use this when you want the striking-distance and CTR analysis without building it yourself.
                
  
                

                


                
  
                
    
                Frequently asked questions
                
    
                
      
                Is this Search Console CSV analyzer free?+
                Yes. There is no account, no trial and no row limit beyond what Google puts in the export itself. The AI recommendations run through the Anthropic API, which is the only part that can carry a cost, and only if you supply your own key.
                
      
                Do I need to connect my Google account?+
                No. The tool never touches Google's API and asks for no permissions. You download the CSV export yourself from Search Console and load the file directly, which is why it works for client properties where third-party access is not allowed.
                
      
                Where does my Search Console data go?+
                The file is parsed in your browser and held in memory only. Nothing is uploaded and nothing is stored, so closing the tab clears it. The one exception is the AI analysis: if you run it, the summarised tables are sent to the Anthropic API. Get a client's agreement before doing that with their data.
                
      
                How do I export CSV data from Google Search Console?+
                In Search Console open the Performance report, choose your date range and any filters, then click Export at the top right and pick Download CSV. Google returns a ZIP file containing one CSV per tab: Queries, Pages, Dates, Countries, Devices and Search appearance. Drop the whole ZIP into the tool without unzipping it.
                
      
                What are striking distance keywords?+
                Queries ranking just below the positions that earn meaningful clicks, usually positions 4 to 20. They already prove demand and relevance, so improving them is normally faster and cheaper than targeting a new keyword from scratch. The tool ranks them by estimated click gain rather than by position alone.
                
      
                Are the estimated extra clicks a forecast?+
                No, and it matters. The estimates apply a generic average CTR-by-position curve, which varies widely by industry, intent and SERP layout. Treat the numbers as a way of ordering the work, not as a prediction of results, and never quote them to a client as a projection.
                
      
                Does it work with a non-English Search Console export?+
                Yes. Column headers are matched in English and Indonesian, and numbers are read in either format, so an export showing 1.482 clicks and 3,81% CTR parses correctly. CTR is recalculated from clicks divided by impressions rather than read from the file, which removes locale ambiguity entirely.
                
      
                Which browsers does it support?+
                Any current version of Chrome, Edge, Firefox or Safari. Opening the ZIP directly needs a browser that supports DecompressionStream, which excludes Safari before 16.4 — on those, unzip the file first and load the CSVs individually.
                
    
                
  
                

                


                
  
                
    
                Want someone to act on the findings?
                
    
                The tool tells you what to fix. Doing it — rewriting titles, restructuring pages, earning the links that move a keyword from position 11 to position 3 — is the slower part. Core Freelancers has run white-hat SEO for over 120 businesses across Indonesia, Australia, France and the United States since 2013.
                
    
                Explore our SEO services · Generative Engine Optimization · web development · talk to us
                
    Discuss your results on WhatsApp