CSV to chart — make a chart from your data
Drop a CSV or Excel file, pick the columns, and get a clean chart you can download as PNG or SVG. Totals, averages and counts are calculated for you, in your browser. Nothing is uploaded.
Click to upload or drag and drop
Drop your CSV, Excel, or JSON file
Max 10MB
No file handy? (made-up data)
Runs 100% in your browser — this page makes no network request with your data.
- 1
Drop a .csv, .tsv, .xlsx or .xls file, or try the sample store orders.
- 2
Pick a chart type, the column with the labels, and up to four value columns. Choose sum, average or count when labels repeat.
- 3
Download the chart as PNG or SVG, or the summarized numbers as CSV. Want AI to decide what is worth charting? Send the file to the workspace.
To make a chart from a CSV file, drop the file into the tool above, pick the column that holds the labels and the column that holds the numbers, and download the chart as PNG or SVG. When labels repeat, as they do in any list of orders or transactions, the tool adds up, averages or counts the values for each label first, so a long export becomes one clear bar per region or month. Everything runs in your browser; the file is not uploaded.
Pick the chart that answers your question
Start from the question, not the chart type. The table below maps the common ones to a setup in the tool.
| Your question | Chart | Set it up like this |
|---|---|---|
| Which category is biggest? | Bar or horizontal bar | Labels: the category column. Calculation: sum. Order: largest first |
| How did it change over time? | Line or area | Labels: the date or month column. Order: by label for ISO dates (2026-01-31), or as in the file if it is already in date order |
| What share does each part take? | Pie or donut | Labels: the category. Calculation: sum. The 6 largest slices are shown and the rest grouped as Other |
| Do two numbers move together? | Scatter | Horizontal axis: one numeric column. Vertical axis: another |
| How many rows per category? | Bar | Calculation: count rows. No value column needed |
Sum, average or count: summarizing rows before charting
Most exports have one row per event: an order, a ticket, a payment. Charting them row by row gives you hundreds of bars with the same label. The calculation setting groups the rows by the label column first.
Take an order export with columns date, channel and revenue. Sum of revenue by channel gives total revenue per channel. Average of revenue by channel gives the average order value per channel. Count rows by channel gives the number of orders. No grouping plots one point per row, which suits data that is already one row per period.
Empty cells are skipped, so they never count as zero in an average. Values written as "$1,200", "1,200" or "12.5%" are read as numbers; text that is not a number is ignored. "Show the numbers" lists the exact figures behind the chart, and you can download them as a CSV to check the chart against the file.
Making a chart from a CSV in Excel or Google Sheets
Spreadsheets chart well once the data is summarized. In Excel, open the CSV, select the label and value columns, and use Insert → Recommended Charts. If labels repeat, build a PivotTable first (Insert → PivotTable) and chart that. In Google Sheets, import the CSV with File → Import, select the columns, and use Insert → Chart; for repeated labels, total them with a pivot table (Insert → Pivot table) first.
The extra steps are the summarizing and the import itself, which can reformat values on the way in: leading zeros disappear and some codes become dates. This tool reads the file as it is, summarizes it for you, and leaves the original untouched.
Exporting the chart: PNG, SVG and the data
Charts are drawn with the same chart engine and color themes that AnalyzeData uses in its reports, and no watermark is added to what you download.
- PNG is a picture at twice the on-screen size, sharp enough for slides, documents and chat messages.
- SVG is a vector file: it stays sharp at any size, and the shapes and text can be edited in Figma, Illustrator or Inkscape.
- Chart data (CSV) is the summarized table behind the chart, ready to paste into a report or check by hand.
When to let AI pick the charts
This tool is fastest when you already know the question. When you do not, or the file has dozens of columns, send it to the workspace: the analysis there runs real Python over the file, chooses the charts that show something worth seeing, writes the findings, and turns them into a report you can share. AI data visualization explains how that chart choice works.
Frequently Asked Questions
Everything you need to know about using AnalyzeData.
Bar charts compare categories (sales by region). Line and area charts show change over time (revenue by month). Pie and donut charts show parts of a whole and work best with a handful of slices. Scatter plots show whether two numbers move together (ad spend against sales). The tool starts with a bar chart of your first numeric column, summed by the label column with the fewest distinct values; change any of it in one click.
Yes. Drop an .xlsx or .xls file and the first sheet with data is charted the same way as a CSV. To chart a different sheet, convert it with the Excel to CSV converter first.
Files up to 10MB open. Rows are grouped by the label column before drawing, so a 50,000-row file of orders becomes one bar per region or month. A chart shows at most 500 points: bar and pie charts keep the top (or first) categories, line charts are evenly sampled, and the tool says when either happens.
Choose Line, set the labels to the date column, and set the order. ISO dates such as 2026-01-31 sort correctly by label; dates like 01/15/2024 sort by month first, so if the file is already in date order, choose "As in the file". Use Sum if several rows share a date.
Yes. Bar, line and area charts take up to four value columns, each drawn as its own series with a legend. Pie, donut and scatter charts use one value column.
A chart shows at most 500 points so it stays readable. Bar and pie charts keep the top or first categories you choose, line charts are evenly sampled across the file, and a scatter plot leaves out rows that do not have numbers in both columns. Each of these is stated under the chart.
Yes. There is no signup, no limit on how many charts you make, and no watermark on the PNG or SVG you download.
More free data tools
Each one runs entirely in your browser, with no upload and no signup.
- CSV viewerOpen CSV files online as a sortable table
- Excel viewerOpen .xlsx and .xls files without Office
- Large CSV viewerOpen CSV files too big for Excel
- Excel to CSV converterConvert .xlsx sheets to CSV, and back
- CSV splitterSplit a large CSV into smaller files
- Merge CSV filesCombine several CSVs into one
- CSV editorFix values without Excel reformatting
- Word frequency counterTop terms and counts in any text
- Sentiment analysisScore reviews and survey answers
When a table isn't enough
The workspace runs verified AI analysis on the same file and turns the results into a report you can send.
Analyze this data instead