How to: Use Excel Power Query to Retrieve Data from Airtable

When you have your data neatly set up on Airtable, especially when they are particularly financial data and numbers, you would want to connect to them on Excel (or Power BI), and do the analysis (or charts) from the latter.

Excel’s Power Query can ETL (Extract, Transform, and Load) data from your Airtable database, and here’s how to even work around the 100 Rows Limit or Pagination.

What you need are:

  1. Base ID
  2. Table  ID
  3. API Key

So I created a throwaway Airtable account for the API key, a throwaway workspace from that account, and and loaded the Simple Project Tracker base template, just for this demonstration.

You can get your API key from your account page (https://airtable.com/account):

You can get your Base ID and Table ID by going to the base and table you want to connect to and copy them from the URL: Continue reading How to: Use Excel Power Query to Retrieve Data from Airtable

Airtable Creator Plan, are you one of the lucky few?

Sometime in the middle of 2020, Airtable made available to select new users the Creator Plan. It was not available to everybody. No announcements were made about it. No documentation whatsoever.

The Creator Plan is a totally different workspace account than Free, Pro Trial, Plus, and Pro.

Brief Description

So how to describe this plan? One user emailed the dev team, and this is what she got in response:

The Creator plan is a current experiment that gives a new solo user almost all of including blocks, without the usual time constraints of a Pro trial.

Once the person adds collaborators to the Creator workspace, it morphs into a 30-day Pro trial, to experience the power of Airtable Pro with others. Once users are added to a workspace, all users will have 30 days of premium use before payment is required.

*If no collaborators above read-only are added, the Creator-plan (Pro features) will remain in effect indefinitely.*

If I were to describe the plan briefly: it would be closest to the Pro Trial plan without the time constraints. Yet, let me breakdown the features and compare the Airtable Creator Plan to the other plans the best I could. I’ll update this post as more info come my way. Continue reading Airtable Creator Plan, are you one of the lucky few?

Airtable: You can now group Views into Sections

I requested for this feature for a while now in the Airtable Community:

I’ve seen a lot of topics and/or feature requests to hide tables within a base. I want that as well. But on top of that, I don’t see topics here about hiding view items that you’ve actually created, not just those created and made personal view by other users. I’m not referring to how to toggle on and off the Views pane. I mean the different views that you’ve created, whether they be Grid, Form, Calendar, Gallery or Kanban, can they be hidden to declutter the Views pane, or better yet, maybe have the ability to group them in folders?

I have created several views of the same table and they somehow already cluttered my Views pane. I don’t want to delete them because I have certain use for each of them.

And today, look, you can now group views into Sections:

Thank you Airtable for listening to your users. Now I wish I could have the ability to hide this “Create a vew” pane/section.