ChartKitBETA

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,18

Chart 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=420

Markdown for a Notion page fed from Sheets

![Weekly funnel](https://getchartkit.com/api/chart?type=line&labels=W01,W02,W03&s0=120,140,135&s0name=Signups&format=svg&w=720&h=420)

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

Monthly Revenue

Copy

Show snippets
URL
https://getchartkit.com/api/chart?type=bar&labels=Jan,Feb,Mar,Apr,May&s0=12000,18000,15000,22000,27000&s0name=Revenue&title=Monthly%20Revenue&w=700&h=420&valueFormat=compact
HTML
<img src="https://getchartkit.com/api/chart?type=bar&labels=Jan,Feb,Mar,Apr,May&s0=12000,18000,15000,22000,27000&s0name=Revenue&title=Monthly%20Revenue&w=700&h=420&valueFormat=compact" alt="Monthly Revenue" width="700" height="420" />
Markdown
![Monthly Revenue](https://getchartkit.com/api/chart?type=bar&labels=Jan,Feb,Mar,Apr,May&s0=12000,18000,15000,22000,27000&s0name=Revenue&title=Monthly%20Revenue&w=700&h=420&valueFormat=compact)

How it works

  1. Freeze numbers (paste values) if formulas should not leak business logic.
  2. Keep thousands separators consistent - European decimals may need find/replace.
  3. 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.

More ChartKit tools