How to Export CSV Data from Google Search Console and Import It into clariBI

Google Search Console provides essential data about how your website performs in Google Search results. Exporting this data into clariBI helps you analyze keyword rankings, click-through rates, and identify SEO opportunities using AI-powered insights.

What You Can Export from Google Search Console

• Search query performance (clicks, impressions, CTR, average position)
• Page-level performance data by URL
• Country and device breakdown for search traffic
• Search appearance data (rich results, AMP, etc.)
• Date-level performance trends
• Filtered query data (brand vs. non-brand, specific keyword groups)
• Core Web Vitals data summaries
• Index coverage status information

Export CSV Data from Google Search Console

1. Go to search.google.com/search-console and log in with your Google account
2. Select the correct property (website) from the property selector in the top left
3. Click Performance > Search results in the left sidebar
4. Set your desired date range using the Date filter at the top (you can select custom ranges up to 16 months)
5. Add any additional filters as needed — click + New to filter by Query, Page, Country, Device, or Search appearance
6. Review the data in the table below the chart — toggle between the Queries, Pages, Countries, Devices, Search appearance, and Dates tabs
7. Click the Export button (download icon at the top right of the report, above the chart)
8. Select Download CSV from the export options
9. Google Search Console will download a ZIP file containing multiple CSV sheets (Queries, Pages, Countries, Devices, Dates, Search appearance)

Tips for Clean Exports

• The UI export is limited to the top 1,000 rows per tab — if you have more than 1,000 queries or pages, consider using the Search Console API or Google Looker Studio for complete data
• The downloaded ZIP file contains separate CSV files for each data dimension — import the one most relevant to your analysis (usually Queries or Pages)
• Apply filters before exporting to focus on specific segments (e.g., non-brand queries only) for more actionable analysis

Import Your Data into clariBI

1. Log in to your clariBI account at claribi.com
2. Click Data Sources in the left sidebar
3. Click the + Add Source button (top right)
4. Under Direct Upload, select CSV File
5. Enter a descriptive name (e.g., "Google Search Console - Query Performance Jan 2025")
6. Click the upload area or drag and drop your CSV file
7. Click Create Data Source

Once imported, you can ask clariBI questions like:
- "Which search queries have the highest impressions but lowest CTR (optimization opportunities)?"
- "How has my average search position changed for my top 20 keywords over the last 6 months?"
- "Which pages drive the most organic clicks and what queries lead to them?"

clariBI's AI will automatically analyze your data and suggest relevant insights.