iWork ’09

Numbers ’09

Finally, data has its day.

With great-looking templates, easy-to-create formulas, and dynamic tables and charts, spreadsheets suddenly make perfect sense.

Watch Numbers Overview Watch Numbers Overview

Finally, data has its day
Create Spreadsheets

Easy from the start

Create perfect spreadsheets in minutes.

Easy Formulas

Formulas for everyone

Surprisingly easy ways to write formulas.

Organize your Data

Intelligent tables

Organize your data and perform calculations.

Impressive Charts

Impressive charts

Make your data instantly compelling.

Numbers screenshot: Application screen with sheets drawer and open document

Easy from the start

Numbers, uncrunched.

Plan a wedding. Save for retirement. Track your workouts. Keep a baby journal. Spreadsheets can help you organize 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 ’09, 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, colors, styles, and borders. With graphics tools, alignment guides, and rulers, spreadsheet-making becomes a surprisingly creative endeavor. 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 analyzing from 30 Apple-designed templates, and you’re already halfway there.

View gallery

Find out how to get started with Numbers

Numbers screenshot: formula tooltip

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 (including more than 90 new ones). Tooltips and built-in help provide clear and concise explanations of each variable. You can even use visual placeholders for variables when you create formulas. The new 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

Numbers screenshot: Tables and charts using the same 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 even share content between tables. WIth intuitive tools, Numbers helps you analyze data. Enter data and change values within the cells and use sliders, checkboxes, 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 organize 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

Numbers screenshot: 3D bar chart comparing values

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 two-axis charts with different value scales. Apply trendlines and error bars. The charts you create in Numbers can be linked to your Pages documents and Keynote presentations.

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

Numbers screenshot: Showing a document looking the same in Numbers and Excel

Share your spreadsheets.

Open and save as Microsoft Excel files. Email your spreadsheets right from Numbers. And share with everyone on the web.

View gallery

Find out how to share your spreadsheets

Compatibility and sharing

It’s the universal language.

Numbers makes it easy to share your spreadsheets with colleagues or friends. You can 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 also export your Numbers spreadsheets as PDF files. Numbers lets you import documents in other common formats as well, including Open Financial Exchange files from Quicken, files from bank or credit card providers, comma-separated-value or tab-delimited files, vCards, and more. Printing spreadsheets in Numbers is surprisingly easy, too. Use the interactive Print view to see how big your spreadsheet will print. Then scale it up or down with a simple slider. With the new email option, send Numbers, Excel, or PDF files right from Numbers using Mac OS X Mail.

Share your work on the web.

If your colleagues need to see your work, but you don't know what format to use, upload your spreadsheet to iWork.com Public Beta1. Reviewers receive a unique iwork.com URL where they can view your spreadsheet, post comments, and download it in Numbers, Excel, or PDF format.       

Back to top

  1. The iWork.com Public Beta is not part of iWork '09. It is a service available to persons age 13 and older. Internet access is required. Additional fees may apply. Terms of service apply. For details, see www.apple.com/legal/iworkcom/en/terms.