CSV to PDF: Make a Spreadsheet File Printable (Free)

A CSV file is data at its most raw — rows of values separated by commas, no formatting, no column widths, no idea how it should look on a page. That's why converting one straight to PDF usually produces something unreadable: columns chopped mid-word, one table smeared across nine pages. The fix is to let a spreadsheet app do the layout, then export. Ten minutes, no purchases, and the result actually looks like a report.

Google Sheets (free, works everywhere)

1. Go to Google Sheets, File > Import, upload the CSV.
2. Let it detect the separator automatically (it almost always gets it right).
3. Tidy the layout: select all, then Format > Resize columns > Fit to data. Bold the header row.
4. File > Download > PDF Document.
5. In the export screen, the settings that matter: Landscape orientation for wide data, scale "Fit to width," and tick "Repeat frozen rows" so the header appears on every page.

That last screen is where the magic is — "fit to width" alone fixes the cut-off-columns problem that makes people give up on this conversion.

Excel (best-looking output)

1. Open the CSV in Excel. If everything lands in one column, use Data > Text to Columns and pick the right delimiter.
2. Format as you like — Excel's Format as Table styles give you presentable zebra-striping in one click.
3. Go to Page Layout and set Width to 1 page (leave Height automatic). This is Excel's version of fit-to-width.
4. File > Export > Create PDF/XPS, or simply File > Save As with PDF as the type.

For wide spreadsheets, also set Print Titles (Page Layout > Print Titles > Rows to repeat at top) so the header row follows the data across pages.

The quick-and-dirty route

If presentation truly doesn't matter — you just need the data frozen into a PDF for the record — open the CSV in any text editor and print to PDF. On Windows that's Notepad plus Microsoft Print to PDF. You'll get raw comma-separated lines, but for an audit trail that's sometimes exactly enough.

Common problems

• Dates turned into gibberish: Excel "helpfully" reformats anything date-shaped on open. Import via Data > From Text/CSV instead and set the column type to Text before loading.
• Leading zeros vanished (ZIP codes, phone numbers): same fix — import with the column typed as Text.
• Special characters look wrong: the CSV is probably UTF-8 and Excel guessed wrong. The Data > From Text/CSV importer lets you pick the encoding.
• Way too many columns for one page: delete the ones the reader doesn't need before exporting. A PDF of 40 columns helps nobody.

Going the other direction

If you landed here trying to get data out of a PDF and into a spreadsheet, that's a different job with better tooling than copy-paste: our data extraction tool pulls tables from invoices and statements into CSV, entirely in your browser. The long version is in our PDF to CSV guide.

And once your CSV is a PDF: combine it with a cover page using merge, or password-protect it if the numbers are sensitive — both local, nothing uploaded.