Exporting data from Google Search console is fairly simple. Here are the steps needed to export and analyze your data in a spreadsheet.

  1. Log into Google Search Console
  2. Select the property you want to export data from
  3. Click on the Performance view in the left menu.
  4. Select the date range that you want to review.
  5. In the top left, click the button titled Export
  6. Select what format you would like (Google Sheets, Excel, CSV)

Done! You now can review Clicks, Impressions, CTR, and position, in a spreadsheet for the following metrics: