Many webmasters are frustrated by the 1000 row limit in the GSC Search Analytics reports. What they may not realize is that you can get a lot more data from the Search Console API, and Analytics Edge makes it easy to get that data (and more).
The free Exporter GSC from Analytics Edge lets you download a lot more than 1000 rows of search data if it exists, with query, page, device and country dimensions and filters. The connector automatically makes multiple queries to get all your data. With no account or query limits, the Exporter GSC is available free for MacOS and Windows computers.
Step up to the Add-in for Excel or Desktop App, and use an Analytics Edge macro to automate your search engine optimization analysis and reports.