Convert to PDF guide
Convert a CSV File to a Printable PDF Table
Updated
Short answer: Drop the CSV into CSV to PDF; the rows are laid out as a table with a bold header row, across as many pages as needed.
Bank exports, order lists, attendance logs and database dumps arrive as CSV. Opened in a text editor they're unreadable; opened in a spreadsheet they're fine but can't be sent to someone who just wants to read or print them.
Step by step
Step 1: Check the file opens as text with one record per line. The first line should be the column headings.
Step 2: Remove columns you don't need to print. Fewer columns means a more readable table.
Step 3: Open CSV to PDF and drop the file.
Open CSV to PDF(runs on our server)Step 4: Download the PDF and check the widest columns.
Step 5: For a sheet that must fit one page across, set the print area and fit-to-width in a spreadsheet app and use Excel to PDF instead.
Open Excel to PDF(runs on our server)
Why this works, and what to watch for
CSV is just text: one row per line, values separated by a delimiter. Despite the name, the delimiter isn't always a comma. Many European systems use semicolons, because the comma is their decimal separator, and some exports use tabs or pipes. CSV to PDF detects comma, semicolon, tab and pipe automatically from the start of the file, and respects quoted values, so a field like “Smith, John” stays in one cell.
The table is laid out as a document: the first row is set in bold as the header, every other row follows, and pages break as needed. Blank lines are skipped. Columns that don't fit the page width continue on following pages, the way spreadsheets print, which is readable but means flicking between pages for wide data. Trimming unneeded columns beforehand is the single biggest improvement you can make.
Encoding matters for names and currencies. UTF-8 handles every language; older exports from Windows software are sometimes saved in a legacy encoding, which can turn é into é. If you see that, open the file in a text editor and re-save it as UTF-8. A byte-order mark at the start, which Excel adds to UTF-8 CSVs, is handled automatically.
Limits keep the output sensible: up to 20,000 rows and 200 columns. Beyond that, a PDF isn't a good way to read the data; filter it in a spreadsheet first, or split the export.
If you want control over column widths, number formats or landscape pages, open the CSV in Excel, Google Sheets or LibreOffice, adjust it, save as XLSX and convert with Excel to PDF, which follows the print settings saved in the workbook.