Ahrefs CSV Position Band Labeler

Drop an Ahrefs CSV to automatically label positions into 7 bands (1 / 2-3 / 4-6 / 7-10 / 11-20 / 21-100 / 101+).

Before
KeywordCurrent positionVolumeCurrent URL
csv analysis tool12400https://example.com/csv
data pivot online31200https://example.com/pivot
free csv editor56500https://example.com/editor
parquet converter9800https://example.com/parquet
csv to json183200https://example.com/convert
After
KeywordCurrent positionVolumeCurrent URLposition_label
csv analysis tool12400https://example.com/csv01: 1
data pivot online31200https://example.com/pivot02: 2-3
free csv editor56500https://example.com/editor03: 4-6
parquet converter9800https://example.com/parquet04: 7-10
csv to json183200https://example.com/convert05: 11-20

Drag & drop CSV files here, or browse files

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

Required Columns

KeywordCurrent position

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. 1Add conditional column "position_label"