CSV export of queries and pages
Plans Free, Pro
Export CSV (top right of the Queries and Pages tables, also on page and query detail) downloads what you see: the same date range, comparison, filters, lifecycle tab and brand split. Columns: the query or page, clicks, impressions, CTR (a fraction, 0.0345 = 3.45%), position, and with a comparison the previous clicks, impressions and position and the click change. Opens in Excel and Google Sheets.
Row limit. Free exports up to 1,000 rows, Pro and Agency up to 50,000. When your table is longer than the limit a quiet note says so and the file stops at the biggest rows by clicks. Search text in the table box is not applied (the file is the whole table).