CSV Chart Maker

Paste or upload CSV and draw bar, pie, line, area, scatter, histogram, heat map and flow charts, pick the columns, then download the chart as SVG.

The interactive tool loads here when JavaScript runs.

About this tool

What is the CSV Chart Maker?

The CSV Chart Maker turns a table into a chart without a spreadsheet. Paste CSV with a header row or upload a .csv file, pick a chart type, choose which column goes on the X axis and which numeric column supplies the values, and the chart redraws as you change things.

There are eight views: bar, pie, line, area, scatter, histogram, a shaded heat map list, and a flow view that stacks values by source and target. Charts are drawn with Recharts as SVG, so the Download button saves a sharp .svg file you can drop into slides or docs. Copy Data puts the parsed rows on your clipboard as JSON.

It is built for quick looks at small and medium tables, not for dashboards. Each chart plots one value column, and parsing, drawing and export happen in your browser.

  • Eight chart views from one CSV table
  • RFC 4180 CSV parsing with strict number detection
  • Download the chart as a standalone SVG file
  • Six sample datasets to try each chart type
  • Color schemes, legend and grid toggles
  • Runs in your browser; data is not uploaded
Read the guide: Which Chart Should I Use? Bar, Line, Scatter, Histogram and Pie

Updated

How to use the CSV Chart Maker

  1. Paste CSV into CSV Data, click Upload to load a .csv file, or choose one of the sample datasets from the dropdown.
  2. Pick a chart type from the tabs above the chart: Bar, Pie, Line, Area, Scatter, Histogram, Heat Map or Sankey.
  3. Choose the X-Axis Column (categories or dates) and the Y-Axis Column (numbers). For the Sankey view, the Group By column is the flow target.
  4. Adjust Color Scheme, Show Legend and Show Grid in Chart Controls.
  5. Click Download to save the chart as an SVG file, or Copy Data to copy the parsed rows as JSON.

Worked examples

Monthly revenue as a line

Input

Date,Revenue,Users
2024-01-01,45000,1200
2024-02-01,52000,1450
2024-03-01,48000,1350

Output

Line chart with Date on the X axis (three labels) and Revenue on the Y axis.

Date is detected as text because 2024-01-01 is not a whole number, so it becomes the category axis. Revenue and Users are numeric and appear in the Y-Axis list.

Histogram of 0, 5 and 10

Input

Score
0
5
10

Output

Ten bins from 0-1 to 9-10; the first, sixth and last bins each hold 1 value.

The bin width is (10 - 0) / 10 = 1. The maximum, 10, lands in the last bin because that bin includes its upper edge.

Background and insight

A cell counts as a number only when the whole cell is numeric, so 2024-01-01 stays a date label on the X axis instead of being read as the number 2024, and quoted fields with commas such as "Jan, early" are parsed per RFC 4180. Columns with at least one number appear in the Y-axis list; columns with text are listed as categorical.

Picking the chart is mostly about the question. Comparing categories is a bar chart, change over time is a line, the relationship between two measures is a scatter, and the shape of one measure is a histogram. Research on graphical perception by Cleveland and McGill (1984) found that people judge position along a common scale more accurately than angle or area, which is why bars beat pies once there are more than a handful of slices.

The histogram uses ten equal-width bins from the minimum to the maximum, with the last bin closed on the right so the largest value is counted. Ten is a reasonable default for 50 to a few hundred values; with very few rows most bins will be empty, and that is a sign to use a dot or bar chart instead.

Common use cases

  • A quick chart for a status update

    Paste a few rows from a query result and download an SVG bar or line chart for a slide or a doc.

  • Eyeballing a distribution

    Use the histogram to see whether response times or order values are skewed before picking a summary statistic.

  • Spotting a relationship

    Plot two numeric columns on a scatter chart to see whether price and rating, or spend and signups, move together.

  • Teaching chart choice

    Switch the same data between chart types to show why a line suits a time series and a pie does not.

Tips and limitations

  • Numbers with thousands separators or currency symbols, such as 1,200 or $45, are read as text. Strip them before pasting.
  • Switching chart type swaps in a matching sample only while you are still on sample data. Your own pasted or uploaded CSV is never replaced.
  • The pie chart draws one slice per row. Aggregate first if a category appears in several rows.
  • The heat map view shades the first 10 rows, darkest for the largest value. It is HTML rather than SVG, so Download does not apply to it.
  • The Sankey tab is a stacked bar view of flows by source with a list of the first eight flows, not a true node-link Sankey diagram.
  • The data preview shows the first 10 rows; every row is still used in the chart.

Sources and further reading

  1. Graphical Perception: Theory, Experimentation, and Application to the Development of Graphical Methods, Journal of the American Statistical Association. Cleveland and McGill, 1984, on why position beats angle and area
  2. RFC 4180: Common Format and MIME Type for Comma-Separated Values (CSV) Files, IETF. The quoting rules the CSV parser follows

Frequently asked questions

How do I make a chart from a CSV file without Excel?

Upload the .csv or paste its contents into CSV Data, pick a chart type, then choose an X-axis column and a numeric Y-axis column. The chart draws immediately, and Download saves it as an SVG image you can insert into slides or documents.

Why is my numeric column not listed for the Y axis?

Only cells that are entirely numeric count as numbers. Values with commas as thousands separators, currency symbols, percent signs or units such as 12ms are treated as text. Remove those characters and the column will appear.

Which chart type should I use for my data?

Match it to the question: bar for comparing categories, line or area for change over time, scatter for the relationship between two measures, histogram for the spread of one measure. Use a pie only for a few parts of one whole.

What format does the chart download in?

SVG. It is a vector image, so it stays sharp at any size and can be edited in Figma, Illustrator or Inkscape. Most slide and document tools accept SVG directly; convert it to PNG if yours does not.

How many bins does the histogram use?

Ten equal-width bins between the smallest and largest value. Empty cells and non-numeric values are skipped, and if every value is the same the chart shows a single bar.

Is my CSV data uploaded when I make a chart?

No. The CSV is parsed and charted in your browser, and the SVG download is created locally, so nothing is sent to a server.

Is there an in-depth guide to the CSV Chart Maker?

Yes. “Which Chart Should I Use? Bar, Line, Scatter, Histogram and Pie” covers the background, how it works, common pitfalls and worked examples. Read the full guide.