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.
Excel Online for Business included in the following Office 365 plans:
Pricing with annual commitment; per-month plans for $6, $10, and $15/month per user, respectively
Last updated April 18, 2016. Please visit the official site for the most up-to-date information.
When numbers need crunched, there's one program most people reach for by default: Microsoft Excel. Spreadsheets are the original killer app for PCs, and after VisiCalc's original popularity, Excel took the lead as the most popular spreadsheet tool. It—along with the other Office applications—are some of the few programs you can find on almost any computer.
And for good reason. Excel includes more functions than most other spreadsheet tools, and is powerful enough to handle workbooks with over 17 million cells. Until recently, the only problem has been that you need a copy of Excel installed on your Mac or PC to view or edit spreadsheets.
That, even, is now changed with Excel Online in Office 365. It's an online version of Excel, with most of Excel's core features along with extra tools like surveys, Office Add-ins, Excel integrations with hundreds of business apps, and data visualization tools like Microsoft BI. Each of those let you do more with Excel than you ever could on your PC.
It starts with OneDrive for Business. OneDrive's file sync tools let you save your Excel workbooks—and other files—in one folder and have them automatically synced to all of your other devices or shared with your colleagues. You can then edit Excel files from any of those computers, using normal Excel on your Mac, PC, or mobile device with the new Excel for iOS or Android.
Or, for more web integrations—and to edit spreadsheets from any web browser—just go to Office.com, select the Excel app, and login with your Office 365 Business account. There, you can make new spreadsheets, or preview and edit existing spreadsheets you and your team have synced to OneDrive for Business.
Excel Online works much like normal Excel on your computer. There's a ribbon toolbar with Home, Insert, Data, Review, and View tabs each with tools to help you edit your spreadsheet, format data, and visualize it in charts. There's also a handy search bar—just type in the function you're looking for, and select it from the search results instead of hunting for it from the ribbon tabs.
For the most part, working with spreadsheets online feels the same as it would in Excel on your PC. There's 452 functions—nearly as many as traditional Excel—25 chart styles, and all of the core style, formatting, and sorting tools. You can't create pivot tables, sparklines, or some of the other more advanced Excel features, but if you open a spreadsheet that already includes them, you can view and edit them online.
Then, there's the features that are new to Excel Online. Since it's running in your web browser, you can share the file with anyone else—through OneDrive, an email, or with a link—and live co-edit the file together online. Or, add comments to the spreadsheet so your coworkers can pick up work on the same spreadsheet where you left off.
Need to gather data online? Excel Online includes a Survey tool, where you can build a quick survey and have the results saved to an Excel Online spreadsheet automatically. Or, for extra charting, data analysis, and other tools, there's an Office Add-ins button where you can add extra tools and integrations to your spreadsheets. Zapier's Excel integration also lets you connect Excel to over 500 other apps, to automatically log PayPal and Stripe sales, Salesforce and Highrise contacts, and much more to your Excel spreadsheets. And thanks to OneDrive sync, you can view the data that's added to your spreadsheets online automatically in Excel on your PC if you'd like.
Excel's still the reliable, powerful spreadsheet tool you remember—and with its new online sidekick, it's learned a few new tricks. You can now collaborate on Excel spreadsheets and bring in data from web apps easier than ever, all while using the same Excel functions and visualizations you're used to.
See a full list of the 465 functions supported by Microsoft Excel
Learn more about Office 365 features and pricing with our Office 365 review.
Conquer your workflow with Zapier. Sign up here to be the first to get reviews and tips for Excel and hundreds of other apps that help you get things done.
Have any feedback on this review, or something we should change? Let us know!