usefulweb.site CSV/Excel Chart Studio

Charts & data

CSV/Excel Chart Studio

Turn CSV, TSV or Excel data into line, bar, pie, scatter or histogram charts with SVG/PNG export.

CSV/TSV/TXT or .xlsx, max 20 MB. The format is detected from the content. Old .xls files: save as .xlsx first.

Comma-, semicolon-, tab- or pipe-separated, first row = headers. Used when no file is uploaded.

Sheet name or number; default: the first sheet.

Column name, letter (A, B …) or number. Empty: first date or text column.

One or more column names, comma-separated. Empty: the numeric columns. No numeric column: rows are counted.

Optional: split the first Y column into one series per value of this column (e.g. Region) – ideal for stacked bars.

0 = all (very long category lists are cut automatically).

0 = automatic (Sturges’ rule).

Try an example: Revenue by month, stacked by region · Monthly orders as a line (repeated months summed) · Share of revenue by region (pie)

How it works

Upload a CSV, TSV or XLSX file (up to 20 MB) or paste a table. The studio detects numbers, dates and categories, lets you pick the chart type, X/Y columns, a grouping column, aggregation (sum, average, count …), sorting and top-N, and returns an accessible SVG chart with SVG and PNG downloads plus the data table behind it.

  • The upload is identified by its content: XLSX (a ZIP container) is unpacked with a built-in reader (shared strings, number formats for dates, cached formula values of the chosen sheet); everything else is read as UTF-8 text (Windows-1252 as fallback) and split with the delimiter that gives the most consistent column count.
  • Each column is classified as number, date or text when at least 90 % of its non-empty cells parse that way. Numbers may use thousands separators, a decimal comma (detected per column), currency signs, percent signs and (123) for negatives. Day/month order of dates like 03/04/2026 is detected per column; when the data never disambiguates it, day-first is assumed and stated.
  • For bar, stacked, pie, line and area charts, rows with the same X value are combined with the chosen aggregation (automatic = sum). With a group column, the first Y column is split into one series per group value (at most 8; the rest become "Other"). Top N keeps the categories with the largest totals.
  • Charts are drawn by the site’s own SVG library: colour-blind-safe Okabe–Ito colours plus dash patterns or marker shapes, a text alternative, and the data table below. PNG images are rendered from the same SVG at 2× resolution with ImageMagick.
  • Very large inputs are reduced for drawing only: lines with more than 2,000 points show bucket averages, scatter plots with more than 5,000 points show every n-th point; the table and CSV keep all values.

Check that the detected column types and the aggregation match your data before publishing a chart.

For scripts and AI agents

  • JSON API: POST https://csvexcelchartstudio.usefulweb.site/api/v1/calculate (same calculation as this page)
  • Interface description: OpenAPI 3.1 · AI guide: llms.txt
  • MCP server (Streamable HTTP): https://csvexcelchartstudio.usefulweb.site/mcp · tool name csv_excel_chart_studio
Example request
curl -s -X POST https://csvexcelchartstudio.usefulweb.site/api/v1/calculate \
  -H 'content-type: application/json' \
  -d '{"data":"Month,Region,Revenue,Orders\n2026-01,North,12400,310\n2026-01,South,9800,250\n2026-02,North,13900,342\n2026-02,South,10150,262\n2026-03,North,15100,371\n2026-03,South,11800,290\n2026-04,North,14650,355\n2026-04,South,12900,301","chartType":"stacked","x":"Month","y":"Revenue","group":"Region","png":false}'

Related tools

  • Embeddable Chart Builder – Make a self-contained chart to embed anywhere: inline SVG, standalone HTML, accessible snippet.
  • Time-Series Explorer – Resample, smooth and decompose date/value data: trend, R², seasonality, YoY change and anomalies.
  • Geo Data Visualizer – Map CSV coordinates or GeoJSON as points, proportional circles, hex-bin heatmaps or choropleths.
Feedback