How to Create Interactive Charts with Datawrapper

What Datawrapper Does and Why It Matters

Datawrapper lets anyone turn spreadsheet data into publication-quality interactive charts, maps, and tables inside a web browser. No code, no plugins, no desktop software required. You upload your numbers, pick a visualization, adjust the styling, and hit publish. The output is a responsive embed or a static PNG you can drop into a slide deck, email, or website.

More than 40,000 organizations rely on it for data communication, including newsrooms like Reuters, The New York Times, and the BBC, along with government agencies and NGOs. The reason is speed: a chart that takes 30 minutes in Excel or Google Sheets takes about 5 minutes in Datawrapper, and the result looks better on every screen size.

Step 1: Prepare Your Data

Datawrapper accepts data from three sources: copy-paste from a spreadsheet, CSV or Excel file upload, or a direct link to a Google Sheet. Before you start, make sure your data follows these rules.

Keep headers in the first row. Each column should have a short, descriptive label. Remove merged cells, subtotals, and any formatting that only makes sense in a spreadsheet. Datawrapper reads rows as data points and columns as variables, so your table needs to be "tidy" in the statistical sense: one observation per row, one variable per column.

If you are linking to a Google Sheet, the sheet must be publicly viewable (or "anyone with the link" sharing enabled). Datawrapper will pull fresh data from the sheet each time someone loads the chart, which makes this option useful for live dashboards.

A common mistake is leaving blank rows or columns in the data. Datawrapper will interpret those as empty data points and render gaps in your chart. Clean the source first.

Step 2: Choose the Right Chart Type

Datawrapper offers over 20 chart types across four categories: bar and column charts, line charts, area charts, scatter and bubble plots, pie and donut charts, tables, and maps. Picking the wrong one is the fastest way to confuse your reader.

Here is a practical decision framework. If you are comparing categories (revenue by product, headcount by department), use a horizontal bar chart. If you are showing change over time, use a line chart. If you need to show parts of a whole, use a stacked bar or a donut chart. If you are plotting two variables against each other, use a scatter plot. If your data is geographic, use a choropleth or symbol map.

Avoid pie charts for more than five categories. Research from the Cleveland and McGill perception studies (1984, cited over 7,800 times) shows that humans estimate angles poorly compared to lengths. A simple bar chart almost always communicates proportions more accurately.

For tables, Datawrapper offers a special interactive table format that supports inline bar charts (sparklines), color-coded cells, and search filtering. This is useful for leaderboards, pricing comparisons, or any dataset where the reader wants to look up a specific row.

Step 3: Upload and Verify

Go to datawrapper.de and click "Start creating." You do not need an account to create your first chart, though saving and editing later requires a free signup.

In the Upload Data step, paste your spreadsheet data into the text field or click "Upload CSV." Datawrapper will parse the data and show a preview table. Check that it correctly detected your headers and that numbers are recognized as numbers (not text strings). If a column shows left-aligned text where you expect right-aligned numbers, the source likely has currency symbols, commas, or extra spaces that need cleaning.

Click "Check & Describe" to add metadata. You can annotate individual columns with descriptions, set number formats (decimal places, thousands separators, currency symbols), and flag columns as categories or dates. This step is optional but improves the final output. Setting the date format correctly is critical for time-series charts: Datawrapper needs to know whether "01/02/2026" means January 2nd or February 1st.

Step 4: Customize the Visualization

The "Visualize" step has three tabs: Chart Type, Refine, and Annotate.

Under Chart Type, select your preferred visualization. You can switch types at any time without losing your data. Datawrapper will preview the result instantly.

Under Refine, adjust axis ranges, gridlines, sorting, and colors. For brand consistency, enter your company's hex color codes directly. If you are creating charts for a recurring report, set up a custom color palette once and reuse it across all your charts.

Under Annotate, add a title, description, source line, and optional annotations. Annotations are text labels you can pin to specific data points. They are powerful for calling out key numbers: "Q3 revenue hit $4.2M, up 18% from Q2" placed right next to the data point eliminates the need for a separate paragraph of explanation.

One practical tip: keep the title under 60 characters and make it a statement, not a label. "Sales grew 23% in Q1 2026" outperforms "Q1 2026 Sales Data" because it tells the reader the takeaway before they even look at the chart.

Step 5: Publish and Embed

Click "Publish." Datawrapper generates a responsive iframe embed code, a direct URL, and PNG/PDF export options. The embed code works in any CMS, email builder, or static HTML page. The chart automatically resizes to fit its container, so it looks correct on desktop and mobile without extra CSS.

If your data source is a linked Google Sheet, the published chart updates automatically whenever the underlying sheet changes. This is how newsrooms run live election trackers and COVID dashboards: one Google Sheet feeding multiple Datawrapper embeds.

For static exports, the free plan includes PNG. PDF and SVG exports are available on paid plans or free for verified academic users. The PNG export resolution is high enough for print at standard sizes.

Every embedded chart includes a "Created with Datawrapper" attribution on the free plan. Paid plans (starting at $599/month for teams) remove the watermark and add custom branding, team collaboration, and API access.

When Datawrapper Fits and When It Does Not

Datawrapper excels at speed and clarity for standard chart types. It is the right tool when you need a clean, interactive visualization in under 10 minutes and your data has fewer than 10,000 rows. Most business reporting falls squarely in this range.

It is not the right tool for highly custom or animated visualizations (Flourish or D3.js handle those better), real-time streaming data (you need a BI tool like Grafana or Sigma), or dashboards with multiple linked charts (Looker Studio or Power BI are better fits). For users who want to go from a raw file upload to analysis, statistical summaries, and charts in a single workflow, tools like VSLZ handle the entire pipeline from data ingestion through visualization with no manual chart configuration at all.

Practical Summary

Start with clean, tidy data in a spreadsheet. Open Datawrapper, paste the data, pick the chart type that matches your message, customize colors and annotations, then publish. The entire process takes 5 to 10 minutes. Bookmark the Datawrapper Academy (academy.datawrapper.de) for chart-type-specific guides, and use their "One Chart, Nine Tools" comparison page by Lisa Charlotte Muth to benchmark alternatives. For recurring reports, link to a Google Sheet so the chart stays current without manual updates.