How to Convert Apple Numbers to PDF
Apple Numbers is the spreadsheet application included with every Mac and iOS device. While it handles financial modeling, budgets, inventory tracking, and data analysis well for Apple users, sharing Numbers spreadsheets with people who use Excel, Google Sheets, or any non-Apple software often requires conversion to a universally compatible format. PDF is the ideal choice for sharing the results and visual layout of a spreadsheet without requiring the recipient to have Numbers or any Apple software. Converting Numbers to PDF is particularly valuable for reports, financial summaries, invoices, dashboards, and any spreadsheet where the visual presentation matters and the recipient needs to view — not edit — the data. A Numbers file (.numbers) sent to a Windows user will typically not open; the same content as a PDF opens immediately in any browser or PDF reader. This guide covers all methods for converting Apple Numbers to PDF on Mac, iPhone, and iPad, including how to control which sheets are included, set print areas for clean output, optimize quality settings, and handle common formatting issues that arise during conversion.
Preparing Your Numbers Spreadsheet for PDF Export
The most important step in converting Numbers to PDF happens before the actual export. Numbers spreadsheets often contain raw data, calculations, and presentation elements mixed together. Getting a clean PDF output requires setting up print settings within the Numbers document first. In Numbers on Mac, open the document and go to File > Print. This opens the print dialog which is also the most direct way to see and configure how the spreadsheet will appear in PDF. The Numbers print dialog is more powerful than most users realize. Key settings to configure: The 'Sheets' panel on the left side of the print preview lets you see every sheet in the workbook. Click each sheet to preview it and determine whether it should be included in the export. Check or uncheck the sheet visibility toggle to include or exclude each sheet from the print/PDF output. For each sheet: configure the page size, orientation (portrait vs. landscape for wide tables), and scaling. Numbers has excellent auto-scaling: 'Fit Sheet on One Page,' 'Fit Content Width on One Page,' or custom scale percentage. Wide data tables that would be cut off in portrait orientation look much better in landscape. For financial reports with multiple data sheets plus a summary: create a dedicated 'Print View' sheet that contains only the data and formatting you want in the PDF, then export only that sheet. This prevents raw data, formula-testing areas, or work-in-progress sections from appearing in the shared PDF.
Exporting Numbers to PDF on Mac
Mac offers two primary methods for converting Numbers to PDF, with different trade-offs. Method 1 — File > Export To > PDF (recommended): Go to File > Export To > PDF. In the export dialog, choose image quality (Best, Better, or Smallest) and optionally set a password. Click Next, name the file, choose a save location, and click Export. This method respects all the print settings you configured in the Print dialog and produces a consistent, predictable result. Method 2 — Print to PDF: Press Cmd+P, configure settings in the print dialog, then click the PDF dropdown in the bottom-left and select 'Save as PDF.' This method allows more fine-grained control over page ranges and specific print settings. Choosing between sheets: Both methods export all visible (not hidden) sheets by default. To export only specific sheets: in the print dialog, click a sheet in the left panel and uncheck the 'Include in Export' option for any sheets you want to exclude. For a Numbers spreadsheet used as an invoice or financial report: configure all print settings precisely (margins, orientation, scaling) in the print preview first, then use File > Export To > PDF to save the result. The configuration you set in the print view is what the export uses.
- 1Open your Numbers document and go to File > Print to preview and configure layout settings
- 2In the print preview, select which sheets to include and set orientation, scaling, and margins for each
- 3For wide tables, switch orientation to Landscape and use 'Fit Content Width on One Page' scaling
- 4Close the print preview and go to File > Export To > PDF
- 5Choose image quality: Best for print, Better for general use, Smallest for email-size constraints
- 6Save with a descriptive filename and open the PDF to verify the output
Exporting Numbers to PDF on iPhone and iPad
Exporting a Numbers spreadsheet to PDF on iOS is accessible through the document's share/export options. In the Numbers app on iPhone or iPad: Open the document. Tap the three-dot (More) button in the top-right corner. Tap Export, then tap PDF. Choose image quality (Best, Better, or Smallest), then tap Export. The share sheet appears — save to Files, share via AirDrop, email, or any other option. For multi-sheet workbooks on iOS: the Numbers iOS app exports all sheets to the PDF by default. Unfortunately, the iOS export dialog does not currently provide the same per-sheet control as the Mac version. If you need to export only specific sheets, the most reliable approach is to use Numbers on iCloud.com from any browser (including mobile Safari) which provides more detailed export options. Print preview on iOS: before exporting, tap More > Print to see a print preview. This shows how the spreadsheet will look in the PDF. Use pinch-to-zoom to see the page layout and check for content that might be cut off at the edges. For very wide spreadsheets on iOS: if a wide table is being cut off, you cannot change page orientation in the iOS export dialog as easily as on Mac. For best control, move to the Mac version for the final export of complex multi-column spreadsheets.
Handling Complex Numbers Spreadsheets in PDF Export
Numbers spreadsheets with complex layouts — multiple tables on one sheet, mixed charts and data, or very wide data grids — require specific handling for clean PDF output. Multiple tables on one sheet: Numbers allows placing multiple tables anywhere on a sheet, including side by side. In PDF export, this renders as-is visually. Ensure tables that should be on the same page are positioned close together. Tables that should start on separate pages can be separated by inserting enough space between them to force a page break, or by placing them on separate sheets. Charts and graphs: Charts embedded in Numbers sheets export cleanly to PDF as vector or high-resolution images depending on chart type. Verify in the print preview that charts are not cut off by page boundaries. If a chart is being split across a page break, move it to avoid the break or place it on its own sheet. Very wide data tables: Use landscape page orientation. If a table is still too wide even in landscape, use scaling (Fit Content Width on One Page) to shrink it to fit — verify text remains readable at the scaled size. For financial data with many columns, consider whether some columns can be moved to a separate 'detail' sheet, with a summary view that fits within the page width for the main export. Headers that should repeat on each page: In Numbers' print settings, check 'Repeat table headers' if you have a data table that spans multiple pages. This ensures the column headers appear at the top of every continuation page, making the multi-page table readable without having to flip back to the first page to see what each column represents. For Numbers spreadsheets that have been shared with Windows Excel users, exporting as PDF provides a clean solution that avoids the formatting differences that sometimes appear when Numbers spreadsheets are converted to .xlsx format.
Converting Numbers Without Apple Software
If you receive a .numbers file on a non-Apple device and need to convert it to PDF, or if you need to convert Numbers files in a workflow without Mac or iOS, several options exist. iCloud.com in any browser: Navigate to icloud.com/numbers in any browser (Windows, Linux, Android). Sign in with an Apple ID, open the .numbers file, then export to PDF via File > Export To > PDF. This works from any device with a browser and an Apple ID. Ask for a PDF or DOCX at the source: The most reliable solution when receiving Numbers files is to ask the sender to re-send as PDF or at least as .xlsx (Excel). Numbers exports to .xlsx with File > Export To > Excel. The .xlsx can then be converted to PDF using LazyPDF's Excel to PDF tool — particularly useful when you are on a Windows device. Online converters for .numbers files: CloudConvert, Zamzar, and similar services can convert .numbers files to PDF. Upload the file, choose PDF as output, and download. These are convenient for non-sensitive files but involve uploading to third-party servers. For sharing with Excel users: if the goal is for someone to view the spreadsheet data (not edit it), PDF is ideal. If they need to work with the data, export as .xlsx from Numbers (File > Export To > Excel) and then consider whether they need the raw .xlsx or a PDF summary view — often both are valuable to send.
Frequently Asked Questions
How do I export only one sheet from a Numbers spreadsheet to PDF?
On Mac: go to File > Print, and in the left side panel showing all sheets, find the sheet you want to exclude and uncheck its 'Include in Export' checkbox (or simply click on only the desired sheet to preview it, then export). On iOS, the per-sheet control is more limited — you may need to delete other sheets temporarily or use iCloud.com in a browser for sheet-specific export.
Why is my Numbers table cut off in the PDF?
Tables are cut off when their content exceeds the configured page width in the print settings. Solutions: switch to landscape orientation, reduce font size, reduce column widths, or use the 'Fit Content Width on One Page' scaling option in Numbers' print/export settings. In the print preview, you can see exactly what is being cut off before exporting.
Can I convert a Numbers spreadsheet to PDF on Windows?
Not directly without Apple software. Your best option is iCloud.com in a Windows browser: sign in with an Apple ID, upload the .numbers file to iCloud Drive, open it in Numbers for iCloud, and export to PDF. Alternatively, ask the file's creator to export from their Mac or iPhone. For future compatibility, request that Numbers files be shared as .xlsx (Excel format) which can be converted to PDF using LazyPDF's Excel to PDF tool.
How do I add page numbers to a Numbers PDF export?
In Numbers on Mac, go to Insert > Headers & Footers. Add a footer with the page number field. In the footer editor, place your cursor and insert the page number via the Page Number button. Configure whether the header/footer appears on the first page. Alternatively, add custom text in the footer alongside the page number (for example, 'Page 1 of 4' using the page number and page count fields). These headers/footers appear in the PDF export.
Does Numbers PDF export preserve formulas?
No — and this is by design. PDF is a display format, not a data format. The PDF shows the calculated values from your formulas (the results), not the formulas themselves. This is typically what you want when sharing with others. Recipients see the data your formulas calculated, but cannot see or modify the underlying formulas. If you need someone to work with formulas, share the .numbers or .xlsx file instead.