Looking to view and edit Word, Excel & Powerpoint documents on your iPad and iPhone? Here’s how to get Microsoft Office on your phone and tablet
When Microsoft first unveiled versions of its Office apps for Mac and iOS devices, these apps were quite limited, with the iPad version offering some editing features, but only to Office 365 subscribers, and the iPhone version read-only. But these days iDevice users can access and edit Word, Excel and PowerPoint documents on their phones and tablets without Office 365.
Read on for more information about how to get Office apps on your iPhone and iPad for free, and how to make the most of their features. For related advice, see our Office for Mac buying guide, as well as Which is the best iPad spreadsheet app?
How to get Microsoft Office for free
The Microsoft Office apps are free to download from the App Store – Word, Excel, PowerPoint and Outlook – to any iPhone or iPad user running iOS 10 or later. (If you run a search rather than following the links above, make sure you get the versions with Microsoft Corporation listed as the developer.)
You can use edit and view documents and spreadsheets in these apps for free, but to do so you will need a Microsoft ID.
After you’ve downloaded the app you will see a screen asking you to log into Office 365. If you haven’t got an Office 365 account, you can create a Microsoft ID and use that. The form isn’t overly complicated, although Microsoft does require a birth date and telephone number. Don’t worry, you won’t be signed up to Office 365 and you can opt out of receiving marketing material.
You will need to register for an account if you want to be able to edit documents. If all you want to do is read documents you can just tap Sign In Later and then View for Free.
Should I buy a subscription to Office 365?
If you sign up you will gain a few additional features in the iOS apps, including advanced change tracking, the removal of limits on the ways you can use paragraph styles, and advanced chart, table, and picture formatting tools.
If you’re planning on using OneDrive for business documents, you will be required to purchase an Office 365 account. Users can also open existing documents stored on their OneDrive or any other SharePoint location.
Click here for full details of the extra features unlocked with a 365 subscription.
Depending on the subscription you might get the Office apps for your Mac too. You also get 60 minutes of free Skype calls each month, and OneDrive cloud storage capacity for each of up to five users.
Given that this is a yearly or monthly subscription, over the next few years you may end up paying more than you would have if you are currently running an ancient version of Office for Mac.
Syncing options for Microsoft Office
Office for iOS integrates with a user’s OneDrive (previously known as SkyDrive) account, so users can create a document in the Office and then revise it on their iPad while commuting. The document will maintain its formatting even if the mobile version doesn’t support that particular feature.
The documents you have stored in OneDrive must be downloaded to your iPad before you can work on them. They are synced dynamically to the Microsoft Cloud at intervals. You can create and save documents on your iPad without saving them to OneDrive – handy if you’re offline. However, it appears that it’s not possible to move documents from OneDrive to your iPad if you want to work offline.
You can collaborate on documents, editing them at the same time as colleagues – you need to tap a share button in the upper left of the toolbar to invite others to access the document. Note that it doesn’t update in real time, though, so you may refresh and find a paragraph you were working on has moved.
Apple has its own office suite, called iWork. iWork is available for free with the purchase of an Apple iPad or iPhone, and it is also a free update to the previous version of iWork if you own them.
You can collaborate on documents, editing them at the same time as colleagues – you need to tap a share button in the upper left of the toolbar to invite others to access the document. Note that it doesn’t update in realtime though, so you may refresh and find a paragraph you were working on has moved.
Word for iPad and iPhone
Excel for iPad and iPhone
Excel for iOS can be used to create spreadsheets, as long as you register for a Microsoft ID. Once you have logged into your account you will have almost all the features that Office 365 subscribers have. Creating, modifying, saving and printing: all worked well in the free version.
There is also Dropbox support, so you don’t need to use Microsoft OneDrive. One you’ve logged in to your Dropbox account, you will see a list of Places you can save and open things. You can then open, modify, and save any spreadsheets in DropBox. We’d like to see iCloud Drive here too.
The features only open to Office 365 users include: customising pivot table styles and layouts (you can’t create pivot tables in Excel for iOS anyway); add custom colours to shapes; insert and edit WordArt; add shadows and reflection styles to pictures; and add or modify chart elements.
Premium features are available with an Office 365 Personal account (one computer, one tablet, one phone) for £5.99/$6.99 per month, or Office 365 Home (up to five of each device type) for £7.99/$9.99 per month. You’ll also get one terabyte of OneDrive storage, which can be used both in Excel and as a general cloud storage drive. Unless you’re creating and editing graphs in Excel for iOS, you’ll probably find that the free version meets your needs.
There is no difference between the iPad and iPhone app – but we have to admit that using Excel on the iPad is a much better experience due to the bigger screen. The iPhone screen really is too small for all but the most basic of editing. We’d use it in an emergency, but if we were crafting a document or making significant edits we’d be reaching for the iPad.
For example, there’s no room for the ribbon on the iPhone’s screen; to call up the ribbon, you have to tap the Edit icon, which opens an edit area that takes up about a third of the screen, and then tap another pop-up to select, for instance, Formulas, and then scroll through the formula browser. On the iPad, the ribbon is always visible, and choosing a ribbon item only loses one line of the display.
As well as creating and editing spreadsheets you can also print. This feature works well and was introduced prior to the November update.
There are still a few things you can’t do in Excel for iOS, you can see and delete comments but not create or edit them; you can’t name cells or ranges, create conditional formatting rules, or enter array formulas. You also can’t insert images from OneDrive (or Dropbox) either, only from the iOS device’s photos. And Excel is a one-thing-at-a-time app – that means if you’re working with two or more spreadsheets, you will have to fully close one to open the other one.
PowerPoint for iPad and iPhone
Just like Word and Excel for iOS, PowerPoint no longer requires a subscription to edit presentations.
There are a few other improvements on the previous version: you can add and edit animations; can crop images; and use a Presenter View; audio and video now play correctly; and you can add video (though not standalone audio) from your iOS device.
If you have an Office 365 subscription you get access to premium features including Presenter View; adding custom colours to shapes; adding and editing WordArt; applying reflections and shadows to graphics; adding and editing chart elements; and adjusting the shading of table cells, rows, and columns.
It’s no match for the desktop version of PowerPoint. For example, you have limited control over transitions; and you can’t create new themes, add SmartArt, or see your slides in Outline view. On an iPad, you can see comments added on a Mac or PC, but not edit them or add new comments; comments are entirely absent on the iPhone.
As with the other apps, Dropbox file storage is an alternative to Microsoft’s own OneDrive.