Numbers for iPhone

Numbers for iPhone review: Not all is perfect in Numbers-land

Apple Numbers for iPhone
  • Apple Numbers for iPhone
  • Apple Numbers for iPhone
  • Apple Numbers for iPhone
  • Expert Rating

    3.50 / 5

Pros

  • Can export in Excel format
  • In-app help menu works well

Cons

  • Can’t import hide rows/columns or merge cells
  • Not enough screen real estate for proper editing

Bottom Line

Numbers is a solid spreadsheet program for the iPad and iPhone/iPod touch. Depending on the complexity of your spreadsheet needs, the iPhone/iPod touch support may be a key feature to you, or may just be something that’s good to know if you ever have a critical need to edit a worksheet and you’re not carrying your iPad.

Would you buy this?

When I reviewed the initial release of Numbers for iPad in April 2010, I noted that it worked well for creating original spreadsheets, and for working on Numbers-native spreadsheets from your Mac, but that it fell short due to its inability to output files in Excel format. (Though Apple’s app could read such files, it would convert them to Numbers format). That version of Numbers was also available strictly for the iPad, and not the iPhone or iPod touch.

The big news in this Numbers update is the small news—you can now use Numbers on certain iPods and iPhones. While Numbers is a Universal app (one version for all iOS devices), there are a couple of features in Numbers on the iPad that you won’t get to use in Numbers on the iPhone or iPod touch: full-screen mode and landscape view.

On the iPad, you can enter a full-screen mode to get an overview of your data, and run quick summaries of data sets with a simple flick of your finger. You can’t do much more than that, though, so the lack of this feature on the smaller-screened iPhone and iPod touch may not be a major problem for most users.

The lack of landscape mode, though, is more troubling—many worksheets are laid out in a landscape orientation, and viewing a super-wide landscape spreadsheet on an iPhone in portrait mode can entail a lot of finger swiping. I didn’t realize just how often I used this mode in Numbers on the iPad until I flipped my iPhone around for the first time, expecting to see my worksheet flip, too. When it didn’t, I thought I had the iPhone’s orientation locked, but that wasn’t the case. There simply isn’t any support for landscape mode on the iPhone and iPod touch.

One other minor but potentially annoying “feature” in Numbers on the iPhone and iPod touch is that you can only undo and redo changes by shaking your device—in the iPad app, there’s a dedicated button in the toolbar that doesn’t appear when you run the app on smaller iOS devices. When developing a spreadsheet, I use undo and redo a lot, and shaking the phone—over and over again—to accomplish that task gets old really quickly. I found myself longing for the iPad’s dedicated button after only a couple of undo shakes.

While Numbers works just fine on the iPhone 4, my biggest problem with it is that there’s simply not enough screen real estate to work productively. It seemed every time I wanted to do something, I was either scrolling or zooming to make sure I had the right cell selected, or to see the big picture. It’s also very hard to get a sense for how your finished project will look when you’re laying it out one tiny section at a time.

In short, while Numbers runs just great on an iPhone or iPod touch, I wouldn’t want to use it for anything beyond simple spreadsheets or minor edits to larger projects. There’s a reason that serious spreadsheet jockeys usually have monstrous monitors connected to their desktop machines—there’s no such thing as too much screen space when creating large spreadsheet models.

This release of Numbers includes a number of new and/or improved features that make it easier to do what you need to do, and to share what you’ve done with others. The big news for me was that Numbers can now export in Excel format; previously, it could read, but not write, Excel files. This means you can now work on an Excel file on your iDevice, and output it back to that same format, so you can share it with those who use Office instead of Numbers.

You can now create folders in the spreadsheet browser mode. Folders work here exactly as they do in iOS in general—just drag-and-hover one icon over another, and you’ll create a folder. For those with a lot of spreadsheets, this is a welcome addition. Also new since Macworld’s last review is printing via AirPrint printers, though I was unable to test this feature.

Finally, if you’re the type who never reads in-app help, you should break that habit and read Numbers’ in-app help. It contains a lot of usability tips that will help you get the most out of the mobile spreadsheet app. For example, Help reveals how to restrict a drag operation to a straight line. (Hold one finger from one hand on the screen while dragging the object with a finder on your other hand.)

Not all is perfect in Numbers-land, however. Numbers still can’t import hide rows/columns or merge cells, which are two features that many spreadsheets use extensively. In particular, not being able to merge cells (and having merged cells break on import) will cause some layout headaches. You’re also still limited to your iDevice’s relatively meager font collection, and headers/footers and certain features on graphs also won’t survive the transition from the desktop to your iDevice.

Working with files is still more painful than it should be: you’re generally restricted to working with one file at a time (i.e. when copying to/from iTunes), and you can’t open more than one spreadsheet at a time.

Later this year, Numbers (as well as Keynote and Pages) will support Apple’s iCloud service. This should greatly ease the sometimes-tricky document management issues related to working with one file on multiple devices. Instead of winding up with multiple copies of the same file on multiple devices, iCloud integration will allow you to have one copy of the file that’s simply synced to all your devices. Create a spreadsheet on your Mac, close it, and you will then be able to pick up your phone and continue working, right where you left off.

While iCloud integration looks like a win, it’s not clear yet what will happen with iWork.com, Apple’s perpetually-in-beta iWork document sharing service. The features provided by iWork.com aren’t necessarily replicated by iCloud, so I would expect that it will continue to exist, at least in some form.

The potential upside of iCloud support in Numbers is huge, but we’ll have to wait until later this fall to see exactly how well it works, and what becomes of the iWork.com beta program.

Numbers is a solid spreadsheet program for the iPad and iPhone/iPod touch. Depending on the complexity of your spreadsheet needs, the iPhone/iPod touch support may be a key feature to you, or may just be something that’s good to know if you ever have a critical need to edit a worksheet and you’re not carrying your iPad. But the other features in Numbers make the program worth consideration for working with spreadsheets on the go.

Former Macworld senior editor Rob Griffiths is now master of ceremonies at Many Tricks.

Rocket to Success - Your 10 Tips for Smarter ERP System Selection

Join the newsletter!

Error: Please check your email address.
Read more on these topics: Apple, applications, spreadsheets, productivity, software, mobile
Show Comments

Cool Tech

Breitling Superocean Heritage Chronographe 44

Learn more >

SanDisk MicroSDXC™ for Nintendo® Switch™

Learn more >

Toys for Boys

Family Friendly

Panasonic 4K UHD Blu-Ray Player and Full HD Recorder with Netflix - UBT1GL-K

Learn more >

Stocking Stuffer

Razer DeathAdder Expert Ergonomic Gaming Mouse

Learn more >

Christmas Gift Guide

Click for more ›

Most Popular Reviews

Latest News Articles

Resources

PCW Evaluation Team

Walid Mikhael

Brother QL-820NWB Professional Label Printer

It’s easy to set up, it’s compact and quiet when printing and to top if off, the print quality is excellent. This is hands down the best printer I’ve used for printing labels.

Ben Ramsden

Sharp PN-40TC1 Huddle Board

Brainstorming, innovation, problem solving, and negotiation have all become much more productive and valuable if people can easily collaborate in real time with minimal friction.

Sarah Ieroianni

Brother QL-820NWB Professional Label Printer

The print quality also does not disappoint, it’s clear, bold, doesn’t smudge and the text is perfectly sized.

Ratchada Dunn

Sharp PN-40TC1 Huddle Board

The Huddle Board’s built in program; Sharp Touch Viewing software allows us to easily manipulate and edit our documents (jpegs and PDFs) all at the same time on the dashboard.

George Khoury

Sharp PN-40TC1 Huddle Board

The biggest perks for me would be that it comes with easy to use and comprehensive programs that make the collaboration process a whole lot more intuitive and organic

David Coyle

Brother PocketJet PJ-773 A4 Portable Thermal Printer

I rate the printer as a 5 out of 5 stars as it has been able to fit seamlessly into my busy and mobile lifestyle.

Featured Content

Product Launch Showcase

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?