Inspect a CSV and publish a standalone HTML table
Admin ·
A visual table lets you check whether a quoted comma belongs to a location name or separates two columns. Choose the header setting first so the first record appears in the right place.
CSV Viewer and HTML Table Exporter
Locate a row before export
Use city,country followed by Lima,Peru and Oslo,Norway on separate lines. Search for way to show the Oslo record. Clear the search and select the city heading twice to alternate ascending and descending text order.
Check the saved table
Download the HTML, open it and verify that Lima still precedes Oslo. A field such as <b>Lima</b> appears literally inside its cell. The saved document contains a static table, so it can be opened without running scripts.
Check how markup-looking cells appear in the HTML export
Select Comma and a header row, then open the exported HTML. Look at the second column in each row. A product label can contain characters that also have meaning in HTML.
sku,label
A,<demo>
B,red & blue- The first label should show the literal angle brackets around demo. The second should display one ampersand. If you inspect the HTML source, escaping those characters is what lets the browser display them as ordinary cell text.
Common questions
Why does 10 sort before 2?
Sorting compares cell strings. The first character of 10 sorts before the first character of 2.
What if my data has no headings?
Clear First record contains column names. Every input row then appears as data, with numbered column labels in the preview.
Sources
Put it into practice.
- CSV Viewer and HTML Table Exporter
- CSV and TSV Validator
- CSV Delimiter Detector and Converter
- CSV Duplicate Row Finder
Related guides
- Checking delimited records before import
- Choosing separators for delimited text
- Reading a CSV duplicate-row report
- Keeping IDs and nested data in CSV
- Reading JSON Lines as a table
- Review PDF Stock Tables Before Excel Export
- Check PDF Table Fields Before CSV Export
- Sort Exact IDs in Nested JSON Records
- Split a Warehouse Log into Columns
- Make a French Name Fixture With Accents
- Map the Columns for a Market Stall Chart
- Print a Stock Table With Repeated Headers
- Review CSV Columns Before Sharing Data
- Turn CSV Records Into a Markdown List
- Make Reproducible CSV and JSON Test Data
- Verify a Cleaned Inventory CSV
- Join Two CSV Exports Without Losing Leading Zeros