How to Make a Chart from CSV Data

If your data already lives in a spreadsheet or a CSV file, you do not need to type it into a chart maker one value at a time. Every maker on the site has a Paste / CSV input that reads your rows directly, so going from raw numbers to a finished chart takes about a minute. The only thing that matters is getting the shape of the data right — and that comes down to two simple ideas: one row per data point, and a label-then-value order.

What CSV data looks like

CSV stands for "comma-separated values" — a plain-text way of storing a table where each line is a row and commas separate the columns. A spreadsheet is the same idea with a friendlier grid. For a basic chart you only need two columns: a label and a value. Each line becomes one bar, one slice, or one point.

Step 1: Prepare your data

Open your spreadsheet or CSV and tidy it into the label-then-value shape:

• Put the label in the first column and the number in the second — for example a category name, then its value.
• One row per data point. Remove blank rows, totals, and subtotals you do not want plotted, since the maker will treat each row as its own bar or slice.
• Keep values as plain numbers. Strip currency symbols and thousands separators where you can, so a value reads as 1500 rather than text the maker has to interpret.

If you have several series — say a value for two different years — you can keep extra value columns; line and bar makers can plot more than one. Start with the simple two-column case until you are comfortable.

Step 2: Choose the right maker

Match the maker to what you want the chart to show. Use the pie chart maker when your rows are parts of a single whole, the bar chart maker when you are comparing separate categories, and the line chart maker when your labels are time periods and you want to show a trend. If you are not sure which fits, the chart makers hub lists them all in one place.

Step 3: Paste your data in

Inside any maker, look for the Paste / CSV button. Clicking it opens a text box. Now go back to your spreadsheet, select the label and value cells, copy them, and paste them into that box. You do not have to convert anything to a file first — the makers accept data separated by commas, tabs, or spreadsheet columns, so a straight copy-paste from your sheet works. As soon as you paste, the chart updates to show your data.

Step 4: Handle the header row

A header row is the first line that names the columns, such as "Category, Value", rather than holding real data. If your pasted data starts with a header, switch on the option to treat the first row as a header so the maker uses it for labels instead of plotting "Category" as a data point with a value of zero. If your data has no header — it jumps straight into the first real row — leave that option off so no data point is skipped. A quick glance at the chart tells you which case you are in: a stray empty or mislabelled first bar usually means a header is being plotted by mistake.

Step 5: Review and export

Before you export, scan the chart against your source data: do the labels match, are the values in the right order, and did every row come through? Then add a title, label the axes if needed, and adjust colors. When it looks right, export it — every maker produces a PNG or SVG with no signup or watermark. If something looks off, the fix is almost always back in the pasted data: a stray blank row, a value that came through as text, or the header setting. Correct it in the box and the chart updates instantly.

That is the whole workflow: shape the data as label-then-value, paste it into the maker that fits, set the header row, and export. Once you have done it once, turning any spreadsheet into a clean chart becomes a one-minute job.