CSV to PDF: Print a Wide Table That Stays Readable

A CSV export is the least glamorous file most people handle in a week. A bank statement, a list of orders, a class roster, a CRM dump someone needs "as a PDF" for a meeting. Converting CSV to PDF sounds like a one-click job. Then the PDF comes out with columns cut off at the right edge, a header that appears once on page 1 and never again, and every accented name turned into question marks.

None of that is bad luck. Each one has a cause, and each cause has a setting.

Quick answer: To convert a CSV to a PDF that stays readable, use landscape pages, a 7 to 9 pt font, and a header row repeated on every page, and keep the table under about 19 columns. CSV to PDF does all of that in your browser: drop the file, pick orientation and font size, download. No Excel, no upload.

What a CSV Actually Is (and Why It Fights Back)

A CSV is plain text: one record per line, fields separated by a delimiter. There is a document that describes it, RFC 4180, but it is informational. It wrote down common practice in 2005 and binds nobody. So "CSV" in the wild means a family of files that disagree on three things:

• The delimiter. Commas in the US and UK. Semicolons across much of Europe, because there the comma is the decimal separator and Excel takes its CSV delimiter from the Windows list separator (Ablebits has the details). Tabs when someone chose "Text (Tab delimited)". Pipes from databases that have been burned by both.
• The encoding. Excel's "CSV UTF-8" option writes UTF-8. Its older "CSV (Comma delimited)" option on Windows writes the system code page, usually Windows-1252. Read that second file as UTF-8 and every é, ü and ñ becomes a replacement character.

A converter that assumes comma plus UTF-8 handles the first case of each and quietly mangles the rest. Until this week ours did too. A German semicolon export came out as a one-column table with the whole row crammed into each cell, and a Windows-1252 export lost its accents.

Both are fixed. CSV to PDF now detects comma, semicolon, tab or pipe by looking for the one that splits the first ten lines into the same number of fields, and it ignores delimiters inside quoted text, so "Smith, Jane" stays one cell. It also obeys the sep=; line Excel sometimes writes at the top. For encoding it tries strict UTF-8 first, honors a UTF-16 byte-order mark, and falls back to Windows-1252 when the bytes aren't valid UTF-8. It also takes .tsv and .txt files now.

Why Wide Tables Fall Off the Page

Paper is narrow. A landscape A4 page with normal margins leaves about 762 points (10.6 inches) for the table. Portrait leaves about 515.

Every column needs some minimum width to be legible at all. Ours uses 40 points, which at 9 pt holds five or six characters after padding. Do the arithmetic and you get the real limit on any CSV to PDF conversion:

That diagram is also a bug report. Until I measured it for this post, a CSV with more than about 19 columns had its extra columns drawn past the right edge of the page. They were in the PDF and nobody could see them. Now the minimum width shrinks to an equal share when it has to, so all 30 columns of a 30-column export land on the page. They are cramped and heavily truncated, but present, and the PDF no longer looks complete when it isn't.

Within the limit, column widths follow the content. Each column gets space in proportion to its widest cell, so a Notes column gets more than a Qty column. When the content is wider than the page, every column is squeezed toward the minimum, and text that still doesn't fit is cut with "...". Cells never wrap onto a second line. That keeps each record on one line and the row count predictable, and it means a long description column will be truncated. If the full text matters, see the last section.

Landscape, Font Size and Rows per Page

These are the two settings that do the real work. I ran a 1,000-row, 8-column export through the converter at each combination:

Two things stand out. Portrait fits more rows per page, because the page is taller, but it has a third fewer points of width. So portrait wins on long, narrow files (a name, an email, a date) and loses on anything wide. And font size moves page count almost proportionally. Going from 9 pt to 7 pt cut this file from 30 pages to 23, at the cost of squinting.

My defaults, for what they're worth: landscape at 9 pt for anything you'll read on screen, 8 pt if it's going to a printer and you want fewer pages, portrait only when the file has six columns or fewer. The PDF size barely changed across all six runs (292 to 321 KB), so don't pick a setting to save space.

The Header Row on Every Page

Page 14 of a transaction export is a grid of numbers. Without the header you're counting columns with a finger to work out which one is the amount.

The fix is old. Spreadsheet apps call it "print titles" or "rows to repeat at top", and it's off by default in most of them. In CSV to PDF it's automatic: when "First row is header" is on, the first row is drawn bold on a grey band at the top of every page. When your file has no header row, switch that off and the columns are labeled Column 1, Column 2 and so on, so data isn't promoted to a heading by mistake.

Convert CSV to PDF, Step by Step

1. Open CSV to PDF and drop in your .csv, .tsv or .txt export. The table preview shows up right away, and the settings panel says how many rows and columns it found. A column count of 1 for a file that obviously has more means the delimiter wasn't recognised, usually because the file uses something unusual like a colon.
2. Leave "First row is header" on, unless the first line is data.
3. Pick orientation. Landscape for more than six or so columns.
4. Set the font size. 9 pt is the default; drop to 7 or 8 for wide files, raise it for tables people will read on paper at arm's length.
5. Convert, name the file, download.

The file never leaves your browser. That matters more for CSVs than for most documents, because a CSV is usually raw data: customer emails, salaries, account numbers, all of it machine-readable and ready to be reused by whoever holds it. Most online CSV converters upload the file to process it. Here's why every OxygenPDF tool doesn't.

Print a CSV File Without Excel

The other way people search for this is "print CSV file", and the honest options without Excel are thin:

• Open it in a text editor and print. You'll get the raw commas and quotes, no columns, and long rows wrapping into nonsense. Fine for a ten-line file, useless for a table.
• Open it in a browser. Browsers either download a CSV or show it as plain text. Same result as the text editor.
• Google Sheets or LibreOffice Calc. Both open CSVs well and both can repeat the header row when printing, if you find the setting. Sheets means uploading the file to Google; LibreOffice means installing an office suite. Both are good when you need to edit before printing.
• Convert to PDF and print that. The PDF is the printable form, and you can also email it, attach it to a ticket, or merge it with a cover letter.

What This Converter Doesn't Do

It's a fast route from a raw export to a readable table, not a report designer. Things it won't do:

• Wrap long cells. Text is truncated with "...". If a column holds paragraphs, delete the columns you don't need first, or open the file in a spreadsheet, set wrapping, and print to PDF from there.
• Choose or reorder columns. It prints every column in file order. Removing columns is a two-minute job in any spreadsheet app.
• Paper sizes other than A4. It's A4 in both orientations. On US Letter printers A4 prints with a slightly smaller scale, which works fine for tables.
• Formulas, styles or multiple sheets. A CSV has none of these. If your data started as a workbook, convert the workbook with Excel to PDF instead, which keeps cell formatting, merged cells and every sheet, and read how to fit wide spreadsheets on a page.

Going the other way, from a PDF table back to rows and columns, is PDF to Excel.

Frequently Asked Questions

How do I convert a CSV file to PDF for free?

Open CSV to PDF, drop in the file, choose landscape or portrait and a font size, and download. It's free, needs no account, and runs in your browser, so the data isn't uploaded.

Can I convert CSV to PDF without Excel?

Yes. A CSV is a text file; you don't need a spreadsheet app to turn it into a table. A browser-based converter reads the file, lays out the rows and columns, and writes the PDF. You only need Excel or another spreadsheet if you want to edit the data first.

Why are some of my columns missing in the PDF?

Usually too many columns for the page width. On A4 roughly 19 legible columns fit in landscape and 12 in portrait. Many converters, ours included until recently, silently drew the extra columns off the edge of the page. Switch to landscape, lower the font size, or delete columns you don't need before converting.

Why does my CSV show up as one column?

The file uses a different delimiter, usually a semicolon (common in European exports) or a tab, and the converter assumed commas. CSV to PDF detects comma, semicolon, tab and pipe automatically.

Why do accented characters turn into question marks or boxes?

Encoding, nearly always. The file was saved in Windows-1252 (Excel's plain "CSV (Comma delimited)") and read as UTF-8. CSV to PDF detects that and reads it correctly. The other cause is a font with no glyph for the script; the converter embeds a font that covers the characters in your data, and fetches an extra Noto font for scripts like Arabic or Chinese when it needs one.

Does the header repeat on every page?

Yes, when "First row is header" is on. It's drawn bold on a grey band at the top of each page.

Short Version

Landscape, 8 or 9 pt, header on every page, under 20 columns. Get those four right and a 1,000-row export becomes 30 pages someone can actually read.

Convert your CSV to PDF in your browser, with the export staying on your computer.