Manage columns 
Manage columns 
Column save changes Added columns Column settings Delete columns No columns added
Advanced options
OK
Select locations 
OKClose

Rankings. How to export data

  • How to export rankings with optional data (volume etc.)
  • How to use advanced options
  • Ranked URLs
  • Split groups
  • Compact mode (in one cell)
  • Display Summary
  • Add hyperlinks to URLs

    • In Rank Tracker one can export data as follows:

    • in CSV, XLSX, PDF and HTML formats;
    • creating a guest link;
    • uploading a report to Google Drive (Google Sheets).

    A report will display checks selected in Rank Tracker. To export a report for a search engine, location, keywords' group or competitor, select them on the toolbar, then pick the checks you need in Calendar and export. To download a report for all or several search engines and locations, go to Compare Mode.

    How to export rankings with optional data (volume etc.)

    1. Go toRank Tracker.
    2. Click on the toolbar.
    3. Select the export format.
    4. To add additional columns to the export (for example, keywords volume), clickto the right of the format. To change column settings, such as search engine, volume type, or location, click it. To see additional settings, click Advanced Options.

    Rank Tracker: how to export data with additional columns

    I have many locations in my project, how can I export a report for all of them at once? Is it possible to place each location on a separate sheet?
    You can export a report for all locations from Compare Mode. To have each location on a separate sheet, select XLSX (Tabs).
    Downloaded a .csv report, but I have some gibberish instead of words. How do I fix it?
    This is because the file encoding is different from the default encoding used in Excel. To change the encoding, go to Account Settings and under Format, change the Character Encoding option.
    Is it possible to display Summary in the report?
    Yes, you can do this in XLSX and PDF reports. To do this, clickto the right of the format, open Advanced Options, and tick Display Summary.

    How to use advanced options

    Ranked URLs

    A URL ranked in SERP would be added to each check.

    Split groups

    Keywords groups would be separated from each other by blank row (in CSV) or bold border (in XLSX).

    Compact mode (in one cell)

    Ranked URLs would be displayed right in the rank cells instead of being displayed in cells to the right. Hover over the top left corner of the cell to see ranked URL.

    Display Summary

    Adds Summary to the report.

    Add hyperlinks to URLs

    Adds hyperlinks for ranked URLs, and you would be able to go to the page by clicking on the cell.