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.