Hosted by site sponsor WebMate.






iPad Q&A

Update Published November 19, 2014

All Apple Q&As >> iPad Q&A (Home) | Also see: All iPad Specs

To be notified of new Q&As, sign up for EveryMac.com's bimonthly email list.




Can the iPad be used to type documents? Can it open and save Microsoft Office files? Can it open and save PDF files?

The iPad most certainly can be used to type documents.

Originally, one major point of differentiation between the iPad and the smaller iPod touch and iPhone devices is that the iPad exclusively had compatible productivity software -- a version of the iWork Pages, Numbers, and Keynote applications -- for word processing/basic page layout, spreadsheets, and presentations, respectively.

Although Apple subsequently has released versions of these apps for the iPhone and iPod touch, the small displays make the software much less convenient for more than basic review and quick edits of documents, even with the assorted zoom functionality.

Pages, Numbers, and Keynote originally were available for the iPad for only US$9.99 each, already a bargain compared to most productivity applications on Macs and Windows PCs, but on October 22, 2013, Apple lowered the price to free for those purchasing a new iPad (or for those who had purchased the applications previously).

Onscreen & Physical Keyboard Options

In addition to productivity software and a "soft" onscreen keyboard, the iPad is compatible with the Apple Wireless Keyboard (US$69), the discontinued Apple Keyboard Dock Accessory, and a vast assortment of third-party wireless keyboards, many of which more-or-less convert the iPad into a touch-capable netbook.

The iPhone and iPod touch models also can be used with keyboards, but when combined with the larger display, an external keyboard makes it possible to comfortably compose full documents on the iPad.

However, it also is worth noting that because iOS software commonly is designed for use without a keyboard, some apps may be awkward or "clunky" when used with a keyboard and allow some actions from the keyboard whereas others will require touching the screen. Those used to typing on a Mac and using lots of key commands may be disappointed by the iPad experience.

Official Microsoft Office for iPad

On March 27, 2014, after literally years of rumors, Microsoft released Office for the iPad. For those who use Microsoft Office on a Mac or Windows PC, and assuming full crossplatform compatibility and advanced features are important, the official software is the best choice by far.

Originally, Office for iPad was free to download, but the free version only allowed you to read Word, Excel, and PowerPoint files. Editing files or creating new ones required an Office 365 subscription. However, on November 6, 2014, Microsoft relaxed this requirement and made basic editing free for consumers, with more advanced business features still requiring Office 365.

Microsoft explains further:

Starting today (November 6, 2014), people can create and edit Office content on iPhones, iPads, and soon, Android tablets using Office apps without an Office 365 subscription.

Of course Office 365 subscribers will continue to benefit from the full Office experience across devices with advanced editing and collaboration capabilities, unlimited OneDrive storage, Dropbox integration and a number of other benefits.

By default, documents that you edit or create on the iPad are stored in Microsoft's OneDrive "cloud," but they also can be stored on the device itself.

In addition to helpful reviews from Macworld and ArsTechnica, you also may find this demo video from Microsoft worthwhile to see the software in action:

If you do not want to go the official Microsoft route, either due to cost, "old school" ideological objection to the company from its anti-trust days, a preference for another cloud storage service (like Apple's own iCloud, DropBox, or site sponsor WebMate), security concerns involving cloud storage altogether, or any other reason, it is possible to use Apple's own software or convert documents, although the methods are not nearly as ideal as Microsoft's formal option.

iWork Microsoft Office Compatibility

Without Microsoft Office for iPad installed, but with Apple's iWork apps installed, the iPad is capable of opening Pages, Numbers, and Keynote documents created on a Mac; opening Word, Excel, and PowerPoint documents created on a Mac or Windows PC; and opening PDF files and saving files in PDF format as well.

Originally only Pages supported saving documents in Word format, but Numbers and Keynote did not support saving documents in Excel or PowerPoint, respectively. Thankfully, this subsequently has changed and Numbers and Keynote now both can save files in the equivalent Microsoft format.

Apple's original marketing copy officially heralded that the Pages, Numbers, and Keynote applications "work well with others" and documents could "easily" be shared.

More recent Apple marketing copy shamelessly declares that these apps "now work even better with Microsoft Word, Excel and PowerPoint. So you can take a Microsoft Office document from your Mac or PC, import it to your iOS device, and keep the workflow flowing."

This marketing copy is followed by extensive lists of features that are supported, "partially" supported, and not supported for Word to Pages, Excel to Numbers, and PowerPoint to Keynote.

Always optimistic marketing copy aside, the straightforward lists of exactly what works, may work, and does not work definitely is welcomed and should help users have realistic expectations.

Microsoft Office Format Conversion Experiences & Other Translation Options

Based on hands-on use, feedback from EveryiPad.com readers, and postings across the Internet, attempting to convert between Microsoft Office formats and the Apple iWork equivalent on the iPad has been mixed thus far.

Likewise, from the extensive number of "partially" supported and unsupported features when converting between formats, it is clear that experiences still will continue to vary significantly.

Although the professional opinions below are referring to the original release of the iWork suite for iPad, they still do an excellent job demonstrating the range of possible translation outcomes using the official Apple solutions.

In his document translation test, PCMag's Tim Gideon reported:

When I downloaded the template for the Word document I am currently using for this review, the iPad automatically asked if I wanted to convert it to a Pages doc. When I did, I was immediately using a doc that looked exactly like my original Word document. Sending attachments is just as easy, as Pages can also convert your document back to Word when you're finished editing -- and you can send via the Email app by just clicking an arrow beneath your document's icon (you don't need to be in Mail).

The WSJ's Walt Mossberg -- likely using a more complex document -- was not as lucky:

I even got some light work done in the optional iPad word processor, called Pages, which is part of a [then US]$30 suite that also includes a spreadsheet and presentation program. [The software now is free].
This is a serious content creation app that should help the iPad compete with laptops and can import Microsoft Office files. However, only the word processor exports to Microsoft's formats, and not always accurately [the spreadsheet and presentation apps now export to Microsoft's formats, too]. In one case, the exported Word file had misaligned text. When I then tried exporting the document as a PDF file, it was unreadable.

In addition to the official solutions, two other translation apps include Documents To Go from DataViz, which has been providing Mac format translation software for decades, and newcomer QuickOffice, which now is owned by Google.

Official iWork Mac-iPad Crossplatform Compatibility

Just like Walt Mossberg noted when converting an iWork document created on the iPad to Word and PDF, individual users also have reported problems when opening iWork files on an iPad when those files were created on a Mac.

Apple's own support site has posted documents that quietly acknowledge a number of specific formatting changes that will occur when importing a Mac version of a document created with the iWork '09 versions of Pages, Numbers, or Keynote into its iPad equivalent.

More recently, Apple released newer "dumbed down" versions of Pages, Numbers, and Keynote in an effort to bring more parity between the Mac and iOS versions. Although this may have been well meaning -- the backlash from consumers was swift and substantial -- and Apple promised to bring back at least some of the features removed or broken by the new release. Since then, some features have been added back, but the software remains a work in progress.

When using any version of Pages, Numbers, or Keynote for the Mac, changes typically are more minor than those converting between Microsoft applications and their Apple equivalent, but some of these changes still are quite significant. For example, in '09 Pages, "documents using page layout are converted to word processing with text wrap" and in '09 Keynote, "comments are not imported."

Depending on the complexity of the document, converting a document using a page layout to something so much simpler could completely destroy it or at least require substantial time to fix it. Likewise, removing the comments in a presentation could range from frustrating to devastating if you were planning to review them prior to your presentation and only then discovered that they were gone.

iWork Mac-iPad Compatibility Real-World Experiences

More recent versions of the iWork apps for the iPad are more compatible with more Mac versions than earlier releases.

As Apple makes the applications for both systems, and the company no doubt wants to encourage sales of both Macs and iPads -- or at least encourage migration from the Mac to the iPad -- one certainly would hope that compatibility will continue to improve as long as Apple views Mac compatibility as important for iWork. It certainly appears that the company continues to work on this goal.

Compatibility of the original version definitely was overstated, as the below journalists note.

Kenn Marks, writing for the well-respected O'Grady's PowerPage, cautioned:

If you are planning on buying an iPad to be a portable editing device for your iWork content -- think twice. The Apple Discussion boards are all aflutter with teachers and professors who hoped they could leave their laptops in the office and only take their new iPads to the lecture hall. This is not the case. Although Apple has branded the programs the same as the versions you can buy for your Mac, this is where the similarity ends. It's like using Google Translation to convert a foreign web site into your language of choice, but worse. The two programs I was interested in were Pages and Keynote and they both corrupt files on import (once you can get them in -- that's another article). Formatting is lost in Pages so formulas and footnotes disappear in Keynote transitions and builds go away. It is not as if they are temporarily suspended while on the iPad they are gone so when and if you save back to your Mac they are no longer there.

In a ZDNet blog posting, Adrian Kingsley-Hughes summarized his opinion regarding the issue:

The problem here is that Apple is attempting to blur the lines between the desktop/notebook ecosystem and the iPad by releasing the iWork apps for the iPad, but the company is being disingenuous in obfuscating the limitations of the mobile app, especially when those limitations can actually cause irrevocable changes to those documents.

Thankfully, this previously permanent file change issue has been rectified. You now will be "prompted whether you would like to open the original version or to create a copy, and changes made to the content or document layout are listed for your review."

Needless to say, not permanently modifying a translated document, particularly if translated poorly, is a major improvement.

Anyone interested in using the iPad for document creation -- and not willing to just use Microsoft's official software -- would be wise to create documents directly on the iPad or convert a copy of complex documents to a stable format like PDF after creation on a Mac or Windows PC before sending them to the iPad for display. As always, keep a backup of a file before attempting to convert between any formats.

The more powerful UXWrite app also supports more complex documents than Pages and can save documents in Microsoft Word (DOCX), Open Document Format (ODT), LaTeX (TEX), HTML5, and PDF. It may be of interest, too.

iPad Document Preparation Conclusion

When combined with an external keyboard, preparing full documents, spreadsheets, and presentations on the iPad is quite feasible.

If you need to prepare documents for online use or print as well as prepare and even display presentations -- and you don't need a notebook computer for more "heavy lifting" tasks -- it is entirely possible that the iPad could meet all of your mobile computing needs.

With the official Microsoft Office for iPad software, when combined with an Office 365 subscription (and a physical keyboard), it is simple to read, edit, and create Word documents, Excel spreadsheets, and PowerPoint presentations, generally even in a collaborative environment (where documents will be sent back and forth between multiple parties for revision).

With Apple's own iWork suite -- Pages, Numbers, and Keynote -- it also is entirely possible to create full documents, but these apps are best suited for single party use (or collaboration with others who also use these apps for the iPad) rather than those who use Microsoft Office on other platforms. Translation efforts are improving, but as they always have been since the dawn of time, work best for simple documents.


Permalink | Report an Error/Typo | Sign Up for Site Update Notices




<< iPad Q&A (Main) | All Apple Q&As




Established in 1996, EveryMac.com has been created by experts with decades of experience with Apple hardware. EveryMac.com includes, and always has included, original research incorporating detailed, hands-on inspection of packaging, computers, and devices as well as extensive real-world use. All information is provided in good faith, but no website or person is perfect. Accordingly, EveryMac.com is provided "as is" without warranty of any kind whatsoever. EveryMac.com, and the authors thereof, shall not be held responsible or liable, under any circumstances, for any damages resulting from the use or inability to use the information within. For complete disclaimer and copyright information please read and understand the Terms of Use and the Privacy Policy before using EveryMac.com. Copying, scraping, or use of any content without expressed permission is not allowed, although links to any page are welcomed and appreciated.