Skip to main content

Import your keywords from CSV

Learn how to bulk upload keywords using CSV, including formatting requirements and best practices.

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.

  • Import keywords into multiple projects and groups from a single file.

The guided import wizard takes you through four stages: Upload, Map columns, Review, and Import.
​

Each row’s Project Name determines which project its keywords join. If the project does not exist, Keyword.com creates it.
​

Why it matters

Manually adding keywords is slow and error-prone at scale.
​

CSV import provides:

  • Faster onboarding.

  • Consistent keyword configuration.

  • Early detection of invalid rows and duplicate keywords.

  • Historical ranking context when switching tools.

  • Background processing, so you can continue working while a large import finishes.

How it works

Step 1: Open the Import tool

You can access CSV import in two ways.
​

From your profile menu:

  1. Click your profile icon in the top-right corner.

  2. Select Import Data.

  3. On the Imports page, click + New import.

From the Keywords page:

  1. Click + Add Keywords.

  2. Select the Bulk import tab to access CSV import.

Step 2: Download the CSV template

Click Download template on the Imports page, or Download our CSV template in the wizard’s Upload step.
​

The template includes fields for keyword configuration, projects, groups, and optional historical rankings. Keep its column headers intact.
​

If you are exporting from another tool, you can use your own CSV and map its columns to the corresponding Keyword.com fields during import.
​

Step 3: Prepare your CSV file

Use one row per keyword tracking configuration.
​

Your file can include the following fields:

Import field

Description

Example

Project Name

The project the keyword will join. A project is created if it does not exist.

example.com

Group Name

The group within the project, if applicable.

Regional campaign

Domain

The domain or URL you are tracking.

example.com/services

Keyword

The search term you want to track.

accounting services

Region

The Google region used for tracking.

google.co.uk

Language

The tracked language.

en

Tags

Keyword labels, separated by commas when using multiple tags.

priority,services

Type

Desktop or Mobile tracking.

Mobile

Start Rank

The rank when tracking started.

5

Best Rank

The best recorded rank.

3

Current Rank

The latest rank result.

6

Search Location

The location used for tracking.

London, UK

GMB

The Google Business Profile name for local listing tracking.

Example Business

Included In SOV

Whether the keyword is included in Share of Voice calculations. Use Yes or No.

Yes

Url Tracking Method

Broad or Exact tracking.

Broad

Ignore Subdomains

Whether to ignore subdomains. Use 1 to ignore them or 0 to include them.

0

The wizard identifies Project, Domain, Keyword, Region, and Type as required mappings. Check that your file contains the information needed for these fields.
​


Location format requirement

When importing locations through CSV, use values recognized by Google’s geo-targeting system.
​

We recommend using Google’s official Geo Targets reference to check that locations are valid and consistently interpreted.
​

Unsupported or ambiguous location values can result in inconsistent or unexpected rankings.
​

Historical data format

You can import historical rankings alongside your keywords:

  • Add one column per date.

  • Put the applicable date in each historical column header.

  • Enter the keyword’s rank for that date in the corresponding row.

  • Check that the wizard recognizes and maps your date columns correctly.

You can include multiple historical date columns within the file-size limits.
​

⚠️ Note: CSV cells are limited to 32,767 characters

⚠️ File-size limit: The maximum supported import file size is 50 MB.


Step 4: Upload your file

In the Upload step:

  1. Drag and drop your CSV into the upload area, or click browse files.

  2. Select your CSV file.

  3. Click Continue to proceed to Map columns.

Step 5: Map your columns

Keyword.com automatically attempts to match your CSV columns to its import fields.

For each column, the wizard shows:

  • CSV column: The column from your file, with sample values.

  • Map to: The Keyword.com field assigned to that column.

  • Keyword.com field: A description of the destination field.

  • Match confidence: An indicator of confidence in the automatic mapping.

Review each mapping and use the Map to dropdown to correct any mismatches.

Confirm that the required fields and any historical ranking columns are mapped correctly, then click Continue.
​

Step 6: Review your data

The Review step checks your file before importing.
​

The summary shows:

Summary

What it means

Ready to import

Rows that will be added when you start the import.

Issues

Problems detected in the imported data.

Duplicates

Keywords already being tracked that will be skipped.

Historical rank

Rows containing historical ranking data.

Use the All, Issues, Duplicates, and Ready filters to inspect the rows.
​

Check the project, group, domain, and keyword assignments. If corrections are needed, go back to adjust the mappings or correct your source file and upload it again.
​

Once the data is ready, click Continue.
​

Step 7: Confirm and start the import

The final Import step summarizes:

  • How many keywords will be imported.

  • How duplicates will be handled.

  • How many rows with issues will be skipped.

  • How many rows contain historical rankings.

  • The estimated SERP checks.

  • Your keyword usage and remaining allowance after import.

Enable Email me when it’s done if you want an email summary when processing finishes.
​

Review the details, then click Import keywords. The button includes the number of keywords being imported.
​

Large imports run in the background, so you can continue working elsewhere in Keyword.com while processing finishes.
​

Step 8: Check the import status

Return to Import Data to track progress on the Imports page.

The list shows each import’s:

  • File name.

  • Status.

  • Associated projects.

  • Imported keyword count.

  • Skipped row count.

  • Total row count.

  • Creation date.

Use All imports to review import history, or Failed to find failed imports. You can also search by file, project, or person.
​

Once processing is complete, open the relevant project or group to review the imported keywords and historical data.
​

Location & device considerations

For consistent results, especially for local keywords, explicitly specify both Search Location and Type in your CSV.
​

Review these fields during column mapping and check for missing or invalid values during the Review step.
​

Use separate rows when tracking the same keyword on different devices or in different locations. Each unique tracking configuration counts toward your keyword allowance.
​

What to expect

  • Imported keywords count toward your keyword allowance.

  • Rows are assigned to projects according to the Project Name column.

  • Duplicate keywords identified by the wizard are skipped.

  • Historical ranking data becomes available once the import has finished processing.

  • Imported keywords behave the same as manually added keywords.


Best practices

  • Use CSV import for large setups and migrations that include historical data.

  • Review automatic column mappings before continuing, including historical date columns.

  • Resolve invalid rows and review duplicates before starting the import.

  • Check project names, group names, locations, and devices carefully.

  • Review the projected keyword usage before confirming the import.

  • Keep a backup of your original CSV and check the import status after submitting it.

Did this answer your question?