CONNECTING AIRTABLE TO EXCEL

[samuelfadare]

I would like to ask if anyone has encountered the difficulty i am currenlty going through. I tried to import an airtable data into excel using power query, but it doesn't seem to import all columns. can anybody help please. It's urgent.

[GilbertHall]

You can try to export Airtable to Excel instead. Or use Skyvia as an alternative solution

[AMJTech]

Here is a well documented - comprehensive solution: 

https://docs.csvgetter.com/export-airtable-to-excel

There is also an article which shows how to do it on Excel MacOS as well.

[Anonymous · Accepted solution]

Hi @samuelfadare ,

You can try to export airtable to excel instead.

Please kindly refer to

Export Airtable to Excel: 2 Easy Steps

And there are two points you need to pay attention to:

Airtable presently does not support exporting a complete base. Each base table must be downloaded as a distinct CSV, and attachment files must be exported separately.

The export will include all field values visible in the view. Record-level comments, field descriptions, base guide material, and data saved primarily in applications are not included in the export (like Description App).

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.