Excel or PDF: Which Should You Send? (With Test Results)
Send Excel (XLSX) when the other person needs to change the numbers, sort, filter or check the formulas. Send a PDF when the figures are final -- an invoice, a quote or a report -- and must look the same for everyone. In our test a workbook with 24 formulas became a 2-page PDF that showed every result but no formulas, and turning that PDF back into Excel gave lines of text, not working numbers. To make the PDF, use our Excel to PDF converter.
The quick answer
Excel is for working with numbers; PDF is for reading them. If someone has asked for a specific format, send that. Otherwise:
| Situation | Send |
|---|---|
| The other person will edit, sort, filter or add to the data | Excel (XLSX) |
| They need to see or check how totals are calculated | Excel (XLSX) |
| An invoice, quote, statement or final report | |
| It must look the same on any phone or computer, and print neatly | |
| You want a fixed record and a working copy | Both: the PDF as the record, the XLSX to work in |
What a PDF keeps and loses from a spreadsheet
We made a two-sheet workbook: an invoice with 20 lines, each line total calculated by a formula, a SUM at the bottom, and a summary sheet that adds 10% tax. Then we converted it to PDF with our Excel to PDF code, and converted that PDF back to Excel with our PDF to Excel code.
| Step | Result |
|---|---|
| Original XLSX | 5.9 KB, 2 sheets, 24 formulas |
| Excel to PDF | 10.7 KB, 2 pages - one per sheet |
| Totals in the PDF | Shown as results (997.5, 99.75, 1097.25) |
| Formulas in the PDF | None - only the results are printed |
| PDF back to Excel | 2 sheets named Page 1 and Page 2 |
| What came back | Each row as one line of text in column A; 0 formulas, 0 cells stored as numbers |
Computer-made test workbook. The PDF had no gridlines, which is why each row came back as a single line of text.
Why the PDF can't give the spreadsheet back
A PDF stores what a page looks like: each piece of text at a position, plus any lines. It doesn't store cells, formulas or which number belongs to which column. Converting back to Excel has to guess the table from the layout, and without ruled lines between cells there is nothing to guess from -- as our test shows. Our guide on PDF tables in Excel has more test results.
So if the other person needs the numbers, send the XLSX as well. A PDF is the right file when the numbers should not change.
Before you send a spreadsheet as a PDF
- Check every sheet: each sheet becomes its own page or pages -- in our test the summary sheet became page 2.
- Check wide sheets: our Excel to PDF converter fits every column across the page width; our guide on fitting a spreadsheet on one page explains the options.
- Hidden helper sheets or columns with notes you don't want shared: remove them in Excel first.
- Old .xls file: it converts too, but our XLS vs XLSX guide explains why XLSX is the safer format to keep.
How we tested
November 2026. The workbook was made with openpyxl, converted to PDF by the same LibreOffice-based code our Excel to PDF tool runs (LibreOffice 24.2), and the PDF converted back by the code our PDF to Excel tool runs, in a test copy of the site. Formulas and cell types were counted with openpyxl and the PDF text was read with pypdf. Workbooks with ruled tables will convert back differently.