Can I import a file with my keywords? What format should the import file be in?

Yes, You can import a file with your list of keywords to create a report.

The import file should be a .xls, .xlsx or .csv (max size: 5 Mb, encoding: UTF-8).

It should contain at least one column with a header called “query,” “keyword,” or “keyword sitemap” (the first letter can be capitalized). The keywords will be imported from this column.

Only the keywords on the first tab will be imported if the file has multiple tabs.

Example 1 (Query):

Example 2 (sitemap keyword):

When exporting from Ahrefs, be sure to select the UTF-8 encoding.

Please note that any duplicate keywords will be removed.