Slate PDF

Converting

How to Convert a CSV to PDF

Turn raw comma-separated data into a readable PDF table — handling wide files, long files, and the formatting a CSV does not carry.

June 23, 20262 min read

A CSV is data with no opinions about presentation. Converting it to PDF means someone has to decide the column widths, the page breaks and where the header goes — and if nobody decides deliberately, the defaults will decide badly.

Convert a CSV

  1. 1Open the Excel to PDF tool — it reads CSV as well as XLSX.
  2. 2Add your file. The rows and columns are laid out as a table.
  3. 3Choose landscape if you have more than about eight columns.
  4. 4Convert, and check the last column made it onto the page.

What a CSV does not contain

It is worth being clear about this, because people are often surprised by the plainness of the output. A CSV has no fonts, no colours, no column widths, no number formats and no notion of a header row. It is text separated by commas. Everything about how the PDF looks is added during conversion.

That is also why dates and long numbers sometimes come out oddly: 0044 loses its leading zeros unless the field was quoted, and 03/04 is ambiguous between March and April. Both are properties of the CSV, not faults in the conversion.

Wide files

  • Use landscape orientation before anything else.
  • Drop columns the reader does not need — a CSV export usually carries internal IDs nobody wants.
  • Shorten headers; the column name is often longer than any value beneath it.
  • If it is still too wide, split it into two logical tables rather than shrinking the type until it cannot be read.

Format it before converting, if it matters

For anything going to a client or a regulator, open the CSV in a spreadsheet first, format it properly — bold the header, set number formats, widen the columns to fit — and convert the spreadsheet instead. Thirty seconds of formatting is the difference between a data dump and a document.

The opposite direction

If you have a PDF containing a table and you need the data, that is PDF to Excel, which reads the table structure back out into cells you can work with. Converting a CSV to PDF and back is lossy in both directions and should be avoided when you still have the original data.

Do it now

Excel to PDF

Turn a spreadsheet (XLSX) into a PDF. It runs in this browser tab — your file is not uploaded anywhere.

Open Excel to PDF

Frequently asked questions

Why do my leading zeros disappear?+

They were read as numbers. Quote those fields in the CSV, or format the column as text in a spreadsheet before converting.

Can I convert a very large CSV?+

Yes, but a hundred-thousand-row PDF is not a useful document. Filter or summarise the data first — a PDF is for reading, not for storage.

How do I keep the table on one page?+

Reduce the number of columns and rows. Scaling a large table down to fit usually makes it illegible rather than compact.

Does the CSV delimiter matter?+

Yes. Files exported in some European locales use semicolons. If every row lands in a single column, that is why.

Keep reading