# Export More Than 1,000 Rows from Google Search Console Using API

{% hint style="info" %}
**Note:** Data is only available for export for **the last 16 months**. You should export and back up your data annually for future strategy planning.
{% endhint %}

{% hint style="warning" %}
**Export Limitations:** 

This tool only supports exporting data from <mark style="color:blue;">**the Performance Report**</mark>.&#x20;

<mark style="color:orange;">**It does not include information about unindexed pages or 404 errors.**</mark>&#x20;

The Performance Report API focuses solely on pages that appear in search results and their associated metrics.&#x20;

<mark style="color:orange;">**For data on unindexed pages or other indexing issues, you'll need to use different tools and reports.**</mark>
{% endhint %}

<figure><img src="https://2680433967-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOZZMphgu4vCBIC4xqyqR%2Fuploads%2FXKwkrf4QVyNRXKWDTwXn%2FCleanShot%202024-02-28%20at%2009.58.05%402x.png?alt=media&#x26;token=2791a206-74a3-4bc1-8e9b-10a7ae2d7090" alt=""><figcaption><p>Export More Than 1,000 Rows from Google Search Console Using API</p></figcaption></figure>

To retrieve more than 1,000 rows from the Google Search Console interface via the API, follow these steps:

### **Step1: Install Extension**

Begin by installing the Google Search Console API extension for your browser.

{% hint style="info" %}
<https://chromewebstore.google.com/detail/google-search-console-bin/glncpmnpbdpbipdgdpadhlcankfngejl>
{% endhint %}

{% content-ref url="../getting-started/how-to-install" %}
[how-to-install](https://help.gsctool.com/getting-started/how-to-install)
{% endcontent-ref %}

### **Step2: Setup & Enable Google Search Console API**:

{% content-ref url="google-indexing/how-to-get-a-google-json-key" %}
[how-to-get-a-google-json-key](https://help.gsctool.com/features/google-indexing/how-to-get-a-google-json-key)
{% endcontent-ref %}

### **Step 3: Open Extension & Click "Search Analytics" Menu**

Launch the newly installed extension.

Inside the extension, look for and select the "Search Analytics" option.

<figure><img src="https://2680433967-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOZZMphgu4vCBIC4xqyqR%2Fuploads%2FPj7JBiK0LxMxMYM2HodO%2FCleanShot%202024-02-28%20at%2010.10.30%402x.png?alt=media&#x26;token=71a47df8-b350-464b-8315-63fb262de51b" alt="" width="563"><figcaption><p>Export More Than 1,000 Rows from Google Search Console Using API</p></figcaption></figure>

### **Step 4: Select Your Site and Filters**

* Choose the site you wish to analyze.
* Apply any filters as needed to refine your data search.

### **Step 5: Overview Information and Export CSV**

* Once configured, you will see an overview of your search analytics.
* Use the option provided to **Export CSV** to download all the data you need.

{% embed url="<https://assets.ytuong.dev/gsctool/export-backup-google-search-console-data.mp4>" %}
How to Manually Export Data from Google Search Console with API
{% endembed %}

Now, with the data exported, you can conduct a comprehensive analysis beyond the 1,000 rows limit directly from the Google Search Console interface.

For a more detailed guide, you can refer to this blog post: [How to Export More Than 1,000 Rows from Google Search Console Interface](https://medium.com/@trungpv1601/how-to-export-more-than-1-000-rows-from-google-search-console-interface-using-google-search-console-1594ef4f7738).

### FAQs

**Q: Can I export more than 1,000 rows of data from Google Search Console?**

A: Yes, you can export more than 1,000 rows by using the API method or refer to our detailed guide on How to Export More Than 1,000 Rows from Google Search Console Interface.

**Q: Is it necessary to have technical skills to export data using the API?**

A: While having some technical background helps, our guide provides step-by-step instructions that make the process accessible even for those with minimal technical experience.

**Q: What are the benefits of exporting data manually from Google Search Console?**

A: Exporting data manually allows for a more comprehensive analysis by bypassing the 1,000 rows limit, facilitating a deeper dive into your website's search data.

**Q: How often should I export data from Google Search Console?**

A: The frequency depends on your specific needs and how often your website's search data changes. A monthly or quarterly export is common practice for ongoing analysis.

**Q: Can exporting data affect my website's performance on Google Search?**

A: No, exporting data from Google Search Console does not impact your website's performance in Google Search. It is purely an analytical process to aid in your site's SEO strategy.