Wednesday 31 May 2017

How to Build Your Own Slack Bot

You're discussing a problem with your team and need a link to the bug to show them exactly what you're talking about. You could open your browser, search for the bug, and, once you find it, then paste it into your conversation. Or you could just type the bug's name in your chat app, and a bot could find the bug info and share it in the conversation automatically. Or perhaps you need to find someone's contact info and then send them an invoice. Just type their name, and a bot can do both in seconds.

Bots are handy little assistants that hang out in your app, wait for commands, and then find or create the thing you need. They're another way to use your favorite apps without needing to open those apps, running automated tasks for you. They're the big new thing—a core part of Slack, Facebook Messenger, and Telegram's newest features—and yet they're often too complicated to build and use.

Turns out, bots are simple enough for anyone to make. Here's how you can make a Slack Bot to do anything you want in a few minutes without any coding—along with a dozen examples of bots that real teams are using today, and a Slack bot cheat sheet for a handy reference to help build your own bots.



What Is a Bot?

robot versus bot
A robot on stage, and a bot in Slack

Robots can drive cars across the surface of mars, clean nuclear reactors, and cut precise holes in the body of your smartphone.

Bots are a little different. They live in your apps, not in the physical world. Rather than working assembly lines, they focus processing power on looking up facts and sending notifications right when you need them. They're tiny programs without buttons or icons. Instead of clicking a search button, you'll type a command like /giphy volcano to instruct the bot to find what you're looking for (a volcano gif from Giphy, in this case).

Bots are a buzzword right now, the big new thing in chat tools such as Facebook Messenger, Slack, and Skype, as well as in personal voice assistants, such as Amazon Alexa.

And yet, they're not exactly that new of an idea. Google, in many ways, is a bot that can answer lots of questions. Search for current time SF, and you'll get the current time in San Francisco just by typing.

DOS-era programs also behaved much like a bot. Open Terminal on your Mac and type uptime, or open Command Prompt on your PC and type net statistics server, and an age-old bot will tell you how long your computer's been turned on.

Terminal
Uptime and Whois website info from a tiny Terminal command

Handy, right? Instead of finding the right app and clicking the right button, you just type in a quick command and get what you want.

Perhaps you don't want to use Terminal all day—and you want something more personalized than Google offers. Say you want to find internal contact info, or make an invoice, or decide where to grab lunch as a team. You don't need a new app, and you don't need to open Google. All you need is your own bot, inside an app you're already using.

What Do You Need to Build a Slack Bot?

Zapier powered Slack bot
Zapier is the perfect tool to power your bots

You only need 3 things to build a bot:

  • A place to type your text
  • A bot to read your text
  • An app to do something with your text

All bots need to start is some text—the text you type that tells them what to do. That could be a Tweet (with Twitter bots that reply with flight status, say), a text message (like the y or n messages you send to your carrier to change your phone plan), or perhaps an email. Chat apps, though, are the perfect place for bots. Odds are, you use them already, and they include both a text box to type commands into and a conversation view to see what the bot replies.

Team chat app Slack is the perfect place to build bots for anything you need—and what we'll focus on in this tutorial. It's free to start using, and it's a tool where you likely already discuss ideas and projects with your team—with a text box that's perfect for sending commands to your bot.

Bots come built into Slack. We'll look at how to set them up in a minute. Essentially, you give the bot a name, tell it where to watch, and when you type a specific word or symbol, the bot will start listening and then send that text to your app.

Apps are the tricky part. They're famously difficult to build, and are the one step that might be keeping you from building your own bots. But they don't have to be that difficult. You could code your own app, or you could use pre-built integrations from Zapier instead.

Zapier is a tool that connects your apps without any complicated code, so you can pass data between them. Using Zaps, or integrations inside Zapier, you can connect Slack to hundreds of other apps just by clicking through a simple wizard. For example, once you build a Slack Zap, it can watch for commands in any chat channel and kick off a workflow in another app, or track down info in one tool and send it back to Slack. That's how you can build the most powerful bots in your own Zapier-powered slash commands, as we'll walk you through below.

So let's use all 3, and see what type of bots we can build.

What Types of Slack Bots Can I Build?

Slack bot
Our WolframAlpha-powered bot that can answer questions and perform conversions in Slack

The first time you open Slack, you'll be greeted by a friendly Slackbot that asks your name and time zone. Type in the replies, and your account will be personalized without a click, like magic.

You can then harness that magic yourself with your own bots. These come in three varieties:

Slackbot Responses

Slackbot Responses
Add simple replies for things everyone needs to know

The simplest bots come built into your Slack settings. You add a phrase for the Slackbot to watch for, and then tell it how to respond.

Say you want a simple way to find the security code for your office: just tell Slackbot to watch for messages that say office security code, then have it respond with the number. You could make more whimsical prank bots that send GIFs—or more serious bots to share important phone numbers, email addresses, or other helpful info.

To make a Slackbot Response, just go to slack.com/customize/slackbot and add the phrase and response you want. These will automatically work in any channel other than your personal Slackbot channel.

Or, you can make your own custom bots in Slack that watch Slack for text and automatically reply, either with the bot API or Zapier. We'll look at that below.

Notification Bots

Slack Notification
Get notified about anything you want, right inside Slack

Notification bots are the next easiest Slackbot to make. Instead of watching Slack for a phrase you type, they watch another app for an update and send it to Slack.

They look like another user in Slack, with their own name and icon. They'll show up every so often when there's something new—a news update, new document, or trending hashtag, perhaps—and post it to your Slack channels.

There are dozens of notification bots for social networks, news, and more in the Slack App Directory. Or, you can build your own notification bots with Zapier—perhaps even using a pre-made Slack integration that you can set up in a few clicks.

We'll look at how to make these in just a minute—but here are some popular Slack integrations if you can't wait.

Slash Commands

slash commands in Slack
Build powerful workflows with slash command bots to do work right from chat

If you're looking for a bot that you can summon at will, though, slash commands are your best bet. Unlike notification-based bots, slash command bots wait for your signal, then perform some sort of task based on context that you provide.

You trigger them by typing a / followed by their name (/giphy, say, for the Giphy bot), and then type in a command. The bot will then find what you're looking for and post it back to Slack in a reply.

Bots can do just about anything you want: start a new meeting, compute a value, do research, and more. For that, you'll need to either code your own app or use Zapier integrations to connect Slack to over 700 of your favorite apps.

How to Build a Bot in Slack

Now that you know the type of bots you can build, it's time to make your own. Let's look at how you can make customized bots in Slack for replies, notifications, and commands—all without writing a line of code.

Building a Slack Reply Bot

Slackbot's default reply tool is rather limited, since it can only post the same response every time. What if you want a customized response—or perhaps a random response—each time?

New Message posted anywhere in Slack
Have Zapier watch for messages posted anywhere in Slack

For that, a Zapier-powered reply bot is your best option. First you'll need to create a Zapier account or log into your Zapier account.

Then, click the Make a Zap button in the top right corner, and select Slack as your Trigger app. On the next page, have your Zap watch Slack for a new message posted anywhere. Alternately, if you want this bot to only work in one channel, you could have Zapier watch that specific channel.

Select the field from slack
Choose the field you want Zapier to watch

Then you'll need a filter to watch for a specific term—otherwise, your bot would run every time anything is posted to Slack. Add another action to your Zap, this time selecting the Filter by Zapier app. In its settings, have it watch the Text field for the term you want.

Slack Filter in Zapier
Tell Zapier what to watch for

If you want the bot to run whenever those words are posted to Slack, then have the filter watch for (Text) Contains. Otherwise, if you want it to only watch for that specific phrase on its own, have the filter watch for (Text) Exactly matches.

Then, you can add your reply, creating a basic bot. Just add another step to your Zap, selecting the Slack app and the Send Channel Message action. There, in the Channel field, select "Choose a custom value" and then select the channel name from your original Slack message so the reply will end up in the same spot.

customized message in Slack

All that's left is to type in the message you want to post in the "Message Text" box. Scroll on down, and you can add a name and icon to your bot—or have it post to Slack using your name, if you want. Save and turn on your Zap, and it'll send your customized message every time.

For something more customized, though, try a Formatter action before your bot's reply. Formatter is a handy tool that can format your text, calculate values, choose random values from a list, and more.

Formatter in Zapier

Say you want to make a birthday bot that sends a random GIF from a list whenever someone says "Happy birthday!" Our filter above is already watching for the correct phrase—all we need now is the Pick from list Formatter, and a few GIFs.

To add the Formatter action, click the Continue button or + on the left sidebar of your Zap to add a new action, and choose the Formatter by Zapier app. Then, select the Pick from list formatter in the Transform field, and enter the GIF links in the Input fields.

With that done, repeat those steps, only this time select Slack as your action app, and choose its Send Channel Message action. Then, in the message text box, add your birthday message and click the plus button on the right to add your random GIF from Formatter. Turn your Zap on, and the next time someone says "happy birthday" they'll get surprised with one of your GIFs.

Building a Slack Notification Bot

Notification bots are even easier to build in Zapier. All you need is an app or site to watch for notifications, and Zapier can automatically send those to Slack for you.

Trello Zap

Say you want to be notified in Slack whenever new tasks are added to your Trello kanban board. First make a new Zap for Trello–with the "Make a Zap with Trello" button. Then, in the Choose Trigger step, select New Card to have it watch Trello for new cards on the board you want to watch.

Next, click the plus sign + to add a Slack action. Now you can set the Zap to send a message either to a channel or as a direct message to anyone on your team. You can customize the message with any text you want. Click the + icon on the right of the message text field in Zapier to add info from Trello about the card, such its name, link, description, and more.

You can quickly make Slack notification bots for any of the 700+ apps that connect to Zapier, or with any site that uses RSS. Here are some popular integrations to get started with in a few clicks:

Building a Slack Slash Command Bot

Add Slack App
You can build an interactive Slack app without coding

Now you're ready to build the most advanced bots in Slack: slash commands. They're the bots that wait for a command and then do whatever you asked. Make a document, find an email address, start a call, log records–you can make a bot for that and more.

It all starts by adding a new app to your Slack account. Go to api.slack.com/apps, select Create New App, enter a name for your app, and select the correct Slack account where you want to use the new Slack bot.

Slack will then show some options to add features to your app. You can add bot users, interactive messages, and more—but each of those require coding. Instead, we're going to select the Slash Commands button. Click Create New Command, then it's time to set your bot up.

Create Slash Command for slack bot

First, add a command with a slash in front of it—perhaps /contact if you want to look up contact info, /weather to build a weather bot, or anything else that fits your needs. You can then add a short description and usage hint

We skipped one field—the Request URL. Here, you'll add a Webhook URL where Slack will send the data you typed to the command. You can use that to code your own app, pulling out the text, username, and other data from Slack from the webhook.

We're going to build our bot without coding—so we'll use Zapier's Webhook integration to capture the data from Slack and put it to work. Let's grab that URL first.

In a new tab or window, make a new Zap using Zapier's Webhooks app. Select Catch Hook when setting up the Webhook integration, click Continue on the options (you don't need to add anything here), then copy the Webhook link you'll see in the testing page.

Copy Webhooks URL from Zapier

With that Webhook link copied, go back to your Slack slash command's configuration page from before and paste the link into the Request URL field—and then save your settings.

Slash command in Slack

Now it's time to test your slash command so we can build the rest of its Zapier integration. Just open Slack, type in your command followed by text you'd like to use in the bot. I'm building a bot that will find contacts in Google Contacts and send me their email address in Slack, so I'll enter a name that I can use to search Google Contacts.


It's time to make our bot smart. Go back to the tab where you'd opened Zapier, and click the OK I did this button for your webhook step. Zapier will find the data from your slash command, and you'll be ready to put it to work.

Now, it's time to use the data. Here are some quick ideas to try with Zapier integrations:

  • Use Formatter to split your text into sections, format the text, calculate numbers, and more.
  • Use Searches and Lookups to find info in your favorite apps—perhaps to find an entry in a spreadsheet, a contact in a CRM, a customer from your payment app, and more. There are also searches in apps like Giphy that can find info online based on your query.
  • Use standard Zapier Actions to save info to your apps—say to add a new contact, create a document, log time spent on a task, and more.
Google Contact search

Let's try using a search to find a contact from Google Contacts account. Add an action to the Zap, select Google Contact, then use the Find Contact action. Have it search by name, then select the text from your Slash Action as the search query.

Select correct Slack channel

Now that Zapier's found your contact, it's time to send it back to Slack. Just add another action to your Zap, and select the Send Channel Message action. Instead of selecting a specific Slack Channel to post the message to, choose Use a Custom Value at the bottom of the channel list, then use the Channel Name field from your webhook to select the channel where the slash command was used.

All you need to do now is create your message. Click the + icon beside the Message Text field to add any info you found from the Zapier search. Then, customize the bot, adding the same name and icon image as you added to Slack previously.

Test the Zap, and you'll get the response in Slack you wanted.

Bot response in Slack

Now, anytime you need a contact—or whatever you built your bot for—just type your slash command followed by the text you need to use, and Zapier will do the work for you automatically.


Want to build a more advanced bot? Try adding extra steps to your Zap—perhaps to create a template document and then post it to Slack—or use Code Steps to create advanced bots without having to code a full app.

Or, for the most advanced bots, try using Named Variables to gather more than one text item at once. Just decide what you want to gather with the bot, and a standardized name for each item, then write them followed by parentheses with the values you want. For example, say you want to gather a name and email in your bot. In Slack, type Name(Bob Smith) Email(bob@gmail.com), and Zapier will recognize each as a separate item you can use in subsequent actions.

Slack named variables Zapier
You can see your full Slack message or the individual elements in Zapier

Then, when you build your Zap, you can select the Name and Email fields individually to add them as a new contact in Google Contacts.

With those powerful tools, combined with the hundreds of apps that connect to Zapier, you can build bots that do anything you want.

Example Bots That Help Teams Get Work Done From Slack

You could make a bot for anything—but what would actually be a useful bot for your team?

On the Zapier team, we have a number of bots both for play and productivity. The oldest slash command on our account is a GoToMeeting integration: Type /gtm anywhere in our Slack, and a bot uses Zapier to make a new GoToMeeting link and share it in the conversation for a quick way to jump on a call with team members.

Need to reserve a server for testing? /reserve does that in Zapier's Slack. /afk lets us tell the team if we'll be out of office like those old AIM away messages, /compute finds answers from Wolfram|Alpha, and /random gives us an easy way to make decisions with random numbers. And, when it's time to unwind, /spyfall starts a text-based game of Spyfall using direct messages to tell each player their role.

But that only scratches the surface of what bots can do in Slack. Here are some other great Zapier-powered bots for Slack—ones that just might fit needs your team has, too.

Write Invoices and Emails

Tired of writing the same emails over and over? The Billfixers team was, too, so they built a bot to write emails.

"The need that prompted both of them was trying to find ways to increase our efficiency instead of doing things by hand, but without having to add a bunch more applications to our workflow," says Billfixers co-founder Ben Kurland. "It was just time on our end that we weren't actually using to help our customer, just to do what was essentially data entry."

So, when they need to tell a customer that they just saved them money on a bill or need to send along an invoice, they can now send that person's name to their bot. It finds their info in SalesforceIQ, uses some code to calculate the savings, creates a draft email in Gmail, then shares it to Slack. "From there, a human can add finishing touches and spend their time adding meaningful interaction with our clients, rather than having to act as a robot themselves," says Kurland.

That worked so well, they also built another bot to create invoices in Freshbooks right from Slack.

Find Email Addresses and Other Data

Find email addresses from Slack

Google is great for web searches—but when you need to find a contact's email or a specific item in your database, it's often far harder to find what you need. You have to remember which app to check, open that app, search, and finally find what you're looking for.

Or, you could just use bots in Slack to help with all of your searches, as the 90 Minute Books team does.

Their set of search bots started out with a $whois bot built by co-founder Stuart Bell. You post someone's email address to this bot, and it searches FullContact then returns their full contact info to Slack.

They then added a bot to shorten links, and another to generate a Book ID for new book projects. And when they need more info about a book, the $gogo bot will find all of the info about a book project from its ID.

"It gives people visibility without needing access," says Bell. "And even for the team that do have access, a quick check often saves them having to log in to a different tool.

Choose Lunch Destinations

Get lunch recommendations in Slack

"What's for lunch?" is a question everyone's asked—and when it's time to have a team lunch, it's a question that's hard to solve.

"Lunch is a serious matter, with Livestorm being French," says CEO Gilles Bertaux. "We usually spend a lot of time looking for a place and then debate about it. So we thought it would be nice to have a little something that could help us decide and experience new meals."

And so, they built a food bot with Zapier and Slack. They scraped the best lunch options with delivery near their office from Yelp using Import.io, and saved them to a Google Sheets spreadsheet. Then, with a Schedule Zap, they have the bot run at the same time every day, choosing a random restaurant from the spreadsheet and posting it to Slack.

It gave them handy food recommendations right when they needed them—and has inspired them to make a better curated database for more customized lunch recommendations than Yelp's top listings.

Find Bug Info Automatically

Link to bug in Slack

Bots even make sure the apps for shows like The Voice UK and Britan's Got Talent work perfectly. Tellybug, the team behind those and other tools to make TV shows engaging, wanted a simple way to collaborate on bug reports right from Slack.

"People would mention a bug number in Slack (or on a call) and then everyone would have to go search to look up the bug," says Tellybug CTO Malcolm Box. "This seemed automatable."

So, with a Zapier-powered Slack reply bot, the Tellybug team built a Zap that watches Slack for mentions of bugs. Whenever it finds one, it searches for the bug in Fogbugz, their bug tracking app. Then, with some filters and code to pull out the relevant info, the bot posts the correct info about the bug back into Slack.

"The bot's made it much easier to have discussions about bugs and to keep everyone on the same page when doing bug triage," says Box.

Run Standup Meetings in Chat

Standup Meeting in Slack

You need to know what each person on your team is working on, but you might not need to waste time with a full meeting. Instead, you could rely on a bot like the Robots and Pencils team does.

Each weekday, their bot posts a Standup Time reminder with questions about what they're working on. Each team member can then reply, using Zapier Named Variables to list replies to each question. A Zap then saves each response to a Google Sheets spreadsheet for a log of each virtual meeting. "From here I can put together some cool burndown charts based on other spreadsheets I have created," writes product manager Ben Myers.

Add Tasks to Your To-do List

Add tasks to Trello from Slack

Or, if you just need a simple way to add tasks to your project, a bot can handle that, too. Parabol CEO Jordan Husney does just that with a bot, for a quick way to add tasks to Trello that come up during their Slack-powered standup meetings.

Once again using Named Variables in Zapier, he posts a new task to his jrtask bot, and Zapier turns that text into a new card in Trello. "Lowering the friction of capturing tasks means spending more time staying focused on the task in front of you," writes Husney—which is exactly what his Trello and Slack bot does.

Remind Your Team to Submit Timesheets

Time Sheet Reminder in Slack

Want to spend less time reminding your team about regular tasks—and want to make sure you don't come across as nagging?

"I found myself often sending random timesheet reminder memes to my team, so I automated this," says devPHASE lead developer Matt Healy. So, with a bit of PHP code to pull a random timesheet meme from Google Images, and a Zap to post that image along with a reminder into Slack, he automated that task away.

Then, as Healy says, "hilarity and timesheet completion ensues."

For a more powerful workflow, you could make a companion timesheet tool similar to the standup meeting bot above that lets your team post their time logs to your time tracking app right from Slack.

Learn About Your Team Members

HR Bot

Automated Insights builds tools to turn data into stories automatically—and they wanted the same automated insights about their own team. So, during a team hackathon, director of customer experience Matt Nisonger and his team turned their employee directory into a bot.

"Our head of HR collects a lot of information about each employee's personal interests, hobbies, etc., but never did anything with it," says Nisonger. "That spawned the idea of using a Slack bot to learn interesting things about new and existing employees."

With a Typeform for to survey the team, Google Sheets to save the data, and their own Wordsmith app to turn the data into stories, they had everything needed to build a bot.

Now, when a new team member joins the team, they're asked to fill out the survey, and the bot shares info about the new team member in Slack. And if you ever want some trivia about someone on the team, just send their name to the bot and it'll reply with a fun fact about them.

That's only one of the many ways the Automated Insights team uses bots. "we probably have 10-20 various bots integrated with Slack, everything from Intercom to bug reporting to server status reporting," says Nisonger. "Some are better than others, but overall they've been positive for productivity."

Create Support Tickets Inside Conversations

Want to make sure problems are solved for your team as quickly as possible? You could build a bot for that, as the Business Insider team did.

"Our team's main communication tool is Slack, and we wanted to make it super easy for anyone on the team to submit a ticket through Slack," says Business Insider team member Kyle Dowley. All their team has to do is use their ticket bot and post the problem they're having. That has Zapier check Google Sheets for that team member's contact info, then uses it and the Slack message to create a ticket in Zendesk. When that's done, the Zap sends that team member a direct message in Slack to let them know the ticket's been created—and also gives them a link to the FAQ to perhaps help them find a solution on their own.

"For many people, using this bot is now the preferred method of submitting support requests to our team," says Dowley. "It helps to make sure all support requests are in one place with better tracking and visibility."

And it's simple to use: you can ask other team members if they're having the same problem, then turn the issue into a ticket right from the same Slack conversation.


Download a Slack Bot Cheat Sheet

Now that you know how to build a bot, it's time to build your own. But you'll need a way to keep track of each step to make sure you can make every bot you need.

Just check out the cheat sheet below—or download a PDF copy—to make sure you never forget how to build bots in Slack.

Slackbot cheat sheet

Go Build Your Own Bots!

Building your own robot is difficult. You'd need motors, controllers, gears, and dozens of other parts—not to mention time to code the robot and get it working the way you want.

Bots? They only take a few minutes, and they're free!

Just make a Zapier account, open Slack, and start building a robotic buddy who can lend you a hand. Or, try building a similar bot with Twitter, HipChat, Telegram, SMS messages, or any other chat-like tool Zapier supports. Need a simpler way to make appointments, a filtered notification tool that doesn't ding every minute, or a detailed workflow to build documents in a second? You can make a bot for that.

What will your bot do?

Made a great bot in Slack or another chat app? We'd love to hear about it in the comments below!

Honda Asimo robot photo by Satoru Fujiwara via Flickr.



source https://zapier.com/blog/how-to-build-chat-bot/

Powerpoint Alternatives: The Best Presentation Software in 2017

From school classrooms to Apple product launches, slideshow presentations have quickly become the standard accompaniment to lectures. You can't give a speech without a slideshow, it seems. And they all feel same. Presentations are dominated by Microsoft PowerPoint and Apple Keynote, apps that are all but omnipresent.

There are good reasons they're so popular: PowerPoint and Keynote come packaged with Microsoft Office and new Macs, respectively, and they've been around for a long time. They're also full of valuable features, from dozens of slide templates to a variety of polished transitions. But knowing how to take advantage of all they offer gets so complicated that there are entire books and courses about them.

Making a delightful and well-designed presentation shouldn't be so hard. That's the aim of a wave of new presentation software, including simpler online versions of PowerPoint and Keynote themselves. These new tools are easier to use, give you the ability to collaborate with others—sometimes in real-time—and allow you to edit your presentation on any internet-connected computer.


What Makes Great Presentation Software Great?

There are occasions that call for a beautifully crafted presentation. That's when you should call a designer or use a service like SketchDeck to craft professional PowerPoint or Keynote slides. Most of the time, though, you just need a simple way to present your thoughts, and perhaps let your colleagues contribute. That's where these new presentation apps excel.

When looking for apps to include in this roundup, we selected tools that:

  • Make it quick to build a presentation
  • Have a clean design that's simpler than the traditional PowerPoint
  • Include unique features that bring something new to the table
  • Let you easily collaborate on presentations

With each presentation app listed, you'll find a screenshot and description of the app, what it does best, and its starting price. Most of these apps are free, but even if there's a cost, the product is priced competitively with PowerPoint and Keynote.

What you won't find in this list are apps only available for mobile, apps with an emphasis on video, or apps built specifically for sales presentations.


The Best Presentation Software

The Best Apps to Share Presentations


Google Slides for real-time collaboration

Google Slides

Google Slides has become the gold standard of collaborative cloud-based presentation software. It's a part of the popular Google Docs suite, and is a solid—if bare-boned—presentation app. After selecting a pre-made theme for the slideshow, you'll make your presentation in a simple online app that's similar to other Google tools. You'll find most of the standard presentation software features, including animations and slide transitions, and it's very beginner friendly—anyone should be able to pick up Google Slides and quickly begin making presentations.

Google Slides really shines when it comes to collaboration. All you need is a Google account to be added to a Google Slide presentation to begin making real-time edits. Collaborators can chat with the built-in IM functionality, so group projects become a lot easier. Additionally, all edits are logged, so you can view all revisions made by your collaborators.

Google Slides Pricing: Free; extra storage from $1.99/month for 100GB

Zoho Show for built-in broadcasting options

Zoho Show

Zoho Show is part of the Zoho Docs suite, an online alternative to Microsoft Office and Google Docs. It offers a no-frills way to make slideshows from your web browser. Zoho Show's interface is reminiscent of both newer and older versions of PowerPoint, with a tabbed interface and simple drop-down menus. If you're used to PowerPoint, you will love how Zoho Show lets you create content instantly by clicking into pre-made text boxes to add text to slides and apply themes with a single click.

Its best feature, though, may be "broadcast", which lets you remotely present slideshows in real time to anyone on the web. Viewers can view the broadcast in their browser after you've shared it with an email or link, and when combined with a conference call, it can make for a great remote lecture tool. Even if you'll be presenting in person, you could use this to practice your presentation ahead of time.

Zoho Show Pricing: Free; extra storage and features from $5/month

Slides for a modern take on presentations

Slides

If you want to get creative and customize your own slide themes, the simply named app Slides is perfect for you. This HTML5-based presentation tool lets you create your own slide styles using beautiful fonts, shapes, smooth transitions, and color sets that look great in any modern browser. These presentations are then hosted on the web and can be shared with ease.

Slides' best feature is its clean interface—modern and fresh, with a unique design that shows tools as you need them in a sidebar. It doesn't require digging through menus to get to special design tools, which is something that can't be said for other presentation apps.

If you're a web developer or designer, Slides is especially great for you. It includes code syntax highlighting out-of-the-box, and with its Pro plan, you can add custom CSS to your presentations for easy styling and branding.

Slides Pricing: Free for public presentations; $5/month Lite plan for private presentations and more; $10/month Pro plan for collaboration and more; $20/mo Team plan for custom branding.

Prezi for animated, non-linear presentations

Prezi

Prezi is a new take on the traditional slideshow. Combining animation with the information you'd include in a traditional presentation, it's a simple way to make a dynamic, non-linear show that's far more than just a slideshow.

When creating a Prezi, you're prompted to select a theme that goes with the topic of your presentation and add content to frames within the presentation. These frames can be animated signs, planets floating in space (pictured), or a slew of other objects depending on the theme you choose. Frames take the place of slides; they still have text and headings, but their backgrounds are all shared and technically everything is part of one large slide.

As you proceed through your presentation, Prezi will zoom in and out of the background to show each of your frames. Instead of a parade of static images, your presentation will be a dynamic visual tool, perfect for keeping your presentations interesting even if your subject matter is dull. And you'll have spent less time making the Prezi than you would have spent picking out boring PowerPoint transitions for each slide.

Prezi Pricing: Free for public presentations; $7/mo "Standard" plan for private presentations; $19/mo "Plus" plan for offline editing and advanced tools; $59/mo "Premium" plan for training, phone support, and analytics.

Canva for creative presentations

Canva

Though Canva is primarily a design app, you can make some pretty wicked slideshows with it. The app includes a large library of stock images, backgrounds, and specially formatted text boxes that, with a bit of creativity, can be used to make polished image-focused slides. The whole interface is drag-and-drop, so you can tweak your slideshow to look exactly the way you want.

Canva also has a wide range of built-in layouts for any occasion: from professional presentations to travel guides. These layouts can be customized using the same drag-and-drop tools and are be great starting points for corporate branded presentations.

Canva Pricing: Free, with paid images and layouts starting at $1

Swipe for interactive slides

swipe

Swipe, another great tool for simple presentations, lets you quickly make slides by dragging and dropping in the multimedia elements you want to include. It then lets you pick solid color backgrounds and add text with Markdown formatting. Then, present your presentation online, letting others follow along in real time.

We've seen those features before in other separate apps, but bringing them together makes for a compelling—if basic—presentation app. But then, in a surprising twist, it also lets you add polls to your slides to gather live feedback from your audience. While you're giving your presentation, anyone following along on their own device can answer your poll and the results will be shown in real-time.

Swipe Pricing: Free for 2 presentations; starting at $15/mo for unlimited presentations and extra features.

Haiku Deck for great mobile editing

HaikuDeck

Haiku Deck is a basic presentation software with a limited selection of themes, slide layouts, and formatting options. Its navigation is extremely simple with all of the options and tools available from the home screen. If you're wanting a no-frills presentation creation experience, you'll love this app.

When you create a presentation on Haiku Deck, you have the option of uploading it to the service's gallery of presentations. This searchable library is available for viewing for free and is a great way to share your knowledge with the world.

But Haiku Deck's most useful and unique feature is their artificial intelligence tool, Haiku Deck Zuru. Zuru works with an outline or existing presentation and builds your slides for you, assembling slide formats and choosing images and styles. This tool is ideal for someone who needs a sleek presentation but doesn't have the time or skill to assemble the slide deck themselves.

Haiku Deck Pricing: Free for 1 public presentation; private plans starting at $9.99/mo for the basic plan.

Slidebean for automatic slide creation

SlideBean

If you want to skip the tedious process of formatting presentations, Slidebean is right up your alley. When starting a new presentation, all you have to do is curate the text, images, and videos you want to include. Then, select a theme and Slidebean will create a presentation for you, complete with formatting.

After making final edits to your slideshow, you can choose to download your presentation or present it from the web. This—combined with Slidebean's quick slide creation—makes the service a great option if you find yourself needing to create a presentation in a pinch.

Slidebean Pricing: Plans start at $24/mo.

Deckset for easy Markdown-powered presentations

Deckset

If you keep good notes but dislike the process of turning said notes into presentations, Deckset for Mac is just what you need. Simply take notes in your favorite text editor, format them with Markdown (pictured), and separate them into sections with dashes. Then import them to Deckset, select a template, and Deckset will do the rest—it takes your notes and creates slides without any help, making for no-hassle last-minute presentations.

If you're a writer who uses Markdown, you'll love how easy Deckset makes it is to turn your writing into a presentation. And if you're a developer and need to present code to an audience, you'll dig how Deckset will automatically recognize your code and apply syntax highlighting in your presentations.

Unlike the other apps in this list, Deckset is a Mac app that lives on your desktop, so it doesn't have the cloud-backed simplicity of working from anywhere or collaborating with others. Deckset's simplicity, however, is hard to beat, and if you save your work to Dropbox or use a collaborative writing app to draft your presentation notes, you'll get the best of both worlds.

Deckset Pricing: $26.99 on the Mac App Store

Evernote Presentation Mode to turn notes into a presentation

Evernote Presentation Mode

Or, there's another even simpler way to turn your notes into a presentation: the new Presentation Mode in Evernote Premium. Just write your notes in Evernote as normal, complete with lists, attached files, and formatted text. You can use just one note or select several notes together and Evernote will automatically make a table of contents for your presentation sections.

Then, when it's time to present, just open your notes, click the slide screen icon in the toolbar, and Evernote will turn them into an easy-to-read presentation. There are no transitions or animations, but there is a simple virtual laser pointer so you can point out the most important stuff.

Evernote Pricing: $69.99/year for Evernote Premium to access presentation mode.

PowerPoint Online for Microsoft Office compatibility

PowerPoint Online

If you're not ready to ditch PowerPoint completely, but still want something simpler, online, and cheaper, PowerPoint Online is right up your alley. This free web app from Microsoft gives you all the basic features of the desktop version of PowerPoint, for free, in your web browser. The app's interface is almost identical to that of PowerPoint 2013 and offers PowerPoint's familiar drawing tools and iconic templates.

Because PowerPoint Online syncs your presentations to OneDrive, you can start a making presentation using a desktop copy of PowerPoint and then edit and present using PowerPoint Online. This is especially useful if you have multiple computers and only one license for Office.

PowerPoint Online Pricing: Free; extra storage from $1.99/month for 50GB

Keynote for iCloud for beautiful templates

Keynote for iCloud

Like PowerPoint Online, Keynote for iCloud is an online version of its popular desktop namesake. Its interface is very similar to the app's mobile iteration, Keynote for iPad, and the "iCloud" in its name means it syncs presentations to both the mobile and desktop Keynote app. While Keynote for iCloud may not have all of the features of its desktop counterpart, it is great for quickly creating beautiful slideshows on the web, and includes the simple collaboration features you'd expect in a web app.

Apple has included pre-made templates for every occasion, with sleek lines and polished graphics, and includes more typefaces than any other app in this list. Additionally, Keynote for iCloud's transitions and animations are extremely smooth, just as in its desktop counterparts.

Keynote for iCloud Pricing: Free with all Macs and iOS devices; extra storage from $0.99/month for 50GB


Share Your Presentations

Now that you've created beautiful and informational presentations, you'll want feedback on your work before the big day. Then, you'll want an easy way to share your presentations with the world.

There are plenty of great apps for this, too. From collaborating with others to distributing your slideshows, each of these tools has a unique strength.

SlideShare for sharing your presentation

SlideShare

If you've made an awesome presentation that you'd like to the world to see, upload it to SlideShare. It's the presentation social network owned by LinkedIn and is to presentations what YouTube is to videos.

Your slideshow will be added in the website's database of presentations—now more than 15 million of them—making it easy for anyone to search through its text and flip through the slides. It's an easy way to share your knowledge and build a portfolio of content that is connected to your LinkedIn account.

SlideShare Pricing: Free

Speaker Deck for embedding presentations on your site

Speaker Deck

When used correctly, presentations can be great marketing tools for your website. However, before you can take advantage of this marketing technique, you have to find a way to embed presentations on your website. That's where Speaker Deck comes in.

In order to use Speaker Deck, you must export your PowerPoint or Keynote presentation as a PDF. Once uploaded, the service will split each page of your PDF into individual slides and give you an embed code. Additionally, your presentation will be available for viewing on Speaker Deck's catalog of slideshows.

Speaker Deck Pricing: Free

SlideDog for mixing in multimedia and live-sharing

SlideDog

Sometimes presentations can go beyond your slide deck, needing to incorporate websites, PDF, videos or even slides from another presentation app. That's when SlideDog can become your best friend. This app was made to make your presentations seamless, no matter how nervous you are at showtime. On top of allowing users to put multiple media formats in a timeline, the tool offers live-sharing and interactive features, such as polls and feedback forms.

SlideDog also comes with a companion smartphone remote app that lets you control your presentation without touching your computer. You can use this remote to change slides, switch presentations, and even play and pause videos. Think of it as the slideshow clicker you'll never forget at home.

SlideDog Pricing: Free; pro features from $8.33/mo

Poll Everywhere for polling your audience

Poll Everywhere

Poll Everywhere makes it simple to engage your audience with a real-time poll, pulling in responses from mobile phones, Twitter or web browsers. You can employ it either as a standalone polling app alongside your presentation or if you're a PowerPoint user with Windows, you can tie it into the software with Poll Everywhere's PollEv Presenter App.

Poll Everywhere Pricing: Free for 25 responses per poll; more responses and features starting from $19/month.

Presentain for easy presentation recording and posting

Presentain

Presentain is a presentation companion, ready to help you engage with your audience like Poll Everywhere. Its stand-out feature lets you record your presentation audio, combine it with a recording of your slides, and upload it as a video online. It's easy "slidecast" creation that makes clever use of your phone's microphone.

Presentain Pricing: Pay for what you need—you can choose your Presentain plan based on unlimited use by Day, Week, Month, or Year.

Present.me for publishing an online presentation

Present.me

If you want to share your slides alongside a video of you delivering the presentation, but didn't record a live presentation or have one to capture in the first place, Present.me will come to the rescue. This app allows you to do just that—and also has options for slides with audio recording only, slide deck only, or video only.

Present.me Pricing: $9.99/month for 5 active recordings and basic features; $17.95/month for 30 active recordings and advanced features; $49/mo for team features.


Have a favorite presentation tool not listed, a unique tip for one of these apps, or a clever presentation hack, such as relying on Google's Chromecast? We'd love to hear about it in the comments below!

Zapier marketers Danny Schreiber and Matthew Guay contributed to this post.

Credits: Presentation icon courtesy XOXO.



source https://zapier.com/blog/best-powerpoint-alternatives/

Tuesday 30 May 2017

The 6 Best Office Suites for Your Documents, Spreadsheets, and Presentations

Documents, spreadsheets, presentations, and notes—they're the files that make work work, that showcase your new project and last quarter's performance and your ideas for the future. They're such a crucial part of computing, it's hard to imagine a computer today without an office suite.

For years—decades even—that meant it was hard to imagine a computer without Microsoft Office. Today, it's easy if you try. Office has more and better competitors than ever, while at the same time the features we need from office tools have changed—things like collaboration, offline and online access, and compatibility with multiple devices.

Microsoft Office 365, Google G Suite, Zoho Workplace, Apple iWork, Quip, and LibreOffice are the biggest office suite players today. Which set of tools should you use? You might already have an older office suite and are wondering if you should upgrade to Office 365—or if the G Suite tools in your Gmail account are enough. Or maybe you're trying to decide which suite to roll out to your team.

We reviewed the best features in these office apps to help you pick the suite that fits your needs best.


The 6 Best Office Suites:

App Icon:  Best for: Free for: Paid Plans from:
Office 365 Office 365 Office compatibility with desktop and tablet apps Personal online apps $6.99/mo. personal; $10/mo. per user Business
G Suite G Suite Collaborating with a team in online documents Personal online apps $5/mo. per user
Apple iWork Apple iWork Making stylish files in minutes on Apple devices Full features with Mac or iOS device
Zoho Workplace Zoho Workplace 30+ apps in one suite 25 users & 5GB storage $3/mo. per user
Quip Quip a new, paper-free approach to office Personal use $25/mo. for 5 users
LibreOffice LibreOffice A free desktop office suite Full features

What Do You Need in an Office Suite?

For years, the most important thing in an office suite was how well it opened Microsoft Office files, because Office was—and still is—the office suite most commonly used in companies big and small. Someone would email you a .doc or .xls file, you'd add edits, then send it back. If your programs didn't show the files the same way, the documents would slowly become a mess.

Compatibility is still important—and in this roundup, the first screenshot for each office suite shows a standard Word document to test how well it imports files. But other features matter, too, especially today.

Collaboration is perhaps most important in a modern office suite. Instead of emailing a file to a colleague, you can send them a link to your file and view it together online. Web apps made compatibility somewhat of a lesser concern since everyone can use the same apps if you're working online.

Mobile is equally important. You might add details to a draft document from your phone on the train, then your boss could approve them from a tablet during a flight, trusting the changes will magically sync up once they're back online. That should just work in today's workplace, especially when so many teams are distributed and we tend to work on the go.

Although files and styles change, at the core you still need tools to organize your ideas, crunch numbers, and turn them into something that works for your team. Each of these suites does that in their own unique ways. You might find one that fits your needs—or you may end up with a traditional office suite installed on your computer while also using another set of online apps to collaborate with your team.

Microsoft Office 365 (Web, Windows, Mac, Android, iOS)

Best for Office compatibility with desktop and tablet apps

Microsoft Word for Mac from Office 365
The first word processor most of us used, Word is still a great tool for writing documents

This is not the Office you grew with.

Traditionally, you'd buy a boxed copy of Office for $100 or more and install it from CDs on your computer. That'd give you Word, Excel, and PowerPoint, along with extra tools like Outlook and Access depending on the version of Office you purchased.

Office 365 changed that all. From $6.99/month, you can get every Office app on all your devices. Or you can use the free Office Online versions of these programs from your browser or the nearly full-featured mobile apps so you can get work done anywhere.

Excel Online
Office Online lets you view and edit your files from any browser

Start a Word document on your PC at home, add some edits from your phone, then print it off from your browser once you get to the office. You can collaborate online in Office Online, editing a document along with a colleague in Word Online or adding comments to an Excel Online spreadsheet that your coworker can check later.

Office's apps each include more features than those in most of the suites in this roundup, with decades of development behind each one. Excel includes an impressive number of functions and data analysis tools, while OneNote is one of the most innovative notes apps with a paper-like layout that lets you write where you want. There are new apps in the suite, too, like the modern presentation tool Sway and Delve, a smart tool to automatically find the files you need.

OneNote
OneNote is a unique take on a notebook app

If you plan to work from a desktop computer or tablet most of the time—and don't want to work from your browser—Microsoft Office is still likely your best option for most office work. Its apps are some of the best ways to make documents and spreadsheets, with enough collaboration features and new apps to make them work in the modern office. Office 365 also includes 1TB of storage in OneDrive so you can backup your files online with the same subscription. And there's an entire ecosystem of plugins and templates from Office's decades on the market that can help you get more from its apps.

  • Office 365 Tools Included: Word processor, spreadsheets, presentations, notes, database builder (on PCs), email, file sync
  • Office 365 Excel Spreadsheet Functions Supported: 465
  • Office 365 Price: Free Office Online web apps; $6.99/month Personal plan for individual use; $9.99/ month Home for up to 5 PCs or Macs; from $10/month Business plan for company use per user

For a deeper look at features and pricing, see our Office 365 review.

See Office 365 integrations on Zapier

Google G Suite (Web, Android, iOS)

Best for collaborating with a team in online documents

Google Docs
Google Docs does perhaps the best job at importing Office files

Microsoft Office might have been first default "office suite" in the enterprise, but it took Google to take it beyond desktops and into the cloud. G Suite—formerly Google Apps—started out as Writely, a simple online writing app from 2005. Google acquired it and piece by piece turned it into the cornerstone of today's best Microsoft Office competitor.

Google Forms
Need to gather data for your documents? Google Forms can do it right from your office suite.

G Suite's individual apps are great on their own—modern tools with everything you need to make documents, spreadsheets, and presentations. The individual features aren't the reason to use them, though.

What makes G Suite great is how it's built for collaboration. You can share your files with anyone—even publicly on the web if you like—and let them all jump in and help craft a masterpiece. You can live-edit with others at the same time or leave comments that Google will email for feedback later (even directly from the inbox—just reply to the email to reply to the document comment). Because it comes with any Google account—and who doesn't have a Gmail account?—G Suite is practically ubiquitous.

Google Sheets
G Suite even includes tools to help you automatically learn from your data

It's getting smarter, too. The new Explore tool in Google Docs and Sheets can find insights from your data, creating charts from your spreadsheets and finding related documents automatically. It can even work while you sleep. Add a Google Form to your Google Sheets spreadsheet and new answers will show up in your sheet automatically, ready the next time you log in. Add some add-ons and integrations to your G Suite account, and your Sheets can crunch numbers on their own.

G Suite is best online. It does have mobile apps, though with far fewer features than the core web apps—you can't add suggested edits or most formatting to a document on mobile, for instance. And G Suite only works offline if you use it in Chrome. But if you mainly work from a computer and are online most of the day, G Suite is one of the best ways to collaborate on files online with your team or anyone who has a Gmail account.

  • G Suite Tools Included: Word processor, spreadsheet, presentations, notes, email, file sync
  • G Suite Sheets Spreadsheet Functions Supported: 351
  • G Suite Price: Free for personal use; from $5/month per user Basic plan for teams

For a deeper look at features and pricing, see our Google Docs review.

See integrations with all the G Suite apps on Zapier

Apple iWork (Web, Mac, iOS)

Best for making stylish files in minutes on an Apple device

Apple Pages
It may not be the best at importing Microsoft Office files, but it is the best at quickly creating beautiful documents

Want to create beautiful documents, spreadsheets, and presentations? Apple iWork apps—Pages, Keynote, and Numbers—are the easiest way to make them, and they're free with Macs and iOS devices. You'll either find them preloaded on your new devices or in the App Store as a free download.

Each includes a number of templates to help you quickly make the files you want, in a simplified interface that hides most of its tools until you need them. You can start out with a template, pull in your own images and graphics, and end up with a print-quality file in minutes. Or, turn your document into a book—Pages lets you export a document as an ePub book that's perfect to publish to an eBook store.

Keynote
Keynote is the app behind Steve Jobs' famous Apple product launches

Numbers is a unique take on a spreadsheet app, acting more like a document than the typical grid-filled sheet you'll find in Excel or Google Sheets. Crunch the numbers you need, then add text and charts around it in the blank document to build a full report around your core table.

Keynote, similarly, is great for more than just your standard slideshow. Its animations are so fluid, it's a popular tool for prototyping new apps and making short animated videos. Or, just use it to make your next meeting a bit more interesting—with the new Keynote Live, you can stream your presentation online right from Keynote.

iWork is best in its native apps on Mac and iOS, though you can also use it online from iCloud.com. That's a great way to share your files with colleagues who don't use iWork or to quickly tweak a presentation from a work computer when you forget your laptop.

  • Apple iWork Tools Included: Word processor, spreadsheet, presentations (notes, mail, and calendar apps also included with iOS and macOS)
  • Apple Numbers Spreadsheet Functions Supported: 266
  • Apple iWork Price: Free for Mac and iOS; free web app with an iCloud account, which comes free with any Apple device

Zoho Workplace (Web, Android, iOS)

Best for 30+ apps in one suite

Zoho Workplace
Create documents in a new take on the traditional word processor

Zoho offers an incredible array of apps, but it all started with their online word processor, Zoho Writer. New apps joined the group year by year, eventually turning into Zoho Workplace—a full office suite online, with dozens of other Zoho apps that you can add on if needed.

Writer continues to be the leading app in the suite, with a new design that rethinks how a word processor should be designed. It keeps nearly all of its features hidden by default for a distraction-free interface. Need to tweak something? Open the left sidebar to find all of the tools a couple taps away in neatly organized toolbars. Bring in Microsoft Office files, and Zoho does an impressive job at retaining most of the original formatting.

Zoho Show
Quickly grab the tool you need from the toolbar or menu

For everything else you need to do, there's a Zoho app to handle it. Its presentation and spreadsheet apps follow a more traditional style, with menus and toolbars mixed so you can work the way you want. And everywhere, collaboration is at the forefront. Each app includes a Zoho Chat box where you can talk to your colleagues and keep the conversation going no matter which Zoho app you're using.

When you need to turn your spreadsheets into an app, or find customer data for your report document, or find your company's finances for a presentation, that and more can be stored away in one of Zoho's many tools. That's the best reason to use this suite—it's all of the software your company needs, tied to an office suite that works from any browser. Plus, it's an affordable suite for small businesses.

  • Zoho Workplace Tools Included: Word processor, spreadsheets, presentations, email, team chat, file sync, websites (with 25+ other Zoho apps available)
  • Zoho Sheet Spreadsheet Functions Supported: 362
  • Zoho Workplace Price: Free for 25 users with 5GB storage; $3/month per user Standard plan for unlimited users and 30GB storage

For a deeper look at features and pricing, see our Zoho Mail review.

See Zoho app integrations on Zapier

Quip (iOS, Android, Mac, Windows, Web)

Best for a new, paper-free approach to office

Quip
Your documents don't stay the same forever, so Quip makes them act more like a wiki

Quip decided to rethink office software. The whole idea of documents is still rooted in paper—in most word processors, you work in a virtual sheet of A4 paper, even though you might not print the finished document. Quip does away with that skeuomorphism.

Just like a web page, your Quip documents go on forever with nary a page break or footer in sight. Write and organize your text with web-style headers. Use standard keyboard shortcuts to format your text—or hover over the left side of a paragraph to turn it into a quote, code block, header, or list. On the right, add new sections to your document—links to other documents, smart dates that remind you when they're due, and mentions to pull others into your document. They're living documents, smart pages with everything you're working on—stuff that could never fit on a printed sheet.

quip
Mix simple spreadsheets into documents, see what changed over time, and chat with your team in one app

Need to crunch numbers? Just insert a spreadsheet block into your document for a smart table that supports standard spreadsheet functions. It's perhaps the easiest way to make a full report—you can write the document and find the data for the report all in one place.

Quip is best when shared with your team. It includes Slack-like team chat rooms where you can discuss ideas and share gifs with your colleagues. Each document has its own tiny chat in the sidebar, where you can track changes and chat with your team about the content.

It's far more basic than the other office suites. You can't select your own typeface or other formatting options—Quip instead includes a half-dozen document templates to style your document. And there's no presentation app, unlike other office suites. But it is a simpler way to put your data to work, without the legacy paper-style features most office suites are still built around.

  • Quip Tools Included: Word processor, spreadsheets, team chat
  • Quip Spreadsheet Functions Supported: 406
  • Quip Price: Free for personal use; $30/month Quip plan for 5 users, plus $12/month per additional user

For a deeper look at features and pricing, see our Quip review.

See Quip integrations on Zapier

LibreOffice (Windows, Mac, Linux, Android)

Best for a free desktop office suite

LibreOffice for Mac
LibreOffice won't win any beauty contests, but it does do the basics for free

The latest version of the storied Microsoft Office competitor OpenOffice.org, LibreOffice is perhaps the best-known free office suite. If you didn't want to spend $100+ on a copy of Microsoft Office, for years it was your only good option. And today, if you want a free office suite on a PC that works without an internet connection, it's still one of the best options.

LibreOffice isn't fancy. It still feels like an older version of Microsoft Office, with endless toolbars and sidebars and buttons, some of which do the same functions as others. It's perhaps the least reliable at making documents look exactly like they would in Office (aside from Quip, but then, Quip has other goals in mind).

But it does work—especially for making new documents, spreadsheets, and presentations. It might take a bit more work to get things to look the way you want, but you can hide any extraneous toolbars or sidebars for just enough customization to fit your workflow. And while it's a bit slow to load and scroll through long documents, you can pinch to zoom, drag-and-drop files, embed files from one app of the suite into another, and everything else you'd expect in a desktop office suite. You can collaborate with document revisions and comments, only you'll need to sync the files on your own via Dropbox or another file sync app—and there's no way to live-edit files together with your team.

Perhaps LibreOffice's best feature is its Base app. This database editor lets you quickly build a form-based interface for new databases or use existing MySQL and other standard databases to build simple apps without coding. It's one of the few alternatives to Microsoft Access. It's also a great way to build simple in-house desktop tools for your team, then scale them up later into standalone apps if you want.

  • LibreOffice Tools Included: Word processor, spreadsheets, presentations, database builder, drawing tool
  • LibreOffice Calc Spreadsheet Functions Supported: 385
  • LibreOffice Price: Free, open-source

What's the Best Office Suite for You?

Work offline on a Mac or PC? Microsoft Office, iWork, and LibreOffice are the best options if you prefer to work from native apps installed on your computer. They include the most features, will make the nicest looking documents, and are designed to work great even without an internet connection. LibreOffice might not feel as polished as the other two suites, but it is free, includes a database app, and is still a great option especially on PCs (as Macs come with iWork for free). Quip and G Suite in Google Chrome can work well offline (with Quip's apps and G Suite's Chrome extensions), though you'll find them frustrating if you need to primarily work offline as their best collaboration features only work with an internet connection.

Work from a phone or tablet? Microsoft Office and iWork are again great options, as their mobile apps include nearly as many features as their desktop software. Quip, though, could be the best option for mobile office work, as its simpler take on documents works even better on mobile and all of its apps include the exact same features. G Suite and Zoho offer mobile apps that work well, though both include far fewer features than their web app counterparts.

Work with a team online? G Suite, Zoho, and Quip are the best options for working from a browser. They're each designed for collaboration first, built for teams to work together online. Microsoft Office 365 then is a great option for working directly from apps or online with Office Online. You can start a document in Word on your PC, have a colleague edit it from Word Online in their browser, and then finish up in Word on your iPad for collaboration from any device.

Don't want to pay for an office suite? Zoho and LibreOffice are the best options. Zoho's free for 25 users, meaning you can easily use it for even mid-sized work teams without paying—and LibreOffice is free for everyone, albeit without online collaboration tools. G Suite is another great option—as long as your team uses personal @gmail.com accounts, you can collaborate with as many people as you want for free. That same trick works with Microsoft Office, too—use free @outlook.com personal accounts, and you can collaborate in Office Online for free. And if you have a Mac, iPhone, or iPad, iWork is hard to pass up as it comes free with your device.


Microsoft Office isn't the only office suite today—but its new Office 365 plans are a great value, and its apps are still the most full-featured office tools. Apple's iWork apps help you easily create beautiful documents and presentations, while G Suite and Zoho both offer surprisingly full-featured tools from your browser. LibreOffice still offers a great set of tools for the low price of free. And Quip makes it so easy to create documents and spreadsheets, you'll wonder why you used to spend so much time tweaking fonts and footers.

One might not be the best for you. In fact, the best option is often to use the best features from multiple tools. On the Zapier team, we collaborate on documents and spreadsheets in G Suite, use Quip for shared internal notes as a wiki of sorts, and still keep Microsoft Office and iWork around when we need more robust features or template options.

Which works best for you? We'd love to hear which office suite you rely on—and why—in the comments below.

Find Alternate Apps for Your Needs

Don't want a full office suite? Perhaps you'd like a new way to make presentations, a less distracting writing app, or a spreadsheet tool that's not so complicated.

These are the apps for you, with more details on the apps in these office suites along with newer tools to make the files you want:

Header photo via Pexels.



source https://zapier.com/blog/microsoft-office-vs-g-suite/