Excel and Apple Numbers are compatible for basic data exchange, but not fully: Numbers can open Excel files (.xlsx) and Excel can open Numbers files (.numbers) only after conversion, and complex formulas, charts, and formatting often break or change during transfer. This article explains exactly what works, what doesn’t, and how to move data between the two with minimal loss.
Background: Why the Two Apps Differ
Microsoft Excel (part of Microsoft 365) and Apple Numbers (part of iWork, free on Mac, iPhone, and iPad) were built for different audiences. Excel is a full-featured spreadsheet powerhouse with over 450 functions, pivot tables, Power Query, and VBA macros. Numbers is a lighter, design-focused tool that uses a free-form canvas instead of a fixed grid, which makes it easier to create visually appealing tables but harder to match Excel’s calculation depth. Because their file formats are different—Excel uses the Office Open XML standard (.xlsx), while Numbers uses Apple’s proprietary .numbers format—compatibility is a translation problem, not a direct one.
How File Conversion Works
To open an Excel file in Numbers, you simply double-click the .xlsx file on a Mac or use File > Open in Numbers. Numbers converts it automatically. To open a Numbers file in Excel, you must first export it: in Numbers, go to File > Export To > Excel, then choose .xlsx (or the older .xls). Excel will open the exported file. On the web, you can also use iCloud.com to upload a Numbers file and download it as .xlsx, but the conversion happens on Apple’s servers. For bulk conversion, you can use third-party tools like Zamzar or CloudConvert, but be cautious with sensitive data.
What Transfers Cleanly and What Doesn’t
Simple data—numbers, text, dates, and basic formulas like SUM, AVERAGE, and IF—usually survive the trip. Basic formatting like bold, font size, and cell background colors also carry over. However, many Excel features do not translate:
- Pivot tables: Numbers can create pivot tables, but opening an Excel pivot table often loses grouping, filters, and calculated fields.
- Conditional formatting: Rules using icon sets or color scales may be simplified or dropped.
- Charts: Complex Excel charts (like waterfall or sunburst) may appear as static images or be missing entirely.
- Macros (VBA): Numbers does not support VBA at all. Any macro code is discarded, and you’ll need to recreate automation manually or use AppleScript.
- Formulas not in Numbers: Functions like XLOOKUP, FILTER, and SEQUENCE (which require Excel 2021 or 365) have no direct equivalent in Numbers, so they show an error or are replaced with a static value.
- Data validation: Dropdown lists and validation rules often lose their settings.
How to Choose Between Excel and Numbers
Your choice depends on your needs. If you work with heavy data analysis, financial modeling, or collaborate with people who use Excel, stick with Excel. If you need a free, simple tool for personal budgets or creative projects on Apple devices, Numbers is fine. Consider these factors:
- Collaboration: Excel has real-time co-authoring on Windows, Mac, and web; Numbers also supports real-time collaboration on iCloud, but only with other iCloud users.
- Function library: Excel has far more functions, especially for statistics, engineering, and finance.
- Compatibility with other software: Many business tools export to Excel format; few support .numbers directly.
- Cost: Numbers is free on Apple devices; Excel requires a Microsoft 365 subscription (or a one-time purchase of Office 2021).
- Learning curve: Numbers is more intuitive for beginners, but Excel’s grid is more predictable for complex tasks.
Common Problems and How to Fix Them
Here are the most frequent issues users hit when moving between the two apps, with fixes:
- Formulas show #NAME? error: This means a function isn’t recognized. Replace it with an equivalent (e.g., use VLOOKUP instead of XLOOKUP).
- Charts look wrong or are missing: Recreate the chart in the target app using the data, or export as an image from the original.
- Merged cells and column widths: These often shift. After conversion, manually adjust layout.
- Dates become text or shift by a day: Check the system date format (MM/DD/YYYY vs. DD/MM/YYYY) in both apps before converting.
- Pivot tables lose filters: Rebuild the pivot table in the target app—it’s often faster than trying to fix the broken one.
Cost and Platform Considerations
Excel is part of Microsoft 365, which costs $69.99/year for personal use (as of 2025) and includes Word, PowerPoint, and Outlook. A one-time purchase of Office Home & Student 2021 costs $149.99 and includes Excel, but no updates. Numbers is free on any Mac, iPhone, or iPad, and also works on iCloud.com for free. If you only need occasional spreadsheet editing, Numbers is a solid cost-free option. However, if you need advanced features like Power Query or macros, Excel’s cost is justified.
Alternatives to Excel and Numbers
If you need cross-platform compatibility without the hassle, consider Google Sheets. It’s free, runs in a browser, and can open both .xlsx and .numbers files (upload to Google Drive and open with Sheets). It supports most Excel functions and real-time collaboration. Other alternatives include LibreOffice Calc (free, open-source, supports .xlsx well) and Zoho Sheet (free for personal use). For heavy data work, you might also use R or Python with pandas, but those are programming tools, not spreadsheets.
Frequently Asked Questions
Can I edit a .numbers file in Excel directly? No. Excel cannot open .numbers files natively. You must first export the file to .xlsx from Numbers (File > Export To > Excel) or upload it to iCloud and download as .xlsx.
Will my Excel macros work in Numbers? No. Numbers does not support VBA macros. Any macros are stripped during conversion. You can use AppleScript to automate Numbers on a Mac, but it’s a different language and requires rewriting.
Why do my Excel formulas show errors after opening in Numbers? Because Numbers doesn’t have every Excel function. For example, XLOOKUP and FILTER are not available. Replace them with older functions like VLOOKUP or INDEX/MATCH, which both apps support.
Does Numbers support pivot tables? Yes, Numbers has a pivot table feature (Insert > Pivot Table), but it’s less powerful than Excel’s. When you open an Excel pivot table, it may lose custom groupings and calculated fields.
Is there a way to keep formatting perfect when converting? Not perfectly. The best approach is to keep the original file and only convert a copy. For critical documents, manually check the converted file for layout changes, especially merged cells and chart positions.
Can I use Google Sheets as a bridge? Yes. Upload the .xlsx or .numbers file to Google Drive, open it with Google Sheets, then download as the other format. This often preserves more than direct conversion, but complex features still suffer.
Related
- JavaScript String split(): Syntax, Examples, and Tips
- Python r Strings: Raw String Meaning, Rules, and Examples
- Strings in R: Text, Character Vectors, and Examples
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Graphing the Line y = -1: Points, Slope, and ExamplesThe equation y = -1 graphs as a horizontal line one unit below the x-axis. Every point on…
- Excel Redo Shortcut: How to Restore an Undone ActionIn Excel for Microsoft 365 on Windows, press Ctrl+Y to redo an action you just undid. On a…
- Unmerge Cells in Excel: Find the Command and Use ItIn Excel for Microsoft 365 on Windows, select a merged cell, then choose Home > Merge & Center…
- How to Paste Backwards in Excel: Reverse Cell OrderTo paste a list backwards in Excel for Microsoft 365, enter =SORTBY(A2:A6,ROW(A2:A6),-1) in an empty cell, replacing A2:A6…
- Compare Two Documents in Word: Create a RedlineTo compare two documents in Microsoft Word and create a redline, open Word for Microsoft 365 on Windows,…
- Dropdown List in Excel: How to Create and Manage OneTo generate a dropdown list in Excel for Microsoft 365 on Windows, put the choices in cells, select…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.