Chapter 4. Documents and Spreadsheets

image with no caption

EVEN BACK IN ITS early, steam-powered days, the Kindle filled students and businesspeople with hope: That it could store and display a personal document collection. Fantasies of a paper-free life took hold. Amazon helped things along with a clever file shuttling system (via email or USB cable) that helped with transfer chores. Problem was those pokey eInk screens. They couldn’t handle much more than basic text. And you certainly couldn’t edit documents on the Kindle—much less create them from scratch. But the Fire’s gorgeous screen and its document-slinging apps have restored hope. Now it’s not only possible to turn your Kindle into a virtual briefcase, it may become part of your everyday routine.

You have three different ways to get the job done. Each has its own set of pros and cons:

  • The Fire’s built-in Docs Library. Amazon chose to give this tool home-screen billing—and with good reason. It’s free, easy to use, and, if all you need to do is tote around and scroll through a PDF or Word file every so often, just right. Load your documents either by email, USB file transfer, or best of all, a nifty Mac- or PC-based utility. Reading works just as it does with Kindle ebooks. If all this sounds good, see the next section for full details.

  • Third-party apps. Need your mobile reading machine to do more? Perhaps you want to view and edit a Word file, tweak that Excel spreadsheet or PowerPoint presentation as you’re heading to the big meeting, or add a new chapter to your Lady Gaga vampire novel. Time to enlist the services of a specialized app. Three of the biggest names in this realm—Documents to Go, Quickoffice Pro, and OfficeSuite—are ready to help. You get all the Docs Library’s uploading options, plus the ability to pull from and save to online storage services like Dropbox and Google Drive. You can even install a computer-based utility to keep the Fire’s files in sync with, say, your laptop. More info on how to make all this happen is on Third-Party Apps.

    image with no caption
  • Web-based tools. There are a number of competitors in this world (Google Drive, Microsoft’s Office 365, Zoho). Each lets you store, compose, and edit Office-like files from just about any web browser…emphasis on “just about.” You can get these guys working on the Fire, but the results ain’t always pretty. Among the problems you’ll encounter are missing menu choices and toolbar buttons (Google Docs) and a crashing web browser (Zoho). Best to wait till these or other developers release apps that show up in Amazon’s Android Appstore.

The Built-in Docs Library

Before getting into details of how to use Fire’s own little library, consider what you might want to store here. A typical collection could include recipes, directions, user manuals, long web articles, free ebooks (downloaded from a site like Project Gutenberg; www.gutenberg.org). Notice a theme here? Everything’s read-only. That is, these are documents you want to peruse but won’t need to edit. The Docs viewer is about just that—looking. No copying text, no emailing files. Except for basic note-making and highlighting, the Docs viewer is an eyes-only, hands-off affair.

image with no caption

Note

If you spot any similarity between how your files look here and the way Kindle ebooks appear on the Fire, it’s because both use much the same internal viewing software.

Adding and Reading Documents

A host of file formats are welcome to this party. From the word processing world, you can open the door for Microsoft Word (.doc and .docx), plain text (.txt), and Rich Text Format (.rtf). Image formats that are okay include the three biggies (JPEG, GIF, and PNG), plus BMP (an old and not very popular option). Ebooks can come dressed in either main Kindle format: MOBI or AZW. Bummer for ebook mavens: EPUB—the most widely used format—is a no-go. You can also send finished web pages (.html or .htm) or, as mentioned earlier, everyone’s favorite universal format: the PDF.

Note

RTF documents, which you can create in Word or any number of other text programs, let you use slightly more complex formatting than plain ol’ text files.

Now that you know who’s allowed in, here’s how to get what you want onto the Fire:

  • By email. Every Fire gets its own email address. Lonely gadget lovers can use it to send their Fire love notes, but most people will want to send actual files. To see your Fire’s unique email address, tap the Docs Library; the address is at the top of the screen. However, no one can send anything to that address without your authorization—not even you. That’s how Amazon protects your Fire from spam, should this dedicated email address get into the wrong hands. To register approved senders, go to Personal Document Settings on Amazon.com’s Manage Your Kindle page (http://amzn.to/kfmm115). Below the Approved Personal Document E-mail List, click “Add a new approved e-mail address.” (You can give the OK to as many senders as you like.)

image with no caption

The Personal Docs Settings page is also where you can change the Fire’s email address. While you’re here, also think about turning on Personal Document Archiving. If you’ve got other Kindle gadgets or apps, doing so enables you to download your emailed documents to those, too.

Once all that’s in place, attach and email your Fire one or more files (up to a max of 25 per email). What you sent should show up (Docs→Cloud) after a few minutes. If you’re getting antsy, pull down the Quick Settings bar (The Home Screen) and hit its Sync button. Some additional restrictions to keep in mind: No individual file can be larger than 50 MB, and you can’t email a file to more than 15 Kindles at a time.

Tip

A cool experimental feature lets you strip out the formatting from a PDF and end up with plain text only. That way, you can search the text and adjust its font size, for example. Type Convert in the subject line of any PDF you send. Converter beware: The results are often messy.

  • From computer to Fire. The next section has the details on shuttling files from one device to the other.

Looking at what’s in your Docs Library is a snap, especially if you’ve ever read a Kindle ebook. All the same gestures (tap the right margin to turn the page, tap and hold text to add a note or highlight, and so on) work here. If you need an introduction—or a refresher—pop back to Notes and Highlighting.

Tip

Got a file in your Docs Library that you want extra quick access to? On the Docs main screen, tap, hold, and touch any item and then pick “Add to Favorites” from the pop-up menu. Now you’ve got a home screen shortcut to this file. From the same menu you can also delete the file from your Fire or email it (Composing a Message).

Transferring Files from Your Computer

Amazon gives you a simple way to get files from your computer to your Kindle. Install Amazon Cloud Drive—a free program for Mac and Windows. This easy-to-use tool lets you whisk any document off your desktop machine or laptop and up onto Amazon’s Cloud Drive (Cloud vs. Device). From there you’re just a tap and a download away from sucking it down onto your Fire.

Note

The same procedure works for moving photos and home videos, so consider bookmarking this section, even if you don’t think you’ll use it to move documents.

You start the process on your computer by heading to www.amazon.com/CloudDrive; click Install Cloud Drive and then follow the simple instructions on the page that appears.

Once Cloud Drive is installed, launch it. In the sign-in window, enter your Amazon.com username and password. A window appears sporting the invitation: “Drag files and folders here.” To view what you just uploaded on the Fire, go to Docs→Cloud and download any files you want. That’s all there is to it.

A few tips and tricks on how to get the most out of this utility:

  • Quick uploads. From anywhere on your computer (on the Desktop or within a folder), Ctrl-click (⌘-click) a file or folder and, from the pop-up menu, choose “Send to”→Amazon Cloud Drive. (On the Mac, you’ll see Services→“Upload to Amazon Cloud Drive”).

  • Menu- and Taskbar shortcuts. On a Mac, you’ll notice a tiny new menulet in the top row of your screen. Pull it down and choose Open Upload Window to launch the drag-and-drop window. Other options in this pull-down menu include a tool for uploading your iPhoto collection, changing the download folder location (for when you want to pull a file in the other direction), and a shortcut to viewing your Cloud Drive in a Web browser. Windows folks get the same options, save for the iPhoto tricks; head to the Taskbar for your Cloud controller.

Tip

Drag any file onto the menulet or Taskbar icon, and it gets sent Cloudward pronto.

image with no caption

Sideloading

Sideloading is what geeks call the process of plugging a Fire into a Mac or PC and then shuttling ebooks, Word files, or PDFs back and forth.

First, you need a cable to connect the two machines. The cable you want is a special flavor of USB: namely, one with a micro B plug. That’s the same one that comes with recent model Kindles and with other gadgets like BlackBerry phones. Don’t mistake this cord with its cousin, the mini B USB, which is almost, but not quite, as tiny.

Note

Amazon apparently didn’t think most folks would want to sideload. In early Kindle models, they didn’t even include the USB cable. If you need to buy a cable, here’s one well-reviewed model:http://amzn.to/kfmm135.

Also, you may need to download a free helper program called Android File Transfer. If you have a Windows PC running the XP operating system, or a Mac of any stripe, you can’t sideload without installing this software. Go to http://kindle.com/support/downloads and step through some quick installation instructions. If you’re running Windows 7 or later, go straight to these steps:

  1. Connect the Fire to a computer. Plug one end of the cable into the Fire and the other into a USB port on your computer. The Fire appears on your desktop (name: KINDLE) or wherever your system displays plugged-in flash or external drives. If you’re using the Android File Transfer utility, a window opens showing the Fire and all its internal folders.

    image with no caption
  2. Move files from your computer to the Fire. On the Fire, the folder you’re heading for is called Documents. (Following these steps to sideload tunes or visual material? Pick the folder that matches your content: Music, Pictures, or Video.) Drag your files from the computer to whichever Fire folder you’ve just opened.

  3. Disconnect the Fire. Unplug the cable from both machines. Power up or wake your Fire as you normally would (Turning the Fire On, Making It Yours) and then head to whichever library holds your newly added items; they’ll be waiting for you in the Device portion of Docs, Music, and so on.

Third-Party Apps

One of the main raps against the Fire is that it’s only good for consuming content. Tasks like reading an ebook, watching a TV show, or browsing email are fine—even fun. But are you really going to use its virtual keyboard to create anything? If you’re like most Fire fans, the answer is probably not. But if you’re a mobile device-loving road warrior, the desire may be there.

To be sure, it’s not the simplest thing in the world to compose long documents using the three tools—Documents to Go, Quickoffice, and OfficeSuite—profiled in this section. First, get yourself a Bluetooth external keyboards and pair it with your Fire as described on Connecting Bluetooth Devices. The onscreen keyboard doesn’t lend itself to tapping out a novel. But if you’ve ever wished to leave your five-pound laptop behind for that day trip or overnight, this fleet of file-editing apps is encouraging news. These three apps can be surprisingly powerful for viewing, editing, sharing, and even creating documents from scratch. Each app may be missing a feature or two, but keep reading, and you’re likely to find one that matches your needs.

All three apps handle most Office 101 skills. In the word processing utilities, you get undo/redo; zoomable views (good for increasing onscreen legibility without changing the text’s font size); bullet and numbered lists; a handful of font choices; and basic styling (italics, bold, paragraph alignment). With spreadsheets, you can create and navigate between multiple worksheets; format cell number style (currency, date, time); pick from a large catalog of ready-to-use functions (AVERAGE, COUNTIF, LOOKUP); and add rows and columns. The PowerPoint stand-ins are the most limited, at least in terms of features shared by all three apps. Every one in the trio lets you view presentations made on a computer, but don’t count on extremely sophisticated formatting. Fancy builds and transitions don’t show up on the Fire.

Opening and emailing files work much the same way in all three apps, too. You can email files to yourself and then, in whichever app you use for that task, tap the message’s Open button and pick the Office-viewing app you want to use to open the attachment. If you transfer a file from your computer to your Fire (as described on Transferring Files from Your Computer), you need only to navigate in the Office-viewing app to whichever folder you stashed your file in. To move files in the other direction—that is, email them off your Fire—simply add an attachment in your email app of choice; a pop-up menu lets you pick the file.

Tip

If you’re using Amazon Cloud Drive to move files onto your Fire, the folder in which these files are stored isn’t the most intuitively named choice in the world. After launching whichever Office app you use, navigate to: Android→Data→com.amazon.zico→files, or use the app’s search tool to hunt for the file by name.

On the other hand, the apps vary somewhat in their willingness to interact with online storage services like Google Drive and Dropbox. So-called Cloud-based offerings like these can be supremely useful for big travelers and those who move between multiple computers, smartphones, and tablets. You never have to worry about where the latest version is—it’s always stored online.

One final similarity worth mentioning: All three apps come in cheap (sometimes free) and expensive versions. The cheap kind gets you the ability to view, but not create or edit, a file. For that, you need to pony up for the more expensive edition.

Documents to Go

Documents to Go’s big advantage is its unique desktop companion software. Install the free utility on a regular computer—Windows-only, alas—and you’re a sync-button push away from mirror-image files on both your Fire and any of your regular computers. But an even bigger draw is how simple and intuitive this app is. Pretty much every icon and menu choice is dead simple to discern and operate. For an app that you may dip into every couple of weeks, not having to pause and figure things out is probably worth the price of admission.

image with no caption

That’s not to say Documents to Go is underpowered. It meets most needs, starting with the ability to create, edit, and view Word, Excel, and PowerPoint files (both the old generation file types—.doc, .xls, .ppt—and the newer editions with an “x” at the end of their file extensions). A PDF reader is also part of the lineup. Other special talents worth noting: In Word you can create and view others’ comments, modify line spacing, create tables, and view word count. You can also tap into any files you’ve stored up in Google Docs—and create new ones on the Fire.

Quickoffice

image with no caption

Quickoffice Pro earns an “A” for “works and plays well with others.” It’s a snap to tap into online file storage services like Google Drive, Dropbox, Box.net, SugarSync—the list goes on. So if you’re into this increasingly popular method of file storage and sharing, you may have found your match. Another, slightly more quirky perk: text recital, which does just what it suggests, using a slightly grating computer voice to read a document aloud.

A powerful find-and-replace tool (in Word and Excel) is a nice helper. Quickoffice’s PowerPoint design skills are also top-notch. (Though, again, reality-check time: No transitions or builds will show up on the small screen.) You get more slide design tools than the other two apps, including ready-to-use page layout templates. You can also add circles, arrows, and lines. One downside: Many of the toolbar icons don’t look much like their underlying tool—and they have no identifying text labels. If you don’t use the app frequently, you may get frustrated relearning the toolbar each time.

OfficeSuite

image with no caption

This app is the best option for Excel jockeys. You get a full complement of chart-creating tools (column, bar, pie, and area) and smoothest-in-class speed for switching between worksheets. PowerPoint’s not too shabby either. Notes are visible if you want ’em, and a Play button lets you put the slides on auto-advance (Quickoffice has this feature, too). If you need to create a slideshow on your Fire, you can pick from 10 templates, each of which include background art. Nothing fancy, but these visuals may make you appear more prepared. Who said you can’t use the Fire as a content-creation machine?

Tip

Need to print straight from your Fire? There’s an awesome, albeit pricey, app that does just that—if you’ve got a WiFi or network-connected printer. Called PrinterShare Mobile Print, it’ll cost you $12.95 but is worth every penny if you’re traveling without a laptop.

Get Kindle Fire HD: The Missing Manual, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.