What it is
CSV import allows you to add keywords to Keyword.com in bulk. You can:
Import large keyword sets at once
Migrate keywords from another rank tracker
Preserve historical ranking data
This is the recommended method for large setups and tool migrations.
Why it matters
Manually adding keywords is slow and error‑prone at scale.
CSV import ensures:
Faster onboarding
Consistent keyword configuration
No loss of historical ranking context when switching tools
How it works
Step 1: Open the Import tool
There are two ways that you can access the Import tool
From the main menu:
From the main navigation, click Import Data
Choose Import keywords from CSV
From the Add Keyword screen:
Step 2: Download the CSV template
Download the Keyword.com CSV template. This template defines the required structure for importing keywords and optional historical data.
If you are exporting from another tool, reformat that export to match the Keyword.com template.
Step 3: Prepare your CSV file
You can include:
Import Field | Description | Example |
Project Name | Domain name or custom name |
|
Group Name (legacy) | Domain name or custom group name |
|
Domain | The url you are tracking |
|
Keyword | keyword you are tracking |
|
Region | Google TLD region |
|
Language | Tracked language |
|
Tags | Keyword tag |
|
Type | Desktop or Mobile |
|
Start Rank | Rank when you started tracking this keyword |
|
Best Rank | Best rank tracked for keyword |
|
Current Rank | The latest rank result |
|
Search Location | Tracked location | |
GMB | Google My Business name |
|
Included In SOV | Indicate if keyword is to be included in Share of Voice calculation - | |
Url Tracking Method | Select | |
Ignore Subdomains | Ignore sub-domain when tracking url - | |
‼️ Important note about CSV columns
You do not need to complete every field in the template. However, all columns must remain in the file when importing, even if they are left blank. Removing columns will cause the import to fail.
Location format requirement
When importing locations via CSV, location values must match a format recognised by Google’s geo targeting system.
We recommend using Google’s official Geo Targets reference to ensure locations are valid and consistently interpreted.
Using unsupported or ambiguous location formats can result in inconsistent or unexpected rankings.
Historical data format
Add one column per date
Dates must be in the column header
You can include as many date columns as needed, within CSV limits
⚠️ Note: CSV cells are limited to 32,767 characters
Step 4: Upload and map your data
Upload your completed CSV file.
After upload:
A preview table is shown
Columns are automatically mapped
You can review and adjust mappings if needed
Important: mapping historical rank data
If your CSV includes historical ranking columns, you must select:
Start Rank History: the date of the first historical column in your CSV
End Rank History: the date of the last historical column in your CSV
These fields define which columns should be treated as historical ranking data.
If Start and End Rank History dates are not selected, historical data will not be imported, even if your CSV contains historical columns.
Best practice:
Ensure the selected dates exactly match the first and last historical date columns
Avoid gaps or mismatches between CSV column dates and selected ranges
Step 5: Validate and fix errors
If any issues are detected:
Errors are highlighted in red
You can correct values directly in the table
Once all errors are resolved, continue to the final step.
Step 6: Import
Click Import to complete the process.
Your keywords will be added to the selected project and historical rankings will be available immediately.
Location & device considerations
If your CSV does not explicitly specify a location:
Keyword.com will apply the default location based on the selected Google region (capital city)
If your CSV does not specify a device:
Desktop tracking is applied by default
For consistent results, especially for local keywords, explicitly set both location and device in your CSV.
What to expect
Imported keywords count toward your keyword allowance
Historical data is visible immediately after import
Imported keywords behave the same as manually added keywords
Best practices
Use CSV import for migrations, not inline bulk add
Always validate location and device columns
Import in smaller batches if working with very large files
Keep a backup of your original CSV