1. Home
  2. Spreadsheets & Data
  3. CSV to Chart

CSV to Chart

Make bar, line and pie charts from CSV or Excel data and save as PNG.

Runs in your browser · No upload

Loading…

Your data is processed in this browser and never uploaded.

How to use

  1. Paste CSV (a table copied from Excel works too) or drop a .csv, .tsv or .xlsx file. The first row is read as the header. Sample data is preloaded.
  2. Choose the chart type, the X axis column and one or more Y value columns. If the same X value appears several times, combine the rows with grouping (sum, average or count).
  3. Optionally change sorting, top N, titles, legend position, color palette, number format and data labels.
  4. Take it with Save PNG (1×, 2× or 3×, white or transparent background) or Copy image. The values behind the picture are available as Chart data CSV.

Choosing a chart type

You want to show Good chart Notes
Sizes of items compared Bar (vertical or horizontal) Horizontal bars read better when item names are long
How parts add up to a total Bar (stacked) Series are stacked so you see both the total and the make-up
A trend over time Line, Area With only a few points, straight lines are more honest than curves
Share of a whole Pie, Doughnut Best with 5–6 items or fewer; otherwise use top N plus Other
Relationship or spread of two numbers Scatter X and Y must both be numbers (or dates)
Two measures with different units Combo (bar + line) The first Y column is bars, the rest are lines. “Secondary axis” puts the lines on the right-hand scale

Grouping and top N

Rows with the same X value are combined into one item and calculated per Y column. Non-numeric values (n/a, blank cells) are left out of sum, average and count alike. For example, seven rows Apple 100, Pear 40, Apple 60, Orange 30, Grape 20, Pear 10, Orange n/a give:

Item Sum Average Count
Apple 160 80 2
Pear 50 25 2
Orange 30 30 1
Grape 20 20 1

Keeping the top 2 leaves Apple 160, Pear 50 and Other 50 (Orange plus Grape). Top N picks by the largest totals and the result follows that order. Note that with average or count grouping, “Other” is simply the sum of the remaining values. “No grouping” draws one point per row. With more than 500 items only the first 500 are drawn.

Color palettes and accessibility

There are six palettes. Colorblind-safe (Okabe-Ito) is a widely used set designed so series stay distinguishable with red-green color vision deficiency. Do not rely on color alone: use the legend, data labels and the data table under the chart. That table is a real <table> with the same values that screen readers can read. On screen, text and grid colors follow the site’s light or dark mode; the saved PNG is always drawn in light colors so it fits a white document.

Why there is no SVG export

The charts are drawn by chart.js, which renders to a canvas and cannot produce vector output. We chose not to add another library just for SVG, so the export format is PNG (up to 3×). For print, save at 3×.

Good to know

  • A pie chart draws only the first Y column, and negative values are drawn as 0 because they cannot be shown as slices.
  • The % number format only adds the sign (12.5 → 12.5%); it does not compute percentages.
  • Dates such as 2024-01-02 and 2024.1.2 are recognized, and a scatter chart with dates on X labels its ticks as dates.
  • For Excel files you can pick the sheet. Formula cells are read as their calculated values.

Related tools: Excel & CSV Workbench, Column Statistics, Percentage Calculator, JSON to CSV Converter

Your data and files are processed only in this browser and are never sent to a server.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.