# Excel Connector

## How to export data to Excel?

1\. Click the export button on the top right of the table. 

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FR3csO7z5TpjG6ONV3AEA%2Fimage.png?alt=media\&token=a9f70a98-d227-477a-8ab9-cdc880db18bc)

2\. Select **Excel Connector** and click **Generate API**.

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FYbS7soJ2Crgv8OELgvgp%2Fimage.png?alt=media\&token=a1081b78-16b6-401c-a644-73c997ce0f42)

{% hint style="info" %}
Notice that Excel can support up to 1,048,576 rows. If your table is too large to export, you can use [Filter](https://docs.acho.io/acho-studio/data-prep-projects/applying-actions/view/filter) or [Cut](https://docs.acho.io/acho-studio/data-prep-projects/applying-actions/view/cut) to shrink your table size.
{% endhint %}

3\. When the API is generated successfully, a green message will pop up from the top of the page. The Excel connector API will be copied to your clickboard automatically

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FOpeSTaWjWXTrh293Wn6Q%2Fimage.png?alt=media\&token=55265a12-b2d7-4f55-99b5-de3fc05e8f94)

4\. Open your Excel and navigate to **Data > From Web**. Then, paste the API that you just generated on Acho in the URL field and click **OK**.  (For mac user, prepare the link in an **iqy** file and use Data - Get External Data -  Run Web Query, [contact us](mailto:contact@acho.io) or [find us in Discord](https://discord.com/invite/WPUcn28VKW) if you find any problem)

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FrcBXbedzhybDNPLvfHbT%2Fimage.png?alt=media\&token=1f3ff201-f52f-4c02-a0df-2bb27c513ced)

5\. After the connection has been established, you can preview your data in Excel. Then, if the data is correct, you can click **Load** to start importing data from the API.

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FkklTSPk6rfPhz2fWLp49%2Fimage.png?alt=media\&token=65f8a37c-eea6-427d-996e-b3f8153d4245)

5\. Now, you may need to wait for one to several minutes to load your data into Excel. You can see the progress on the left. 

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FFPtvMWGZA2KfdgJCxrzV%2Fimage.png?alt=media\&token=e806417b-c740-467c-9145-2fef281b37f0)