How to turn a CSV into a clean PDF table

Short answer: A CSV is rows of text with commas in it. It has no column widths, no fonts, no page size and no page breaks, so “convert to PDF” really means “decide a layout and then render it”. Either open it in Excel and make those decisions yourself — widths, orientation, repeated header row, scale — or hand the .csv to a converter whose engine decides them: columns fitted to their content, rows kept whole, and a wide table sliced across pages rather than crushed.

Doing it by hand in Excel

1. Open the .csv in Excel. Watch for the classics: long IDs turned into scientific notation, leading zeros dropped, dates reinterpreted. If any of those matter, use Data → From Text/CSV and set those columns to Text during import.
2. Select all and AutoFit column width (Home → Format → AutoFit Column Width).
3. Format the header row — bold, a fill, a bottom border. A raw CSV has no visual hierarchy at all, and this is what makes it look like a document.
4. Page Layout → Orientation → Landscape for anything wide.
5. Page Layout → Print Titles → Rows to repeat at top: row 1. Without this, page 2 onward is a table with no column names.
6. Scale to Fit → Width: 1 page, Height: Automatic.
7. Export to PDF and check the last column is actually on the page.

Then save the result as .xlsx if this is a recurring export — otherwise you will repeat all seven steps next month.

Letting the converter lay it out

Because there is no page setup to preserve, this is the one format where a layout engine has nothing to fight. The free web converter takes a .csv directly, measures each column’s real content width, picks the orientation from the shape of the data, keeps every row whole across page breaks, and — when the table is too wide to be readable at full width — slices it across pages with the label column repeated rather than shrinking the text past reading. It uploads the file, converts it and deletes it afterwards.

A note on the data itself

Nothing here fixes a CSV that is wrong. If the export has an off-by-one header, a stray delimiter inside a quoted field, or a trailing blank column, that survives into the PDF looking official. Open it and read the first ten rows before you convert — thirty seconds that has saved a lot of people from sending a document with a column shifted by one.

FAQ

Why does my CSV look terrible when I print it from a text editor? Because a text editor prints it as text: no columns, no widths, one long line per row. It has to be laid out as a table first, either in a spreadsheet or by a converter that does the layout.

How do I stop Excel mangling IDs and dates in a CSV? Import with Data → From Text/CSV rather than double-clicking the file, and set the affected columns to Text in the import preview. Once Excel has converted a value, the original is gone.

Can I convert a CSV to PDF without Excel? Yes. A browser converter that accepts .csv does it with no Office installed — the free web tool here takes .csv directly.

My CSV has forty columns. What is the realistic outcome? Not one readable page. Either select the columns that matter before converting, or use a layout that slices the table across pages with the label column repeated. Forcing forty columns onto one sheet of paper produces text nobody can read.