Sending a spreadsheet as a PDF stops accidental edits and makes it open the same way on every phone and printer. The common complaints are text so small it cannot be read and pages where nobody knows which column is which. A few minutes of preparation in the sheet, and a converter that repeats the header row, fixes both.
Key takeaways
- Remove columns nobody needs before converting; fewer columns means a larger, readable font.
- The PDF shows the values last saved in the file, so recalculate and save first.
- CSV exports from banks and school portals convert directly.
Prepare the sheet before converting
Delete or hide helper columns, notes to yourself and empty columns at the right edge, and put the columns people care about first. Each extra column shares the page width, and once a table passes six columns the converter switches to landscape and shrinks the font, down to a minimum of 6 point. Only the first 30 columns are included at all.
Make sure totals show the right values
The converter does not run formulas. It prints the value the spreadsheet program saved for each cell. Open the workbook in Excel, LibreOffice or Google Sheets, let it recalculate, save it, and then convert. If you build the file with a script, make sure it stores calculated values and not only formulas.
How the PDF table is laid out
Every sheet with data becomes its own table starting on a new page, with the sheet name above it when there is more than one. The first row is bold and shaded and repeats at the top of each page. Columns are sized to their content, long text wraps inside the cell, and numbers and percentages are right-aligned so digits line up.
Converting CSV exports
Banks, school portals and accounting programs often export CSV rather than Excel. Both comma and semicolon separators are detected automatically, and quoted values that contain commas stay in one cell. The file name becomes the PDF title, so rename the file to something meaningful before converting.
When to use your spreadsheet program instead
Charts, colours, merged cells, cell formats and images are not reproduced, and only Latin text can be drawn. For a formatted report, a dashboard with charts, or a sheet with Hindi or other non-Latin text, use the Export as PDF or Print to PDF option in Excel or Google Sheets.
Put the guide into practice
Open the related tool when it fits your task, and check its supported formats and limitations before downloading or submitting a file.