NUMBERS: Apple Numbers Spreadsheet
Visual data storytelling.
Learn about Apple's unique approach to spreadsheets, focusing on flexible canvases and beautiful data visualization.
The Apple
Spreadsheet.
A .numbers file is a digital sheet made by Apple. It helps you track numbers, make lists, and draw colorful charts. It is built to be simple and beautiful.
The Blank Page Rule
Most spreadsheet tools trap you in a giant, endless grid of small boxes. It can look very scary.
Apple Numbers is different. When you open a .numbers file, you see a blank white page.
You can drop a small table anywhere you want. You can put a picture next to it. You control the page, the page does not control you.
What Can You Put Inside?
Clean Tables
Add rows and columns easily. Make them look neat without fighting the settings.
Bold Charts
Turn boring numbers into bright, easy-to-read graphs and pie charts.
Smart Math
It does the math for you. Just tell it to add up a column, and it gives you the total.
Cool Shapes
Add arrows, stars, and text boxes to explain your numbers to other people.
Mac Computers
The easiest place to build big, detailed files with a mouse and keyboard.
iPad Tablets
You can touch your charts and move them around with your fingers.
iPhone Phones
Great for looking at your lists and making fast changes on the go.
They all share. If you change a number on your phone, it updates on your computer!
Numbers vs. Excel
| Feature | Apple Numbers | Microsoft Excel |
|---|---|---|
| Who makes it? | Apple | Microsoft |
| How it looks | Blank paper, very pretty | Giant grid of boxes |
| Best for... | Normal people, home, small shops | Giant companies, complex math |
| Cost | Free on Apple devices | Usually costs money |
Help! I have a PC, but someone sent me a .numbers file!
Do not panic. You do not need to buy a Mac computer. Just follow these steps:
Go to the Internet
Open your web browser (like Chrome or Edge) and go to iCloud.com.
Sign In
Log in with a free Apple ID. If you do not have one, you can make one for free.
Drag and Drop
Click on the "Numbers" button. Drag the file you received onto the screen. It will open!
What Should You Make With It?
Home Budgets
Track how much money you spend each month. Use a pie chart to see where your money goes.
Event Planning
Make guest lists for parties or weddings. You can add checkboxes to mark who is coming.
Small Business
Create pretty invoices to send to customers. Make simple lists of what items you have in your store.
How to Share with PC Friends
If you make a file on your Mac, your friends with Windows PCs cannot open it easily. You must "Export" it. This means saving it in a different language.
(For friends who use Excel)
(If they only need to look, not edit)
SYSTEM_DATA // QUICK_FACTS
3 Rules for Beginners
-
1Start with a Template.
When you open the app, it gives you pre-made designs for budgets and lists. Use them! It is much easier than starting from nothing.
-
2Press the Equal Sign "=" to do Math.
If you click a box and type the "=" key on your keyboard, the app gets ready to do math for you.
-
3Keep it simple.
Do not try to make it look like a messy Excel sheet. Let the page breathe. Use white space.
Magic Keyboard Buttons
You do not need to click everywhere with your mouse. Use your keyboard to go faster. These are called shortcuts.
Undo Mistakes
Made a mess? Press this to go back one step. It is like a magic eraser.
Copy Things
Select a box and press this. The computer remembers what is inside the box.
Paste Things
After you copy, go to a new box and press this. It puts the copied thing there.
Working With Friends
You do not have to work alone. You can send a link to your friend. When they click the link, they jump right into your file.
You will see their name on the screen. You can watch their cursor move as they type. It is like playing a multiplayer game, but for work.
Fun Buttons You Can Click
Typing numbers over and over is boring. Apple Numbers lets you drop interactive buttons into your boxes.
- Checkboxes: Great for to-do lists.
- Stars: Perfect for rating books or movies.
- Steppers: Click plus (+) or minus (-) to change a number easily.
Printing Without Getting Mad
Have you ever tried to print a spreadsheet, and it prints 50 pages of blank lines? Or cuts your table in half?
Numbers has a "Print View." It draws a thick line showing exactly where the paper ends. You can drag your tables around until they fit perfectly on one page.
Adding Pictures and Videos
A spreadsheet does not have to be just boring text. You can add media to make it look like a real website.
Drag Pictures In
Drop a photo of a receipt next to your budget table.
Web Videos
Paste a video link, and it plays right inside your document!
Going Back In Time
Did you accidentally delete everything and click Save? Do not cry! The app remembers older versions of your file.
You can click "Revert To" in the menu. A timeline will appear. You can look at how your file looked yesterday, or last week, and bring it back to life.
Locking Your Secrets
If you are keeping track of passwords, secret gifts, or money, you do not want anyone else to see it.
You can set a password on your .numbers file. Before the file opens, it will ask for a secret word. If you use an iPhone or Mac, you can even open it using your fingerprint or face scan!
Reading in the Dark
Working late? Staring at a bright white screen can hurt your eyes. Numbers supports Dark Mode.
Where Does The File Live?
When you save your file, it does not just live on your computer. It lives in iCloud. Think of iCloud like an invisible magic box in the sky.
If you lose your phone, your files are safe in the cloud.
It does not fill up your phone's memory. It stays light and fast.
3 Things You Should Never Do
In Excel, you use one big sheet for everything. In Numbers, you should break things up. Make one small table for Income, and a separate small table for Expenses.
If your friend uses a Windows PC, they cannot click a .numbers file. You must save it as a PDF or Excel file first, or they will be very confused!
Because you can move things anywhere, it is easy to accidentally drop a picture on top of your math table. Be careful where you place things!
More in this series
Master more skills with other tutorials from the Spreadsheets series.
Data Engineering
- DB: Generic Database File: The universal data container.
- SQLite: Portable Database: A database in a single file.
- SQL: Structured Query Language: The language of data.
- CSV: Comma-Separated Values: The universal data exchange format.
Spreadsheets
- NUMBERS: Apple Numbers Spreadsheet: Visual data storytelling.
- XLSM: Macro-Enabled Spreadsheet: Excel with automation power.
- ODS: OpenDocument Spreadsheet: The open spreadsheet standard.
- XLS: Legacy Excel Spreadsheet: The foundation of digital spreadsheets.
- XLSX: Modern Excel Spreadsheet: The data powerhouse.
Presentations
- ODP: OpenDocument Presentation: The open standard for slides.
- PPT: Legacy Presentation: The classic slide deck format.
- PPTX: Modern Presentation: The gold standard for slide decks.
Word Processing
- WPS: WPS Office Document: The lightweight contender.
- PAGES: Apple Pages Document: The designer's word processor.
- ODT: OpenDocument Text: The open text standard.
- DOC: Legacy Word Document: The classic document format.
- DOCX: Modern Word Document: The standard for office documents.
- RTF: Rich Text Format: The universal translator.
Digital Publishing
- TEX: LaTeX Document: The mathematician's choice.
- PDF: Portable Document Format: The digital paper standard.
Software Engineering
- TSX: TypeScript XML: The modern web component.
Markdown & Text
- MD: Markdown: The programmer's writer.
- TXT: Plain Text: The simplest file in the world.