# View CSV Data as a Table

> Paste or open CSV — preview as sortable/filterable HTML, export as HTML, Markdown, JSON, or Excel. Auto-detect delimiter, column types, header row.

Live tool: https://lofttools.com/tools/text-tools/csv-to-table

Category: Text & Writing

## How it works

1. **Paste or open CSV** — Paste CSV data into the input box or click Select file to load a .csv / .tsv / .txt file.
2. **Configure the table** — Pick a delimiter (or leave on auto), toggle whether the first row is a header, add a caption, striped rows, line numbers, or a responsive wrapper.
3. **Preview and sort** — The table renders instantly with column type badges (text / number / date / boolean). Click any header to sort numerically or by date.
4. **Export** — Copy as HTML, Markdown, or JSON, or download as .html or Excel (.xls).

## FAQ

### What delimiters does it support?

Comma, semicolon, tab, and pipe. Auto-detect picks the separator with the most occurrences on the first line, ignoring any inside double quotes.

### Can I turn off the header row?

Yes. Uncheck "First row is header" and every row is treated as data; columns are labeled Column 1, Column 2, and so on.

### How does column type detection work?

After parsing, each column's values are scanned. If every non-empty value matches a number, ISO date / MM/DD/YYYY date, or boolean (true/false/yes/no), that type is shown in the header badge and used for numeric / chronological sorting.

### Which file formats can I export?

HTML (with optional caption, striped rows, line numbers, responsive wrapper, custom CSS class, and minification), Markdown, JSON, and Excel (.xls, opens in Microsoft Excel, Google Sheets, and LibreOffice Calc).

### Does it handle quoted values with commas inside?

Yes. Parsing follows the RFC 4180 quoting rules, so "Smith, John" stays in one cell and "" inside a quoted field becomes a literal quote.

## Privacy

This tool runs entirely in the browser. Files are not uploaded to a server. They never leave the user's device.

## More

- All tools: https://lofttools.com/tools
- Category: https://lofttools.com/tools/text-tools
- LLM index: https://lofttools.com/llms.txt