Keyword export (TXT and CSV formats)


You can export your keyword list on the Keywords page to the TXT and CSV formats. Each format supports extra export features.

Please note that we export data "as it is". To export extra data associated with a particular search engine and location, pick data source on the dashboard.

Data source
Pick a source (Google Adwords, Yandex.Direct, etc.) to export extra data associated with Google or Yandex. Pick a location in the drop-down menu next to the source to export local data.

CSV


We recommend picking export to CSV when you need to save a copy of the keywords table, pass a copy to another user, or import exported keywords to another project.

You can export all groups, only disable and enabled groups or a selected keyword group. If necessary, you can export extra stats you pulled for your project into the same CSV file: search volume, CPC, etc.

To export data to a CSV file, follow the below instruction:

  1. Pick a project to export data.
  2. Move to the Keywords page.
  3. Press on the dashboard.
  4. Pick a CSV (1) export format.
  5. Check boxes near extra export options, e.g. Group names and Search Volume (2).
  6. In the drop-down menu select if you want to export all groups or only disabled/enabled (3).
  7. Press Save (4).

Keyword export to CSV
You can open CSV files with any spreadsheet editor, e.g.: Microsoft Excel, OpenOffice, Numbers, etc. You can also open and edit them with any text editor, because CSV files contain text data.

TXT


You can pick to separate exported keywords in a TXT file with a comma or export each keyword on a new line. TXT format doesn't support export of extra stats (search volume, CPC, etc.)

To export data to a TXT file, follow the below instruction:

  1. Pick a project to export data.
  2. Move to the Keyword page.
  3. Press on the dashboard.
  4. Pick a TXT (1) export format.
  5. Check boxes near extra export options, e.g. keywords separated by comma or one per line (2).
  6. In the drop-down menu select if you want to export all groups or only disabled/enabled (3).
  7. Press Save (4).

Keyword export to TXT

Delimiter (CSV)


Text files with comma separated values (CSV) use a comma (,) or a semicolon (;) to separate text values. You can change a default delimiter in the exported files.

To change a default delimiter, follow the below instruction:

  1. Move to the Account settings.
  2. Pick a delimiter: (,) or (;).
  3. Press Save.

CSV delimiter

File encoding


File encoding details are exported with a text file. The computer uses them to display a text in the correct format. If you open a text file and see that the text is corrupted and not readable, you should change file encoding.

To change file encoding, follow the below instruction:

  1. Move o the Account settings.
  2. Pick a file encoding.
  3. Press Save.

File encoding