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

Just in time for summer vacation, right?

No one likes tediously entering rows and columns of data into an Excel spreadsheet by hand. Zapier’s new integration with Excel Online means that you can now automate some of the process.

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. But Zapier’s hook is that updates to those data sources will also trigger updates in the corresponding Excel spreadsheet.

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. In both cases, an action happens, triggering one or more further actions. Zapier lists over 60 Zaps specific to Excel, such as the ability to add new Excel rows prompted by information scanned from business cards, or assign new Stripe charges to new rows in Excel. (Note that Zapier already has many, many recipes already written for other apps, so that you can create Zaps that assign these tasks to Google Sheets, for example.)

zapier 2 Zapier

Each Zap provides several ways to intertact with your data.

While Zapier has a menu of selected Zaps, you can also write your own—and that’s where the company begins making money. It’s always free to use up to 5 Zaps at once, and even write your own, with up to two steps. 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 company charges both for the number of Zaps you have in place as well as the number of times they’re used, also known as “tasks.” Use one Zap time after time after time, and your costs will increase.

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.

Why this matters: Zapier’s new tools probably won’t be necessary for those who gin up a spreasheet every so often. But for a small business struggling to complete a repetitive task that no one enjoys, Zapier’s new Excel integration might prove useful.

Join the PC World newsletter!

Error: Please check your email address.
Rocket to Success - Your 10 Tips for Smarter ERP System Selection

Tags ExcelMicrosoft

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Mark Hachman

PC World (US online)
Show Comments

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Matthew Stivala

HP OfficeJet 250 Mobile Printer

The HP OfficeJet 250 Mobile Printer is a great device that fits perfectly into my fast paced and mobile lifestyle. My first impression of the printer itself was how incredibly compact and sleek the device was.

Armand Abogado

HP OfficeJet 250 Mobile Printer

Wireless printing from my iPhone was also a handy feature, the whole experience was quick and seamless with no setup requirements - accessed through the default iOS printing menu options.

Azadeh Williams

HP OfficeJet Pro 8730

A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.

Andrew Grant

HP OfficeJet Pro 8730

I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.

Ed Dawson

HP OfficeJet Pro 8730

As a freelance writer who is always on the go, I like my technology to be both efficient and effective so I can do my job well. The HP OfficeJet Pro 8730 Inkjet Printer ticks all the boxes in terms of form factor, performance and user interface.

Michael Hargreaves

Windows 10 for Business / Dell XPS 13

I’d happily recommend this touchscreen laptop and Windows 10 as a great way to get serious work done at a desk or on the road.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?