Google Sheets chart generator
Sheets is the source of truth; ChartKit is the lightweight image host. Export a comma-separated slice, paste below, apply, copy embeds.
Sheets → CSV → ChartKit
In Google Sheets, select the table - including header row - then File → Download → Comma Separated Values (.csv). Open the file, copy text, paste into ChartKit’s CSV box.
Live spreadsheet links are not fetched automatically; you control exactly which rows ship publicly.
Alternatives: table to chart for other sources, CSV to chart for the same importer with CSV-first wording.
Use cases
- Finance models where only the summary tab should become a graphic.
- Marketing cohort tables that update weekly - you re-download CSV when numbers freeze.
- Shared drives where Sheets access is wide but blog CMS access is narrow.
Examples
Sheet layout
Week,Signups,Paid
W01,120,12
W02,140,15
W03,135,18Chart URL after import + type selection
https://getchartkit.com/api/chart?type=line&labels=W01,W02,W03&s0=120,140,135&s0name=Signups&s1=12,15,18&s1name=Paid&title=Weekly+funnel&legend=true&format=svg&w=720&h=420Markdown for a Notion page fed from Sheets
Import Sheet CSV
Adjust fields and copy URL, HTML, Markdown, or an AI prompt. See the [URL parameters](/docs/url-parameters) reference if you are editing links by hand.
Paste CSV
First column becomes labels; remaining columns become series (header row used for names).
Preview
Copy
Show snippets
How it works
- Freeze numbers (paste values) if formulas should not leak business logic.
- Keep thousands separators consistent - European decimals may need find/replace.
- Prefer PNG if your downstream tool mishandles SVG from Sheets-heavy teams on Windows.
Use with ChatGPT or Claude
Apps Script can concatenate CSV strings; an LLM can format them into ChartKit URLs.
Pair with chart from prompt when analysts talk to Claude inside Workspace add-ons.
FAQ
- Does ChartKit connect to my Google account?
No OAuth here - only pasted CSV text.
- Can I automate refresh?
Use scripts you control to POST/GET ChartKit; this page is manual.
- Markdown embed?
Yes once you have the URL.
- Email charts?
See charts for email - PNG often wins.
- Free?
Public chart generation is available for trials.