DATA PREPARATION

How to make a graph from CSV

A reliable CSV graph starts with a correctly parsed rectangular table and an explicit mapping from source columns to chart roles.

Check the delimiter and header

ChartMaker detects comma, semicolon and tab separators. A UTF-8 BOM is accepted. Confirm the detected delimiter and decide whether the first row contains field names.

Properly quoted fields may contain delimiters, doubled quotes and line breaks. Missing cells remain empty rather than becoming zero.

Map the source columns

Choose one category and one value for a simple bar chart, two numeric columns for Scatter, several numeric columns for grouped or stacked charts, or one raw observation column for Histogram.

If the selected shape does not satisfy the chart contract, correct the mapping or source instead of forcing invalid values.

Continue with editable data

The browser-local workflow transfers a validated Project v2 object to the existing editor. The original CSV is not sent to PHP or an external conversion service.

Use source CSV export to preserve the table and project JSON to preserve chart settings as well.

COPYABLE EXAMPLE

Example CSV

Category,Revenue,Note\nNorth,120,"Includes online, retail"\nSouth,98,"Quoted ""reviewed"" value"\nWest,,Missing value stays empty

Try the working tools

Bar Graph MakerScatter Plot MakerHistogram MakerBar and Line Chart Maker

Related workflows and guides

Turn CSV data into a graph
GUIDE FAQ

Questions about this task

Yes, when the field is enclosed in double quotes.