Extract Top 5 Keywords per URL from Ahrefs CSV

Extract the top 5 keywords by traffic per URL from Ahrefs Organic keywords CSV.

Drag & drop CSV files here, or browse files

.csv format (up to 10 files, 500 MB each)

Required Columns

KeywordVolumeCurrent_organic_trafficCurrent_positionCurrent_URL

Your data stays in your browser. By using this tool, you agree to our Terms and Privacy Policy.

How to Use This Template

Select Your File

Drag & drop a CSV file containing the required columns

Automatic Processing

Data is transformed and aggregated based on the template

View Results

Explore the aggregated results interactively on the Analyze page

Processing Details of This Template

  1. 1Rank by Current_organic_traffic per Current_URL (ROW_NUMBER) → column "traffic_rank"
  2. 2Sort by Current_organic_traffic (descending)
  3. 3Pivot by Current_URL, Keyword
  4. 4Metrics: Sum(Current_organic_traffic), Min(Current_position), Sum(Volume)
  5. 5Filters: traffic_rank <= 5