ConditionalVisibility

new-products-promo

link-spreadsheet-data-image01

link-spreadsheet-data-image02

link-spreadsheet-data-image04

App tutorials

Excel app tips hero image

Microsoft Excel

Here's the easiest way to link data from one spreadsheet to another in Excel.

How to pull data from another sheet in Excel

Your spreadsheets don't exist in a vacuum, separate from each other. Use Zapier to connect them as needed with this integration. Set it up to automatically copy data between rows whenever you add a new row to an Excel spreadsheet. You'll never have to copy out that information again.

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. 

Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Triggers when a new row is added to a worksheet in a spreadsheet.

New Row

Triggers when a new row is added to a table in a spreadsheet.

New Row in Table

Triggers when a new worksheet is added to a spreadsheet.

New Worksheet

Triggers when a row is added or updated in a worksheet.

Updated Row

Finds a row by a column and value. Returns the entire row if one is found.

Find Row

Finds any rows that match a specific value in a given column.

Find Row(s)

Find or Create Row

Adds a new row to the end of a worksheet.

Add Row

Adds one or more rows to the end of a worksheet (with line item support).

Add Row(s)

Adds a new row to the end of a specific table.

Add Row to Table

Create Spreadsheet

Update Row

Copy new rows between Excel spreadsheets

The days of exporting your form submissions by hand are over. Set up this integration and Zapier will do it for you from now on. Any new Jotform submission will automatically create a new row on an Excel spreadsheet with all the responses you want, ready to be sorted, calculated, and analyzed at your leisure.

Jotform

Add new Jotform submissions to Excel spreadsheet rows

It's easy to manage groups of related data with tables in Excel. This Zap will make things even easier for you, automatically adding new Jotform submissions to Excel as rows in a table. That way, you can keep all of your data up-to-date and in a central location.

How to pull data from another sheet in Excel

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.