Convert CSV Data Into a Formatted PDF Table
Parses your CSV properly, including quoted fields, and draws it as a paginated table with a coloured header row and alternating row shading. Orientation is chosen automatically from the column count.
About the CSV to PDF Converter
Sending someone a CSV asks them to have a spreadsheet application, to open it correctly, and to not accidentally destroy the formatting of a column of reference numbers. Sending a PDF asks them to look at it. This converter takes the middle step, laying the data out as a table with a blue header row, alternating pale shading on the body rows, and automatic page breaks as the data runs on.
Orientation is decided for you: more than six columns produces a landscape page, six or fewer a portrait one. The file name becomes a heading above the table, and the first row is treated as headers and styled accordingly.
Key Features
- A real CSV parser: Quoted fields containing commas are handled correctly, doubled quotation marks inside a quoted field are decoded, and both Windows and Unix line endings are recognised — so a file with addresses or free-text notes in it parses properly rather than splitting in the wrong places.
- Header row styled distinctly: The first row is drawn in bold white on a blue band, which survives photocopying and reads clearly when the table runs over several pages.
- Alternating row shading: Body rows are banded in a pale tint, which is what makes a wide table readable across its full width.
- Orientation chosen automatically: Wide data gets a landscape page without you having to think about it.
- Blank rows discarded: Empty lines in the source are skipped rather than becoming empty bands in the table.
- Converted on your machine: The file is read as text in the browser and jsPDF draws the table locally, so a data export is turned into a document without being uploaded.
How to Use the CSV to PDF Converter
- Add the .csv file you want as a table.
- Press Convert to PDF.
- Download the result and check the columns against your source data.
- If columns did not separate, see the note on delimiters below.
How It Works
Two limitations will affect real data, and both are worth checking before you send the output to anyone.
Only the comma is treated as a delimiter. This matters more than it sounds, because Excel on a system configured for German, French, Spanish and several other European locales writes CSV files using a semicolon instead — the comma being the decimal separator in those languages. Such a file will parse as a single column with all the values crammed into it. If your table comes out as one wide column, that is why, and the fix is to re-save from your spreadsheet application choosing comma as the separator, or to replace the semicolons before converting.
Second, cells longer than forty characters are truncated and marked with an ellipsis. This keeps the table legible, since one long free-text field would otherwise overwhelm the layout, but it does mean data is silently shortened. A CSV containing descriptions, addresses or notes will lose the tails of those fields, so this is a presentation format rather than a faithful record — keep the original.
Columns are also given equal width regardless of what they contain, so a column of two-digit numbers occupies as much space as a column of names. And the header row is drawn once at the top rather than repeated on each new page, so a long table's later pages arrive without column labels.
When You Need It
The treasurer of a sports club needs to put the season's accounts in front of a committee meeting, and half the committee will be reading on paper. Exporting from the accounting spreadsheet gives a CSV; converting it gives something that can be printed, tabled and minuted without anyone needing a spreadsheet application.
An organisation responding to a data subject access request has to hand someone a copy of the personal data it holds about them, which almost always comes out of a database as CSV. That file consists entirely of one identifiable person's information, which makes running it through an online converter to make it presentable a data breach committed in the course of complying with data protection law. Converting locally avoids the irony and the liability.