How to export your data from Search Console or Bing

Google Search Console, Excel

The most complete option. This is the only export that carries dates and page URLs, so it is the only one that produces the weekly traffic trend and the pages splitting your traffic section.

1. Open Google Search Console and pick the property you want to analyze.
2. Click Performance in the left sidebar.
3. Set the date range you want. The report only knows what is in the file, so a wider range gives it more to work with.
4. Click Export in the top right.
5. Choose Download Excel.
6. Upload the .xlsx file to SEO Pinpoint exactly as it downloaded. No unzipping, no renaming.

Google Search Console, CSV

Same data, but Google hands it over as a zip of separate CSVs. Only the queries file is used, so this upload gets the whole report minus the trend chart and the page splits.

1. Open Google Search Console and pick the property you want to analyze.
2. Click Performance in the left sidebar.
3. Set the date range you want.
4. Click Export in the top right.
5. Choose Download CSV. Your browser downloads a zip file.
6. Unzip it and find Queries.csv inside.
7. Upload Queries.csv. Do not upload the zip itself, we cannot read it.

Bing Webmaster Tools

Bing exports one keyword list. This upload also gets the whole report minus the trend chart and the page splits.

1. Open Bing Webmaster Tools and pick your site.
2. Click Search performance in the left sidebar.
3. Scroll down to List by.
4. Select the Keywords pill.
5. Click Download all.
6. Upload the keyword report .csv to SEO Pinpoint.

• Export the queries list, not something else. A Pages, Countries, or Devices export has different columns and will be rejected. In Search Console that means the Queries tab, in Bing it means the Keywords pill.
• Upload the file, not the zip.Google’s CSV download arrives zipped and has to be extracted first. The Excel download uploads as it is.
• Keep it under 10 MB. If your export is bigger, narrow the date range in Search Console and export again.
• We read up to 5,000 query rows. Exports longer than that still work, we just analyze the first 5,000.
• Renaming the file is fine. We detect the export from what is inside it rather than from its name, so a file you saved as march-search-console.xlsx works just as well.