Tabular data guides

Inspect a CSV and publish a standalone HTML table

·

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.

RFC 4180 — CSV format and media type

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.

Two product labels
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.

Related guides