Numbers 4 for iOS review: Better tools for importing, sorting, and viewing organized data Credit: Apple

Numbers 4 for iOS review: Better tools for importing, sorting, and viewing organized data

numbers4 ios detailed import IDG

Numbers handles imports of large amounts of data and ably works with large spreadsheets.

Apple views Numbers for iOS as a tool for visualizing and presenting data, rather than as a workhorse spreadsheet app. But the latest update offers improvements on both sides of that equation. While not piling on features, Apple has brought the iOS version more in line with the Mac version, as well as harmonizing features with Pages (Mac and iOS) and Keynote (Mac and iOS) for consistency. This kind of parity and consistency means less frustration when moving among apps and between platforms.

Numbers 4: What's new

Numbers 4 for iOS adds only two real flagship changes, although the importance of one of them is buried. The company promotes the addition for drawing using an Apple Pencil or your finger on iPads that Pencil. Because Numbers sheets can be quite elaborate and used for presentation purposes, I can understand adding drawing options, which are now found in all the iOS productivity apps—though they make more sense in Pages and Keynote.

But the second flagship addition is in a short bullet point in the “what’s new” list: “Improved, customizable import of CSV and text data, with support for custom delimiters and fixed width files.” For people trying to use Numbers in more powerful and sophisticated ways, despite the many ways in which it falls short of Microsoft Excel and Google Sheets, this is a big one.

When exporting data from a database or a website, you often have the option to have it dumped in a field-based format, so you can import it into another database, into another service’s API, or use it with a spreadsheet app. CSV (comma-separated values) and text formats are common, but have a lot of variations. Until now, if what you were trying to import into Numbers didn’t fit Apple’s notions of parsing that data, you had to use another piece of software—like BBEdit or a script—to preprocess your export and massage it to Numbers’ needs.

numbers4 ios import settings IDG

An new Import Settings option lets you customize and massage imports, requiring less preprocessing and other work.

Instead, you can now select a CSV-formatted or fixed-width text file by browsing to it via the Spreadsheets view, and then tap an Adjust Settings button that appears at upper right. This opens an Import Settings sheet that gives you a fair amount of control to customize the CSV or text details. (This button appears very briefly: the moment you engage with the spreadsheet on any other behavior, it autosaves as a Numbers file, and the only way to get Adjust Settings back is to re-open the original text file.)

For parity with previous versions of Numbers for Mac, Apple now offers conditional cell formatting, which lets you create style rules (like italic, a background fill, or type color) based on evaluating the values in a cell. It also brings in sorting and filtering options previously in the Mac version, allowing you to chain together a series of sorts to produce a more sophisticated ordered results, and add multiple filters to create a kind of summary report of data instead of viewing everything in a sheet.

numbers4 ios conditional cell short IDG

Numbers for iOS now supports conditional cell formatting, which brings it into parity with the macOS release.

As with updates to the other Mac and iOS apps, Numbers gets donut charts, new insertable shapes that can be edited, and support for collaborative editing via the third-party Box document-sharing service.

Though seemingly a little out of place, you can also insert an image gallery into a Numbers sheet, just as in Pages or Keynote, although you can only move through these images within a Numbers document; there’s no way to export it for interactivity.

Bottom line

Numbers for iOS now matches the macOS version in most important ways, making it a much better complement and standalone app. It still has a long way to go to meet features in competing iOS and Web app spreadsheets, but as a baseline for most people, Numbers now encompasses more people’s needs for importing, sorting, and viewing organized data.

IDG Insider

PREVIOUS ARTICLE

«AMD's Radeon RX 500X graphics cards are just RX 500-series GPUs with a new name

NEXT ARTICLE

HP debuts Pavilion Gaming Laptops with many choices for mainstream gamers»
author_image
IDG Connect

IDG Connect tackles the tech stories that matter to you

Add Your Comment

Most Recent Comments

Our Case Studies

IDG Connect delivers full creative solutions to meet all your demand generatlon needs. These cover the full scope of options, from customized content and lead delivery through to fully integrated campaigns.

images

Our Marketing Research

Our in-house analyst and editorial team create a range of insights for the global marketing community. These look at IT buying preferences, the latest soclal media trends and other zeitgeist topics.

images

Poll

Should the government regulate Artificial Intelligence?