Forum Discussion
CONNECTING AIRTABLE TO EXCEL
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.
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.
3 Replies
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.
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.
You can try to export Airtable to Excel instead. Or use Skyvia as an alternative solution
