iWork

Numbers '09

Finally, data has its day.

With great-looking templates, easy-to-create formulas, and dynamic tables and charts, spreadsheets in Numbers make perfect sense. And on the MacBook Pro with Retina display, data is infinitely more impressive.

Watch Numbers
Overview

iCloud. Your spreadsheets everywhere.

All your spreadsheets. On all your devices.

With iCloud, you can create spreadsheets in Numbers on your Mac and access them on your iPad, iPhone and iPod touch. And vice versa. You can edit them from anywhere — on any device you use. Changes you make to a spreadsheet on one device automatically happen on all your devices. So you always have the latest version of your work, and your spreadsheets all add up to easy. Learn more about iCloud

Easy from the start.

Numbers, uncrunched.

Plan a wedding. Save for retirement. Track your workouts. Keep a baby journal. Spreadsheets can help you organise and plan, and great-looking Apple-designed templates will help you get started. With the Template Chooser, you can preview over 30 templates to use for home, work and school. Tables are already made. Formulas have been figured out. Fonts are in place. They’re all ready to go. Just find something you like and make it your own.

In Numbers, spreadsheets are built on a flexible, free-form canvas. So you can move tables, charts, graphics and text anywhere you want on the page. As tables resize, objects automatically adjust to fit around them. Create as many tables as you want. Change fonts, sizes, colours, styles and borders. With graphics tools, alignment guides and rulers, spreadsheet-making becomes a surprisingly creative endeavour. And suddenly, spreadsheets make more sense.

The Media Browser adds some excitement to your spreadsheet. With a click, you can access your photos from iPhoto, your movies and your video. The Sheet Navigator lists every table, chart and sheet in your spreadsheet so you can quickly jump to any part of your project and make changes.

Choose a template.

Start planning, tracking and analysing from 30 Apple-designed templates. You’re already halfway there.

View gallery

Find out how to get started with Numbers

Formulas for everyone.

It all adds up beautifully.

Creating formulas may seem complex, but Numbers makes it uncomplicated. Using the intuitive browser, you can choose from over 250 functions. Tooltips and built-in help provide clear and concise explanations of each variable. The Formula List view shows you every calculation on your spreadsheet at once. And with a few clicks on the toolbar, you can create tables and charts and add images and graphics. Easily find fonts and format text styles in the format bar.

Create formulas and format data.

With over 250 functions and built-in help, writing formulas, formatting data and making sense of it all is easy.

Find out how to work with your data

Intelligent tables.

Brilliance in every cell.

Numbers is a blank canvas for tables. You can create as many as you want and resize them as needed. The layout of each table is independent, so whatever you do to one table won’t affect the others. Move tables anywhere — even to a different sheet — and the calculations remain intact. You can also share content between tables. With intuitive tools, Numbers helps you analyse data. Enter data and change values within the cells, and use sliders, tickboxes, steppers and pop-up lists to explore the results. With every change, formulas and charts instantly update and give you a new data scenario.

When there’s almost too much data to decipher, Numbers lets you create categories based on information from any column. It automatically generates a summary row for each category. By using just the summary row, you can collapse, expand and rearrange categories to organise your data any way you want. The new Reorganize button in the toolbar lets you filter by category, and gives you other advanced sorting and filtering options.

Create and edit tables.

Numbers lets you create multiple, resizable tables. You can move them anywhere on a sheet without affecting calculations.

Find out how to use tables in Numbers

Impressive charts.

Off-the-charts charts.

Transform your data into compelling 2D or 3D bar, line, area or pie charts. Combine line, column and area series in a single mixed chart. Create 2-axis charts with different value scales. Even apply trendlines and error bars. The charts you create in Numbers can be linked to your Pages documents and Keynote presentations, so you can easily keep all your documents up to date.

Show every detail.

Create 2-axis charts with different value scales. And mix line, column and area series in a single chart.

View gallery

Find out how to create and edit charts

Compatibility and sharing.

It’s the universal language.

Numbers makes it easy to share your spreadsheets with colleagues and friends. Send Numbers, Excel or PDF files straight from Numbers using OS X Mail. You can also open Microsoft Excel files in Numbers or save your Numbers spreadsheets as Excel files. With powerful graphics and formatting tools, it’s easy to make Excel spreadsheets look great in Numbers. You can even export your Numbers spreadsheets as PDF files. Numbers lets you import documents in other common formats as well, including comma-separated-value or tab-delimited files, Open Financial Exchange files from Quicken, files from bank or credit card providers, vCards and more. Printing spreadsheets in Numbers is surprisingly simple too. Use the interactive Print view to see how big your spreadsheet will print. Then scale it up or down with a slider. Learn more about Numbers compatibility

Back to top