How to make a chart from a CSV file (any chart type)

Every tool exports CSV — your bank, your analytics dashboard, your CRM, every spreadsheet ever. Which makes "CSV to chart" the most common visualization job there is. Here is the whole path, from raw export to a chart you can drop in a deck, without writing a single formula.

Step 1 — Know which shape your data is in

Almost every CSV you will ever chart is one of three shapes. Two columns of label and value ("Rent, 1200") make category data: bars, pie, donut, treemap, funnel. A label column plus several numeric columns ("Month, Revenue, Costs") make series data: lines, areas, combos. And three columns of source, target and amount ("Salary, Savings, 800") make flow data: a sankey.

Step 2 — Clean the two things that break imports

You rarely need to clean much, but two things trip every importer: currency symbols with thousands separators ("$1,200.50" — keep it, good importers strip it) and merged or multi-row headers from Excel exports (flatten them to one header row). Delete summary rows like "Total" at the bottom — the chart computes its own totals.

Step 3 — Upload and let the columns map themselves

In MakeCharts, open the editor, pick your chart type and hit Upload CSV in the configuration panel — Excel files work too. Rows become bars, slices, points or flows depending on the type. If the result looks wrong, you probably picked a shape the data is not in: a two-column file cannot feed a multi-series line chart.

Step 4 — Refine by asking, not clicking

Once the data lands, the fastest edits are sentences: "sort the bars", "make the costs red", "shorten the labels to three letters", "add a title that says where the money went". The AI applies each change to the canvas and you undo anything you dislike.

Step 5 — Export and repeat next month

Export SVG for slides and print or PNG for docs and chats — watermark-free on paid plans. Save the chart to the cloud: next month's CSV pastes over this month's data and the styling survives, which turns a recurring report into a two-minute job.

• Label + value columns → bars, pie, treemap, funnel.
• Label + several numeric columns → line, area, stacked area, combo.
• Source + target + amount → sankey.
• Delete "Total" rows before importing; keep currency symbols if you must.