Features available
with Numbers.

Numbers does the work for you. So you can visualise data like never before.

New

Turn handwriting into text. Magically.

With Scribble for iPadOS and Apple Pencil, your handwritten numbers and data will automatically be converted to typed text. Jot down a formula or scribble a date and see it turn into text quickly and easily. Plus, data detectors now work with handwritten text to recognise phone numbers, dates and addresses.

New

Forms. Re-imagined.

With newly redesigned forms, it’s never been easier to create and customise a form. Simply provide input to a single row in Numbers for iPadOS by adding a form to any table or using the new Basic form template.

Play web videos right there in your spreadsheets.

Add a YouTube or Vimeo video to explain your data, then play it right there in Numbers, without the need to open a web browser. Simply add a link, then play your web video inside your spreadsheet.

Powerful new RegEx features.

Match text flawlessly with RegEx functions. Easily manipulate text, match patterns in your data and create formulas that are even more flexible.

XLOOKUP comes to Numbers.

With XLOOKUP, you can find values in columns and rows, or look for exact, approximate or partial matches. Plus, this new function makes Numbers even more compatible with Microsoft Excel.

Other Key Features

Audio

Easily record, edit and play audio directly in a spreadsheet.

Captions and titles stick with objects

Easily add text to tables, data, images and videos. Your words will automatically stay with objects — if and when you move them.

Colour, gradients and images

Apply a colour, gradient or image to the background of any sheet, to your text or to any shape.

Customised templates

Create templates to use as starting points for new spreadsheets, and access them on any device using iCloud.

Dark Mode

Enable Dark Mode to give Numbers a dramatic dark look and emphasise your content.

Export

Export to other formats, including Microsoft Excel, CSV and TSV.

Gorgeous charts

From columns to doughnut charts, there are many ways to display your data. You can create an audio representation of your chart using VoiceOver on iOS and iPadOS.

iCloud Drive folder sharing

Add a Numbers spreadsheet to a shared iCloud Drive folder and automatically start collaborating.

Maths equations

Add elegance to your mathematical equations using LaTeX or MathML notation.

Microsoft Excel compatibility

Import and export Microsoft Excel spreadsheets, with support for up to 1 million rows and 1,000 columns per table.

Offline collaboration

Edit shared spreadsheets while offline and your changes will automatically upload when your account’s online again.

Powerful RegEx functions

Match patterns in your data, easily manipulate text and create formulas that are even more flexible.

Reading Mode

Scroll through your spreadsheet, zoom in and out, and interact with it — without accidentally changing your data.

Shapes library

Choose from more than 700 Apple-designed shapes. Then change the colour and size, add text, and even create and save your own shapes.

Smart Categories

Use Smart Categories to quickly organise and summarise tables, and gain new insights. Group your data based on unique values and date ranges, including day of the week, day, week, month, quarter and year. You can instantly show count, subtotal, average, maximum and minimum values for columns in each group, and then create charts of your summarised data.

Trackpad support on iPad

Use Numbers with Magic Keyboard, Magic Mouse or Magic Trackpad for a new way to work with your documents.

Worksheet links

Jump to other sheets in your Numbers spreadsheet by creating text links.