The short answer
Open the .xlsx or .csv file in the converter below, or paste cells copied from Excel. If the workbook has several sheets, pick one in the Sheet list. Keep First row is header on so the column names repeat on every page, keep Fit to page width on, and leave Orientation on Auto: wide tables switch to landscape by themselves. Look through the preview page by page and press Download.
Long text wraps inside its cell instead of running off the page, and number columns are aligned to the right. If all columns still do not fit, the font gets smaller step by step; the status line tells you the size that was used.
Try it here: Excel to PDF
Open the full tool pageWhy spreadsheets print badly
A sheet on the screen has no pages. It can be as wide as you like, and the column names stay visible because the top row is frozen. Paper is different: an A4 or Letter page holds around eight to twelve ordinary columns in portrait. Everything to the right is moved to extra pages, so one table becomes a stack of pages that only make sense side by side, and from the second page on nobody knows which column is which.
Three settings solve almost every case: landscape orientation, scaling to the page width, and a header row that repeats on every page. Wrapping long text inside the cells helps too, because one long description column is often the real reason a table is too wide.
Doing it in Excel
- Orientation: Page Layout > Orientation > Landscape.
- Fit all columns: Page Layout > Width > 1 page (leave Height on Automatic). In the print dialog the same setting is called Fit All Columns on One Page.
- Repeat the header row: Page Layout > Print Titles, then set Rows to repeat at top to $1:$1.
- Print only part of the sheet: select the range and use Page Layout > Print Area > Set Print Area.
- Gridlines: Page Layout > Sheet Options > Gridlines > Print.
- Save the PDF: File > Save As (or Export) > PDF, and under Options choose whether to save the active sheet or the entire workbook.
- Google Sheets: File > Download > PDF opens the same settings: Fit to width, landscape, and Repeat frozen rows.
Doing it in your browser
The converter on this page does the same work automatically and does not need Excel. It measures every column, sizes it to its content, wraps long values and repeats the header row on every page. It also works with CSV files from online shops, banks and databases, which open badly in Excel when the separator or the characters are not recognized: comma, semicolon and tab are detected, and accented letters stay correct.
Codes with leading zeros, such as barcodes and postal codes, are printed exactly as they appear in the file. Dates are shown as year, month and day. You can add a title for the first page, page numbers, gridlines and striped rows, and choose A4, Letter or A3 paper.
What is not copied from Excel
The converter prints the values, not the look of the sheet. Cell colors, fonts, borders you drew, merged cells, conditional formatting, charts and pictures are not copied, and formulas appear as their last calculated value. Number formats such as currency symbols and thousands separators are not applied, so 1499.9 is printed as it is stored. If the exact Excel formatting matters, use Excel's own Save As PDF with the settings above.
Old .xls files must be saved as .xlsx first, and only one sheet is converted at a time; convert each sheet and merge the PDFs afterwards if you need them in one file.
Long tables and several sheets
A list with thousands of rows is no problem: the converter splits the rows across pages, never cuts a row in half between two pages and writes the header row again at the top of every page. The number of rows, columns and resulting pages appears in the status line, and you can step back and forth through every page in the preview.
To get each sheet of a workbook as its own PDF, pick them one after the other in the Sheet list and download each one. If you need them all in one document, drop the files into Merge PDF and combine them in the order you want. For exports you make regularly, such as orders, stock or price lists, bookmark the Share with these settings link so you do not have to choose the same options again.
Tips for a readable PDF table
- Remove columns nobody needs before converting; fewer columns means larger text.
- Choose A3 for very wide tables that will be printed on a large printer.
- Use striped rows for long lists so the eye can follow a row across the page.
- Add a title that says what the table is and when it was exported.
- Keep page numbers on for anything longer than two pages, so printed pages can be put back in order.