logo
logo

Zapier's automation tools integrate with Excel to make spreadsheets less tedious

avatar
Gladys Wiggins
img

Zapier taps the REST API used by Excel Online, which allows the online version of Microsoft Excel to pull in data from various online sources.

Microsoft s native app, Excel 2016, also allows you to tap data various sources like the Web, SQL Server, or Microsoft Access to pull data.

Zapier uses what it calls the Zap engine to create workflows, or Zaps, which are its proprietary name for what you'd call a Recipe if you used the If This Then That IFTTT service.

While Zapier has a menu of selected Zaps, you can also write your own—and that s where the company begins making money.

If you want to build more complex Zaps, use more than 20, or take advantage of premium app Zaps—Amazon S3, QuickBooks, and SalesForce, to name just a few—you ll need to pay at least $20 per month.

The only other catch is that you ll need to have your files stored on OneDrive for Business, the cloud storage associated with Office 365.

collect
0
avatar
Gladys Wiggins
guide
Zupyak is a free content platform for publishing and discovering stories, software and startups.