Export Airtable base, table & views as XLSX (Excel files)

[Florian_Verdon2]

Hey Airtable users 👋🏼

I've been working with clients as an Airtable consultant for the past few years (mostly in the European market) and this is a very common request I get.

Therefore I built the following 3 "plugins" for my platform AirPlugins

• Backup base as XLSX - receive a full base backup as xlsx daily via email or webhook
• Export table or view as XLSX - gives you a link to click (& store somewhere) so you can export data anytime
• Export linked records as XLSX - gives a link that allows to export linked records as xlsx

There are also other Airtable plugins available.

Feel free to PM me if you have any question, suggestion or request on these plugins.

Florian

[bitstreams_red]

I have an interface page that has 3 record picker boxes that then produces a list view at the bottom of the page of the related records.

I'd like to add a button that allows this list view to be exported (ideally to the clipbard, but Excel / CSV would do).  Would any of your plug-ins do this?

[Florian_Verdon2]

Hey @bitstreams_red 

This won't work in Airtable Interfaces but there's maybe a viable alternative.
The reason behind that is that the result of interface filters is not (currently) available through API.

If you are able to use a standard "Data - Grid View" (not in interfaces but in database - see screenshot attached), then you could use the Export table or view as XLSX
That means you would:
- configure this plugin and receive an "export link" (store it somewhere, in your notes, bookmark, ...)
- go to the view and set filters you need
- click on the export link and you'll get the content of the view as XLSX

It's free so, maybe you can try it and see if that works for you.

Also, you can show/hide fields, filter results & sort them and that will be taken into consideration when exporting the XLSX file.