CSV to Table Converter

Turn CSV data into an HTML table, ready to paste into a page or an email. Choose whether the first row is the header, and add line numbers or a row of totals. The delimiter is detected for you.
Input
Output

Settings

How the input is converted. Each is explained below.

Tags

History

CSV is an old & very popular format for storing tabular data. It has been used in the desktop as well as mainframe. It is a simple & compact format that works really well for tabular data and so is still in use today.

HTML is the language of the internet. It is what creates HTML pages (even this one). In the old days, HTML used to be static with some JavaScript added into the mix for dynamic behavior and effects. Then HTML was served dynamically from the server side with the advent of server side programming languages such as PERL, PHP, ASP. And now there is a new trend where HTML is again being served as static resources with JSON (from REST web services) and JavaScript making it dynamic.

Settings explained

Delimiter
What separates the fields in the input: auto detect, comma, tab, semi-colon, pipe or space. Auto detect works in most cases, but in a very small CSV whose values also contain the delimiter it can guess wrong - choose the delimiter then.
First row is header
On, the first row names the columns. Off, the columns are named column 1, column 2 and so on, and the first row is read as data.
For this input
Name,Department,Salary
Robin Hood,Sales,200
Add line numbers
Adds a column at the front with each row's number.
Add table heading
Writes the header row with TH cells instead of TD.
Sum numeric fields
Adds a row at the bottom with the total of every numeric column.