How to send a spreadsheet that looks right

You send an invoice as .xlsx. The other side opens it in a different spreadsheet app, on a phone, with different fonts installed, and sees three columns pushed onto a second page, a header floating alone and a total showing as ####. Nothing was corrupted. A spreadsheet simply has no fixed layout: it is a grid, and every app decides for itself where the pages end and how wide a column needs to be.

A PDF fixes the layout once, on your side, so everyone sees the same pages. This guide covers when to send PDF, how to prepare the sheet so the PDF comes out right, the built-in ways to export, and what to do when the result is not quite right.

When to send PDF and when to send the spreadsheet

Send a PDF for:

• Anything final: invoices, quotes, reports, price lists, timesheets, statements. The recipient needs to read it, not recalculate it.
• Anything that will be printed or filed in an archive.
• Anything opened on a phone. Spreadsheets on a small screen are hard to navigate; a PDF page scrolls and zooms predictably.
• Anything with formulas or hidden data you would rather not share. A PDF carries the visible values, not the formulas, hidden sheets or the notes column you forgot about.

Send the spreadsheet itself only when the other person will actually work with the numbers: a budget to fill in, data to import, a model to adjust. If in doubt, send both: the PDF to read, the spreadsheet to edit.

Prepare the sheet first

Whatever tool creates the PDF, it follows the page setup stored in the workbook. Two minutes here decide whether you get one tidy page or twelve scattered ones. The names below are Excel's; other spreadsheet apps have the same options under similar names.

1. Set a print area. Select the table and use Page Layout → Print Area → Set Print Area. Without it, everything up to the last used cell is exported, including a stray value far below the data.
2. Look at Page Break Preview. View → Page Break Preview shows the page boundaries as blue lines. Drag them to move page breaks where they make sense, for example between sections rather than through the middle of a group.
3. Choose orientation. Tables wider than about eight to ten columns usually read better in landscape.
4. Fit columns to the page width. In the print settings choose Fit All Columns on One Page, or in Page Setup set Fit to 1 page wide and leave the height empty. This alone fixes most split-column complaints. Avoid fitting a long sheet onto one page entirely: 300 rows squeezed onto A4 cannot be read.
5. Repeat the header row. Page Layout → Print Titles → Rows to repeat at top. Page four of a price list should still show what each column means.
6. Add a footer. Page numbers and the document name help anyone who prints the file and drops the pages.
7. Widen tight numeric columns slightly. A column that is just wide enough on your machine shows #### when a substitute font is a little wider.

Each sheet has its own page setup, so repeat this on every tab you want in the PDF.

Built-in ways to export

If you have a spreadsheet app installed, it can make the PDF itself, and for most people that is the simplest route:

• Excel on Windows: File → Save As (or Export) → PDF. Under Options choose whether to publish the active sheet, a selection or the entire workbook.
• Excel on Mac: File → Save As and pick PDF as the file format, or File → Print → PDF → Save as PDF.
• Numbers on Mac: File → Export To → PDF.
• Any Windows app: print and choose Microsoft Print to PDF as the printer.
• iPhone or iPad: open the file in Files to preview it, tap Share → Print, then use the Share button in the print options to save the PDF to Files.

The preview on a phone shows only what the preview engine can render, so check the result before sending.

Convert without Office installed

When you have received an .xlsx on a computer without a spreadsheet app, or you want the same result regardless of the machine, use Excel to PDF. It accepts XLSX, XLS, ODS and CSV.

Office formats cannot be converted inside a browser, so this one runs on our servers. LibreOffice Calc opens the workbook and exports it with the page setup stored in it, exactly as described above. All visible sheets with content are exported into one PDF; hidden sheets are left out. To send only one sheet, hide the others before saving the file. The uploaded workbook is deleted when the PDF is ready, and the result expires about an hour later, so download it right away. Without an account you get one conversion a day for files up to 500 MB.

The text in the PDF is real text, so the recipient can search it and copy figures out of it.

CSV files

A CSV has no formatting and no page setup, so it is exported with defaults and often in portrait with cut-off columns. The converter reads commas as separators; a CSV exported with semicolons, common where the comma is the decimal mark, ends up in a single column. For anything you plan to share, open the CSV in a spreadsheet app, set up the page, save as XLSX and convert that.

Presentations work the same way

A deck sent as .pptx has the same problem: missing fonts and different app versions move text boxes around. PPT to PDF turns each slide into a page.

Sending several documents together

An invoice, a timesheet and a cover letter as three attachments get separated, forwarded incompletely or filed in the wrong order. Convert each to PDF, then combine them with Merge PDF in the browser. If the pages need continuous numbering across the whole pack, add it afterwards with Add page numbers.

Image-heavy workbooks and decks can produce large PDFs. If the file is too big for email, run it through Compress PDF.

Troubleshooting

• One column ends up alone on a page. The table is slightly too wide for the paper. Use landscape or fit all columns to one page wide.
• Dozens of empty pages. There is formatting or a value far outside the table. Set a print area.
• #### in some cells. The column is too narrow for the font used during conversion. Widen it a little and convert again.
• No gridlines. Spreadsheets do not print gridlines by default. Add cell borders or enable printing gridlines in Page Layout.
• Charts look slightly different after server conversion. Charts are redrawn by a different engine, so label positions and colours can shift. If a chart matters, check it, or export from the app you built it in.
• Wrong sheets included. Hide the sheets you do not want, or delete them in a copy of the file.

A PDF is not protection. Anyone can copy the text out of it. If the numbers are confidential, add a password with Protect PDF and send the password through a different channel.

Checklist

1. Decide whether the recipient needs to read or to edit.
2. Set the print area on every sheet.
3. Check page breaks, orientation and fit to one page wide.
4. Repeat the header row and add page numbers.
5. Export from your spreadsheet app, or use Excel to PDF without one.
6. Open the PDF and check every page before sending.
7. Merge related documents into one file, and protect it if needed.