How to Export CSV Data from SEMrush and Import It into clariBI

SEMrush is a comprehensive SEO and digital marketing toolkit that provides data on keywords, backlinks, competitors, and search visibility. Exporting this data into clariBI lets you perform advanced trend analysis and uncover strategic opportunities across your SEO efforts.

What You Can Export from SEMrush

• Organic keyword rankings and position history
• Domain overview metrics (traffic, keywords, authority score)
• Backlink data (referring domains, anchor text, new/lost backlinks)
• Keyword research data (volume, difficulty, CPC, SERP features)
• Competitor organic and paid keyword overlap
• Position tracking (rank changes over time)
• Site audit issues and health scores
• Advertising research (competitor ad copy, ad spend estimates)

Export CSV Data from SEMrush

1. Log in to your SEMrush account at semrush.com
2. Navigate to the tool or report you want to export data from — common options include:
   - Domain Overview: Enter a domain and view summary metrics
   - Organic Research: Positions, Position Changes, Competitors
   - Keyword Magic Tool: Keyword lists with volume and difficulty
   - Position Tracking: Your tracked keyword rankings over time
   - Backlink Analytics: Backlinks, referring domains, anchors
3. Apply any filters you need (date range, keyword filters, country, device)
4. Click the Export button located in the top right area of the report table
5. Select CSV from the available export formats (CSV, XLSX, CSV Semicolon)
6. Choose the number of rows to export — options depend on your plan (Free: 10 rows, Pro: up to 10,000, Guru: up to 30,000, Business: up to 50,000)
7. The CSV file will begin downloading with your selected data

Exporting Position Tracking Data

1. Go to SEO > Position Tracking in the left sidebar
2. Select your project and the tracking campaign
3. Click the Overview or Rankings tab
4. Set your date range and apply any tag or keyword filters
5. Click Export > CSV at the top right of the data table

Tips for Clean Exports

• Export row limits vary by plan tier — if you need more data than your plan allows, break exports into segments using filters (e.g., by keyword group or country)
• Position Tracking exports are the most useful for ongoing SEO monitoring since they include historical ranking data over time
• When exporting from Keyword Magic Tool, apply difficulty and volume filters first to export only relevant keywords

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., "SEMrush - Organic Keywords Report Feb 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 keywords have improved the most in ranking position over the last 3 months?"
- "What high-volume keywords am I ranking on page 2 for that could move to page 1?"
- "How does my organic keyword count compare to my top 3 competitors?"

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