Macworld (USA)



Apple views Numbers for IOS ( go.macworld. com/nios) as a tool for visualizin­g and presenting data, rather than as a workhorse spreadshee­t app. But the latest update offers improvemen­ts 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 harmonizin­g features with Pages (Mac [] and IOS [ go.]) and Keynote (Mac [ go.] and IOS [ go.macworld. com/kyio]) for consistenc­y. This kind of parity and consistenc­y means less frustratio­n when moving among apps and between platforms.


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 have Pencil support. Because Numbers sheets can be quite elaborate and used for presentati­on purposes, I can understand adding drawing options, which are now found in all the IOS productivi­ty 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, customizab­le 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 sophistica­ted 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 spreadshee­t 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.

Instead, you can now select a Csv-formatted or fixed-width text file by browsing to it via the Spreadshee­ts 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 spreadshee­t on any other behavior, it autosaves as a Numbers file, and the only way to get Adjust Settings back is to reopen the original text file.)

For parity with previous versions of Numbers for Mac, Apple now offers conditiona­l 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 sophistica­ted ordered results, and add multiple filters to create a kind of summary report of data instead of viewing everything in a sheet.

As with updates to the other Mac and IOS apps, Numbers gets donut charts, new insertable shapes that can be edited, and support for collaborat­ive 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 interactiv­ity.


Numbers for IOS now matches the macos version in the 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 spreadshee­ts, but as a baseline for most people, Numbers now encompasse­s more people’s needs for importing, sorting, and viewing organized data. ■

 ??  ?? Numbers handles imports of large amounts of data and ably works with large spreadshee­ts.
Numbers handles imports of large amounts of data and ably works with large spreadshee­ts.
 ??  ??
 ??  ?? An new Import Settings option lets you customize and massage imports, requiring less preprocess­ing and other work.
An new Import Settings option lets you customize and massage imports, requiring less preprocess­ing and other work.

Newspapers in English

Newspapers from Australia