How to export Airtable to Excel

If you're wondering how to automatically export Airtable data and have it ready to use in an Excel document then look no further.
Once you have created a CSV Getter URL, make sure you are using type=csv.
Response Sample
Field 1,title,budget,year,genre,length
64,Coach Carter,38.57889077,2005,Drama,136
281,Alien Abduction,0.771577815,2005,Other,90

Step 1

If you are using Windows, open a new Excel workbook and select the "Data" tab.

Step 2

Select the "From Web" option on the Data tab.

Step 3

Paste the CSV Getter URL (specifying data ?type=csv) in the URL field.

Step 4

The user should see a preview of their field mapping. If the data looks good, click "Load".
And that's it! Your Excel workbook should now be updated with live Airtable data from

Optional Extra Step

Click "Transform Data" before clicking load to specify the data type of each field.
You can use the transform field to cast each column type to ensure you are loading your data properly
Click "Close and Load"

Refreshing the Data

You can refresh your data manually by using the Queries & Connections tab or you can schedule a refresh under "Query Properties"