How do I add new role to top of Microsoft Excel table?

I want to add a row from Airtable to an Excel spreadsheet to the top of the table, rather than the bottom (as it is automatically configured to do). Is this possible?

Page 1 / 1

Hi @jamesharnett

Good question.

Help: https://help.zapier.com/hc/en-us/articles/8496044256909-How-to-Setup-Your-Microsoft-Excel-sheet-to-Work-With-Zapier

Aw shucks. Is there some way to trigger an automatic sort in Excel so that, let’s say I’m inputting a date (MM/DD/YYY) in a table, the table sorts all of the dates in a given column from earliest to latest, inclusive of the row that was just added?

@jamesharnett

Try using 2 tabs.

One tab for raw data added by the Zap.

One tab with formulas to pull data from the raw tab and sort.

https://support.microsoft.com/en-au/office/sort-function-22f63bd0-ccc8-492f-953d-c20e8e44b86c

I want to add a row from Airtable to an Excel spreadsheet to the top of the table, rather than the bottom (as it is automatically configured to do). Is this possible?

Reply

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded