Here is a way to automatically pull information from airtable into Excel via power-Query using a bit of coding.
If you are looking to just copy and paste the code you need without much explanation, ignore the details :slightly_smiling_face:
Airtables datetime_parse function is unable to parse a date from a 1970 serial format.
A date column is pasted in your Table in as a serial number (ex UNIX format or 1970 serial format).
(Lets say that column is called "Instrument...
Not sure if I’m too late to the party, but here is a tutorial I made covering how to do exactly what you are asking: Airtable link to Excel via Power Query
It is complete with pagination code.
Email me if you have questions, but full disclosure, I do...
I suspect this is the error:
Should be as follows:
you may be having the same issue other’s have had.
Airtable link to Excel via Power Query Show and tell
@Adolfo_Ferreira and @Ivan_Larson
I tried using Adolfo’s code, and it looks legit. I see no reason why it is throwin...
Hello Simon, please send a screen shot. If I understand you correctly, your solution is to create another field to extract the data from your linked record field in a more friendly fashion.
Lets assume you have an INVOICES_tbl (that shows the to...