Comment on page
Export Airtable to Excel (MacOS)
Keep an Excel document up to date with Airtable data.
Generate an export URL with csvgetter.com. There are many ways to do this with our powerful User Interface.
On Excel on macOS, click the "Data" tab in the upper toolbar, and select "Get Data (Power Query)
Under "Get Data", use the option "Run Web Query"
You will see that Excel will provide two sample query files for selection. The easiest way to get started is to simply edit these. This can be achieved by right-clicking one of the files and clicking "Show in Finder".
Once in finder, the files can be edited with a text editor of your choosing.
In your text editor, replace all of the query text with your export URL created. IMPORTANT: you mast add the following paramter to your URL:
Save the file. Now you can select the query you edited. In this case, we edited SampleWebQuery01.iqy. We will select this query to import the data.
Select your starting cell and press import
And your excel workbook will be automatically populated with your airtable data! You can refresh the data whenever you need by right clicking any cell and clicking refresh.