How to Clean, Transform and Chart a CSV Online, Step by Step

Clean a CSV one step at a time, see the data after every step, then turn the result into a chart or pivot table without opening Excel.

Open the Chart and pivot table builder

Short answer: open Data Transformation, load your CSV, add the clean-up steps one by one while checking the data after each step, then open the chart and pivot builder under the result to make a bar, line, scatter or histogram chart or a pivot table. Download the chart as a PNG or SVG. It is free and everything runs in your browser.

Step 1: Load your file

Open Data Transformation and drop in a CSV, Excel, JSON or Parquet file, or use Load sample to try it. A second file is only needed if you want to join two files. Your file is read in your browser and is never uploaded.

Step 2: Add the clean-up steps

The Add a transformation menu groups the 23 steps so you can find them: combine files and columns, clean text, columns, rows, types and dates, and calculate and summarize. On a new recipe you also get one-click tiles for the most common steps: trim spaces, filter rows, remove duplicates, sort, change a date format and join.

  • Clean text: trim spaces, change case, find and replace, remove accents or hidden characters, extract a number or email, pad IDs with zeros.
  • Rows: filter, remove empty rows, remove duplicates, sort, fill empty cells, keep the first or last rows.
  • Columns: rename, remove, reorder, split one column into several, join columns into one.
  • Types and dates: change a column to text, number, true/false or date, and change how dates are written.
  • Calculate: add a calculated column, round numbers, and group and summarize with count, sum, average, smallest or largest.

Step 3: Check the data after each step

Every step has a Show data after this step button that opens a small preview inside the step. That means you can see exactly what the trim, the filter or the join did without scrolling to the bottom. Each step also shows how many rows it leaves and how many it removed, for example 850 rows (−150), so a step that removes more than you expected stands out at once.

A step that is missing details is marked Needs details, and a step that cannot run shows an error and stays open. For long recipes you can fold steps to one line, copy a step with the duplicate button, move steps up and down, and undo a removal.

Step 4: Make a chart from the result

Under the result, open the chart and pivot builder. Choose a chart type and the columns:

  • Bar: totals or averages per category, optionally split by a second column.
  • Line: a value over time, with dates grouped by day, month or year.
  • Scatter: two number columns against each other, optionally split by up to three groups.
  • Histogram: how the values in one number column are spread out.

Hover over any bar, point or line to see the exact values, switch to View as table to read the numbers, and download the chart as a PNG or SVG, or copy it as an image to paste into a document or slide. If there are too many categories, the chart shows the top ones and groups the rest as Other, and it tells you when it has done that.

Step 5: Build a pivot table

Switch the builder to Pivot table. Pick a column for the rows, an optional column for the columns, a number column to summarize and how to calculate it. You get row and column totals and shaded cells, and you can download the pivot as CSV or Excel.

Step 6: Reuse or share the work

  • Run SQL on the same files with SQL on Your Files, then chart that result in the same way.

What this is good for, and what it is not

It suits quick exploration, clean-up before a report, students working on a dataset, and analysts who want a chart without opening Excel. It is not a dashboard tool: there is one chart at a time, one vertical axis, and no live connections to databases. Very large results are summarized or sampled, and the chart says so.

Open the Chart and pivot table builder

Related tool pages

Also try

How to use the Chart and pivot table builder: step by step

  1. Open Data Transformation and load a file.
  2. Add your clean-up steps and check the data after each one.
  3. Open the chart and pivot builder under the result.
  4. Choose a chart type and columns, then download the PNG or SVG.

When to use the Chart and pivot table builder

  • Clean a messy export before a report
  • Make a quick chart from a CSV without a spreadsheet
  • Build a pivot table to summarize sales or survey data
  • Check each clean-up step on a student dataset

Example

Input: sales.csv (region, month, amount)

Output: bar chart of amount by region, as PNG or SVG

Frequently asked questions

How do I clean a CSV file online for free?

Open Data Transformation, load your file, and add steps such as trim spaces, filter rows, remove duplicates or change a date format. Check the data after each step, then download the result. It is free and runs in your browser.

Can I see what each step did to my data?

Yes. Each step has a Show data after this step button that opens a preview inside the step, and a badge shows how many rows the step leaves.

How do I make a chart from a CSV without Excel?

Clean or load your data in Data Transformation, open the chart and pivot builder under the result, choose a bar, line, scatter or histogram chart and the columns, then download it as a PNG or SVG.

Can I build a pivot table online?

Yes. Choose a column for rows, an optional column for columns, a number column to summarize and how to calculate it (sum, average, count, smallest or largest). It adds totals and downloads as CSV or Excel.

Is my data uploaded when I chart it?

No. Charts and pivot tables are drawn in your browser and your file is never sent to a server.

What chart types are available?

Bar (single or grouped), line, scatter and histogram, plus a pivot table.

Can I save the chart as an image?

Yes. Download it as a PNG or SVG, or copy it as an image to paste into a document or slide.

What happens with a very large file?

Charts group extra categories as Other and sample very large scatter plots, and the chart tells you when it does. Pivot tables show up to 200 rows and 30 columns.

Tip: Use Show data after this step on a join or a filter to confirm it kept the rows you expected.