Excel Practice Test

โ–ถ

You finally finish a quarterly report in Apple Numbers on your Mac โ€” invoices reconciled, formulas humming, charts looking sharp. Then your boss replies: "Can you send this as Excel?" And there you are, staring at a .numbers file and wondering how it'll survive the trip to a Windows colleague who's never touched a Mac in her life.

This conversion happens everywhere. Creative teams build pitch decks and budgets in Numbers because the design tools are cleaner. Finance and ops live in Excel because that's where the macros, pivots, and corporate templates are. The two formats don't speak the same language natively โ€” .numbers is Apple's proprietary container, while .xlsx is the Open XML standard Microsoft has carried since 2007. Sending one to a user of the other without converting is a recipe for "I can't open this file" emails.

Good news: Apple made the conversion fairly painless. Numbers has built-in Export To > Excel right inside the app. iCloud.com offers the same export in a browser, useful when you don't have your Mac handy. And several third-party converters handle bulk jobs or edge cases. This guide walks every method โ€” desktop Numbers, iCloud web export, online tools like CloudConvert and Zamzar, batch automation via Shortcuts, and what to do when formulas or formatting break in transit. Pick whichever matches your situation; bookmark the rest.

Numbers to Excel Conversion at a Glance

.xlsx
the modern Excel format
Numbers
exports to Excel natively
iCloud
web export works on any OS
10 sec
average conversion time

Before converting anything, it helps to know what's actually happening under the hood. A .numbers file is a package โ€” basically a zipped bundle of XML, image assets, and Apple-specific metadata. The compatibility layer Apple ships with Numbers can read and write .xlsx, but it has limits. Numbers-only functions, certain chart types, and a handful of layout features don't have Excel equivalents, so they either degrade or vanish on export.

The reverse is also true. Excel has a few functions Numbers doesn't replicate cleanly โ€” array-spilling LAMBDA tricks, dynamic arrays, some statistical helpers. When you go from Excel back to Numbers, those features may convert to static values rather than live formulas. Knowing this up front saves the "why doesn't my formula work?" panic later.

Format-wise, .xlsx is the modern Excel format introduced in 2007 โ€” every recent Excel version reads and writes it. Older .xls is the legacy binary format from Excel 97 through 2003; only ancient corporate setups still need it. Numbers can export to both, but unless someone specifically asks for .xls, stick with .xlsx โ€” smaller files, better fidelity, broader compatibility.

One last thing worth knowing: Numbers files can hold multiple sheets, like Excel workbooks. On export, each Numbers sheet becomes an Excel worksheet tab. Tables inside Numbers sheets become contiguous data ranges in Excel โ€” Numbers' floating-table model collapses into the row-and-column grid Excel uses. Sometimes that reshuffling causes layout surprises. We'll cover those.

On a Mac, single file? Open in Numbers, File > Export To > Excel. Done in ten seconds, highest fidelity.

No Mac available? Sign in to iCloud.com, open Numbers, click the wrench icon > Download a Copy > Excel.

Windows or Chromebook user? Use iCloud.com if you have an Apple ID, or CloudConvert/Zamzar for one-off conversions.

Twenty or more files? Build a macOS Shortcuts workflow with a Convert Document action. Right-click selected files, run shortcut, walk away.

Sensitive data? Stick with desktop Numbers or iCloud โ€” don't upload to third-party converters.

The simplest path is right inside the Numbers app on your Mac. No third-party tools, no internet connection needed.

Open your spreadsheet in Numbers. Click File in the menu bar at the top of the screen. Hover over Export To. A submenu appears with options for PDF, Excel, CSV, TSV, and Numbers '09. Pick Excel.

A dialog box opens with a few choices. Under File Format, you'll see .xlsx (recommended) and .xls (older). Leave it on .xlsx unless someone specifically asked for the legacy format. There's also a Require password to open checkbox โ€” useful for sensitive documents you're emailing externally.

Click Advanced Options to expand them. You'll see a dropdown for Maintain table compatibility with older versions of Excel. Leave it unchecked for modern recipients; check it only if you know the destination uses Excel 2010 or earlier. Most users won't need to touch this.

Hit Next. A save dialog opens. Pick a destination folder, name the file, click Export. Done. You now have an .xlsx sitting next to your original .numbers file. Send it, share it, open it in Excel โ€” the original Numbers file is untouched, so you can keep working from the source whenever needed.

Conversion Methods Compared

๐Ÿ”ด Numbers Desktop App

File > Export To > Excel inside Numbers on your Mac. Fastest, highest fidelity, no internet required. Choose between .xlsx (recommended) and .xls (legacy). Includes password protection and Excel 2010 compatibility options.

๐ŸŸ  iCloud.com Web Export

Sign in to iCloud.com, open Numbers, click the wrench icon (Tools) > Download a Copy > Excel. Works from any browser on any OS. Requires Apple ID and your file in iCloud Drive.

๐ŸŸก Online Converters

CloudConvert, Zamzar, and Convertio handle .numbers > .xlsx in a browser. Free tiers cover 10-25 conversions/day with 100MB file limits. Best for occasional use when iCloud isn't an option.

๐ŸŸข Batch via Shortcuts

macOS Shortcuts with a Convert Document action processes dozens of files at once. Right-click selected .numbers files in Finder, run your shortcut, get .xlsx outputs in seconds. Older Macs use Automator with AppleScript.

Don't have your Mac with you? iCloud.com runs Numbers right in the browser โ€” including the same export functionality. Works from any computer with internet access, even a Windows or Chromebook machine where Numbers isn't installed locally.

Go to iCloud.com in any browser. Sign in with your Apple ID. From the home dashboard, click Numbers. Your spreadsheets sync via iCloud Drive, so any file saved to iCloud from your Mac appears in the browser instantly.

Open the spreadsheet you want to convert. Click the wrench icon (Tools) in the top toolbar โ€” looks like a small spanner. From the dropdown, pick Download a Copy. A second menu appears with format choices: Numbers, PDF, Excel, CSV.

Click Excel. The browser converts the file and triggers a download. You'll get an .xlsx in your Downloads folder, ready to attach to email or upload anywhere. The whole thing takes about ten seconds for a small spreadsheet, longer for big workbooks with many sheets.

This method's especially handy when you're on a borrowed computer or working from a phone. You can even use Numbers for iCloud on iPad through Safari โ€” same export options, slightly tweaked UI. The only requirement is that your Numbers file lives in iCloud Drive. If it's only on your local Mac, it won't appear in the iCloud.com app.

Third-party online converters fill the gap when you don't have a Mac, don't want to log into iCloud, or need to batch-convert dozens of files. The big names are CloudConvert, Zamzar, and Convertio โ€” all browser-based, all free for occasional use.

The flow is the same for any of them. Visit the site (cloudconvert.com, zamzar.com, convertio.co). You'll see a big upload area or a button labeled something like "Select File" or "Choose Files". Drag your .numbers file in or click to browse. Set the output format to XLSX. Click Convert.

Most services finish small files in under thirty seconds. You download the converted .xlsx from a results page or get a download link via email. CloudConvert has the most polished interface and the best fidelity for complex spreadsheets. Zamzar handles bulk uploads well โ€” up to ten files at once on the free plan. Convertio sits in the middle, with a generous free tier and decent quality.

Free tiers limit file size (usually 100MB) and daily conversions (10โ€“25 per day). Paid plans starting around $9/month lift those caps and add OCR for scanned PDFs, batch automation, and faster servers. For one-off conversions, the free tiers are plenty.

One privacy consideration โ€” your file goes through their servers. For sensitive financial or HR data, stick with the desktop Numbers export or iCloud method. The reputable services delete uploads after 24 hours, but if the data shouldn't leave your network at all, online converters aren't the right tool.

Export Reference Guide

๐Ÿ“‹ Desktop Numbers

The native path on macOS:

  • Open file in Numbers
  • File > Export To > Excel
  • Choose .xlsx (recommended) or .xls (legacy)
  • Optional: set a password
  • Click Advanced Options to enable Excel 2010 compatibility if needed
  • Click Next, pick destination, Export

Original .numbers file stays untouched.

๐Ÿ“‹ iCloud Web

From any browser, any OS:

  • Sign in to iCloud.com
  • Open Numbers from the dashboard
  • Open your spreadsheet
  • Click the wrench icon (Tools) at the top right
  • Pick Download a Copy > Excel
  • File downloads as .xlsx

Requires file to live in iCloud Drive.

๐Ÿ“‹ Online Converters

Browser-based, no software needed:

  • CloudConvert โ€” best polish and fidelity
  • Zamzar โ€” handles bulk uploads well
  • Convertio โ€” generous free tier

Upload your .numbers, pick XLSX, click Convert, download. Free tiers limit to ~25 files/day at 100MB each.

๐Ÿ“‹ Batch Shortcuts

For 10+ files at once on macOS:

  • Open Shortcuts app
  • Create new shortcut with Convert Document action
  • Input: Numbers, Output: Excel
  • Add Save File action
  • Save as Quick Action
  • Right-click selected files > Quick Actions > your shortcut

Older macOS uses Automator with AppleScript.

If you're on Windows and someone sent you a .numbers file, you have a few options. Excel itself won't open .numbers natively โ€” the formats don't speak. But you don't need a Mac to convert.

The easiest path is iCloud.com on Windows. Sign in with the sender's Apple ID (if shared) or have them upload to iCloud Drive and share the file with you. Open in Numbers for iCloud, export to Excel as described above. Costs nothing, works on any browser.

If you don't have Apple ID access, online converters become the main route. Upload to CloudConvert or Zamzar, get back an .xlsx in under a minute. The conversion fidelity is usually solid for simple spreadsheets โ€” totals match, formulas mostly survive, basic formatting carries over. Complex Numbers-only features (sliders, star ratings, certain chart types) may not survive the trip; you'll see them as static text or generic placeholders in the Excel output.

One workaround for repeated .numbers deliveries from a Mac-only colleague: ask them to export to Excel on their end before sending. Saves a step and gives you a higher-fidelity file. Most Mac users are happy to do this once they realize Numbers can write .xlsx directly.

Test Your Excel Skills

Not every Numbers feature survives the export. Apple's compatibility layer is good but not perfect. Here's what to watch for so you don't ship a broken file.

Numbers-only functions. A handful of formulas exist only in Numbers โ€” DURATION, WORKDAY.INTL in some Apple-specific dialects, and certain helper functions for things like checkboxes and ratings. When you export, Numbers replaces these with their last calculated value as a static cell. The cell shows the right number, but the formula's gone. If you need the formula intact for the recipient, manually rewrite using Excel's nearest equivalent before export.

Charts and shapes. Numbers has chart types Excel doesn't share โ€” interactive image galleries, certain 3D arrangements, custom styling. On export, these convert to the closest Excel equivalent, often a generic 2D chart. Visual styling usually survives in spirit but not pixel-perfect. Check critical charts after export and adjust styling in Excel if presentation matters.

Formatting nuances. Numbers' floating tables mean you can place multiple independent tables on one sheet with whitespace between them. Excel doesn't support floating tables โ€” every cell sits in the row-and-column grid. On export, Numbers tables collapse into contiguous Excel ranges, sometimes overlapping each other if they were close in the original. Spread tables across separate Numbers sheets before export to avoid the collision.

Custom cell formats. Apple lets you build cell formats with currency symbols, units (5 km, 12 hours), and custom labels. Excel handles some of these through its own custom format codes, but uncommon ones come across as plain text. Test critical formats after export and rebuild with Excel's Format Cells > Custom if needed.

Images and media. Inline images and shapes typically transfer fine. Embedded videos, audio, and interactive elements don't survive โ€” Excel doesn't natively support them. If your Numbers file relies on media, plan to remove or replace before sending the Excel version.

Step-by-Step: Convert Numbers to Excel on Mac

Open your spreadsheet in the Numbers app
Click File in the menu bar at the top
Hover over Export To and pick Excel from the submenu
Leave File Format on .xlsx (recommended) unless asked for .xls
Optionally check Require password to open for sensitive files
Click Advanced Options to set Excel 2010 compatibility if needed
Click Next, choose destination folder, name the file
Click Export โ€” your .xlsx is ready alongside the .numbers original

Going the other direction is just as common. Someone sends you an .xlsx and you want to open it in Numbers on your Mac or iPad. Numbers handles this natively without any conversion step.

Double-click the .xlsx file in Finder. By default, macOS opens .xlsx in Numbers if Excel isn't installed, or in Excel if it is. To force Numbers, right-click the file, hover over Open With, and pick Numbers. The file opens, Numbers converts on the fly, and you're editing.

The converted file stays as .xlsx on disk โ€” Numbers doesn't auto-save a .numbers copy unless you use File > Save As and pick .numbers as the format. So you can edit and save back to .xlsx for round-trip workflows. Useful when you're collaborating with Excel users but prefer Numbers' interface.

Same caveats apply in reverse โ€” Excel features that don't have Numbers equivalents convert to static values or simplified versions. LAMBDA functions, complex pivot tables, and certain conditional formatting rules degrade. Open the file, review the high-value cells, fix anything that looks wrong. For straightforward spreadsheets, the conversion is invisible.

One file at a time is fine for occasional conversions. When you've got fifty .numbers files to send to a Windows team โ€” like an entire archive of monthly reports โ€” manual export per file is a slog. Automate with macOS Shortcuts.

Open the Shortcuts app on your Mac (Spotlight: "Shortcuts"). Click the + button to create a new shortcut. Search the actions panel for Convert Document. Drag it into the workflow. Set the input to Numbers and the output format to Excel. Add a Save File action below it, pointing to your chosen output folder.

Save the shortcut with a name like "Convert Numbers to Excel". Now you can run it as a Quick Action โ€” select multiple .numbers files in Finder, right-click, hover Quick Actions, pick your shortcut. Every selected file gets converted and saved to the destination folder. Forty files take about a minute on a modern Mac.

For older macOS versions without Shortcuts, use Automator instead. Create a new Automator workflow with the Apply Script to Numbers Documents action. AppleScript drives Numbers to open each file, run File > Export To > Excel, save, close. The script is ~15 lines; plenty of templates exist online. Once built, drop your .numbers files on the Automator app icon and they all convert in sequence.

For really large batches โ€” hundreds or thousands of files โ€” the Shortcuts/Automator approach gets sluggish because Numbers opens each file fully before exporting. Consider iCloud.com batch download via API, or use a paid CloudConvert plan that supports bulk uploads. For occasional 20-100 file batches, Shortcuts is the sweet spot.

Numbers Desktop vs iCloud Web Export

Pros

  • Desktop Numbers handles the largest files without browser memory limits
  • Desktop export works offline โ€” no internet required
  • Desktop preserves complex formulas and charts with highest fidelity
  • Desktop offers Advanced Options like Excel 2010 compatibility mode
  • Desktop password protection is built into the export dialog

Cons

  • iCloud web works from any computer, any operating system
  • iCloud doesn't require Numbers to be installed on the local machine
  • iCloud is the only option when you're on a borrowed Windows or Chromebook
  • iCloud auto-syncs the source file so you always export the latest version
  • iCloud works on iPad through Safari with the same export menu

After exporting, always verify the file works on the recipient's end before you send. The fastest sanity check is opening the .xlsx in Excel on the same Mac (if installed) or in Numbers' own preview mode.

Things to test: do formulas calculate? Click a SUM cell โ€” does it show a real number or #NAME? / #VALUE! errors? Are dates correct, not stuck as text? Do charts render with the right data series? Is the layout readable, or did floating tables collide into each other?

If something's broken, the fix is usually a small adjustment in the original Numbers file: rewrite the formula in an Excel-compatible form, move tables to separate sheets, replace exotic chart types with standard bar/line/pie charts, switch custom number formats to standard ones. Re-export and re-test.

For really critical files โ€” investor decks, audited financials, legal exhibits โ€” convert once, then ask the recipient to confirm receipt and content before treating the file as finalized. Five minutes of back-and-forth beats a chain of "the numbers don't match" emails after a board meeting.

Picking the right method takes about ten seconds once you know the patterns. Here's the quick decision tree.

One file, you have a Mac. Just use File > Export To > Excel in Numbers. Fastest, highest fidelity, no internet required.

One file, you're on Windows or Chromebook. Either iCloud.com (if you have Apple ID access) or an online converter like CloudConvert. iCloud is higher fidelity; CloudConvert handles edge cases when iCloud isn't available.

Twenty or more files at once. macOS Shortcuts with a Convert Document action. Set it once, run forever. Or pay for CloudConvert's batch plan if you're not on a Mac.

Sensitive financial or HR data. Stick with Numbers desktop or iCloud โ€” don't upload to third-party online converters where the file lives on someone else's server, even temporarily.

Numbers user receiving Excel. Just double-click. Numbers opens .xlsx directly with no conversion step needed. Save as .numbers if you want a native copy.

Repeated workflow with Excel team. Either always export from Numbers before sending, or save your master file as a .xlsx and edit it in Numbers when needed. The round-trip keeps both sides happy.

Try the Excel Quiz

One real-world walkthrough. You're a marketing manager who built a campaign budget tracker in Numbers on your MacBook. Twelve sheets, dozens of tables, charts for spend-by-channel, a master rollup. Your CFO uses Excel exclusively on Windows and wants the file weekly.

Week one, you go File > Export To > Excel, save as Q4-budget-tracker.xlsx, attach to email. CFO replies: "Three formulas show #NAME? errors and the timeline chart is missing." You open the exported file on your Mac in Excel (or even in Numbers preview), find the broken cells, rewrite the formulas in standard Excel syntax (replace any Numbers-only functions), and check the chart type. Re-export, resend.

Week two onward, you've fixed the master Numbers file to use only Excel-compatible formulas and chart types. Now each weekly export is one menu action, no edits needed. Total time per cycle: 90 seconds. The CFO opens the .xlsx every Monday, drops it in his pivot table workflow, and never knows or cares that you authored in Numbers.

That's the rhythm โ€” convert once, fix any breaks, then standardize. Future exports become muscle memory.

A few final tips that'll save headaches down the road. Save your Numbers original first. Always. Numbers doesn't overwrite the .numbers file on export โ€” it creates a new .xlsx alongside โ€” but if you start editing the .xlsx and forget to update the source, you'll have two diverged files. Keep Numbers as your source of truth; .xlsx is the shipping format.

Use descriptive filenames. Name the export to match the source: budget-q4-2026.numbers exports to budget-q4-2026.xlsx. Adding "-export" or "-for-excel" to the filename is sometimes useful to flag that it's a converted file. Helps when team members are sorting through email attachments months later.

Test with the recipient's Excel version. Excel 2010, 2016, 2019, 365 all read .xlsx, but they differ on what they can render. Conditional formatting that works in Excel 365 may show as plain cells in Excel 2010. If you know the recipient uses an older version, simplify formatting before export.

Keep iCloud Drive turned on. Even if you do desktop conversions, having your Numbers files in iCloud means you can do an emergency export from any browser, on any computer, when you don't have your Mac. Saved several frantic Saturday-morning re-sends for users I know.

Excel Questions and Answers

How do I convert Numbers to Excel on a Mac?

Open the file in the Numbers app. Click File in the menu bar at the top of the screen. Hover over Export To, then pick Excel. In the dialog, leave the format on .xlsx (recommended) unless someone specifically asked for the older .xls. Click Next, choose where to save, and click Export. Your .xlsx file appears alongside the original .numbers file.

Can I convert Numbers to Excel without a Mac?

Yes. Sign in to iCloud.com from any browser using your Apple ID. Click Numbers from the dashboard. Open the spreadsheet. Click the wrench icon (Tools) in the top toolbar and pick Download a Copy > Excel. The file downloads as .xlsx. This works on Windows, Chromebook, Linux, and even iPad. The file just needs to be in iCloud Drive first.

What's the difference between .xlsx and .xls?

.xlsx is the modern Excel format introduced in 2007 โ€” it's an Open XML standard, files are smaller, and every recent version of Excel reads and writes it. .xls is the legacy binary format from Excel 97 through 2003; only very old corporate setups still need it. Always use .xlsx unless someone specifically asks for the legacy format. Numbers exports to both.

Why don't my formulas work after converting Numbers to Excel?

Some Numbers-only functions don't have Excel equivalents. When you export, Numbers replaces them with their last calculated value as a static cell โ€” the number's right, but the formula is gone. Common culprits: DURATION, helpers for checkboxes and star ratings, and certain Apple-specific date functions. Rewrite these in Excel-compatible form before exporting (use standard SUMIF, IF, ROUND, etc.) and the formulas will survive. Test critical cells in Excel after export.

How do I batch convert multiple Numbers files to Excel?

On macOS, use the Shortcuts app. Create a shortcut with a Convert Document action โ€” set the input to Numbers and output to Excel โ€” followed by a Save File action. Save the shortcut as a Quick Action. Now you can select multiple .numbers files in Finder, right-click, hover Quick Actions, pick your shortcut, and all selected files convert at once. Older macOS versions use Automator with an AppleScript to drive Numbers.

Can Excel open a .numbers file directly?

No. Excel doesn't natively read .numbers files โ€” they're Apple's proprietary format. You need to convert first using Numbers, iCloud.com, or a third-party converter. Going the other direction works: Numbers can open .xlsx files directly on Mac and iPad. Just double-click or right-click > Open With > Numbers.

Is it safe to use online Numbers-to-Excel converters?

For non-sensitive data, yes โ€” reputable services like CloudConvert, Zamzar, and Convertio delete uploads after 24 hours and use HTTPS for transfers. For confidential financial, HR, or legal data, stick with desktop Numbers or iCloud.com โ€” keep the file on machines you control. Online converters are convenient but your file briefly lives on someone else's servers, which may not pass internal security policies.

Does converting Numbers to Excel lose formatting?

Most basic formatting survives โ€” colors, borders, fonts, number formats, conditional rules. What can degrade: floating tables (Numbers' independent-table model collapses into Excel's contiguous grid), exotic chart types (some convert to closest Excel equivalent), interactive controls (sliders, ratings become plain cells), custom unit-based number formats, and embedded media (videos, audio don't survive). Spread floating tables across separate sheets, use standard chart types, and remove media before exporting to minimize loss.
โ–ถ Start Quiz