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

> Clean a CSV step by step, preview the data after each step, then make a chart or pivot table and download it as PNG or SVG. Free, nothing is uploaded.

Page: https://datautility.in/blog/clean-transform-chart-csv-online-step-by-step
This is the Markdown copy of the page. The tool itself runs in the browser: your files are processed on your own device and are not uploaded.

Published 2026-11-14 · Analyze & protect · clean csv online, make a chart from csv, pivot table online, data transformation tool, csv to chart, online data cleaning tool, visual data transformation tool, chart without excel

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 tool: [Chart and pivot table builder](https://datautility.in/csv-chart-and-pivot-table-online)

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](https://datautility.in/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

- Export the whole recipe as [DuckDB SQL, pandas, PySpark or a dbt model](https://datautility.in/blog/export-data-cleaning-steps-as-sql-pandas-pyspark-dbt-code).

- [Share the steps with a link](https://datautility.in/blog/share-data-transformation-steps-with-a-link) that holds only the steps, never your data.

- Run SQL on the same files with [SQL on Your Files](https://datautility.in/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.

## 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.

## Related tool pages

- [Data Transformation: Join, Trim, Concatenate](https://datautility.in/data-transformation): Join two CSV or Excel files on a key, then trim, filter, sort, calculate and group. Pick your steps and download the result. Free, in your browser.
- [Share a Data Transformation With a Link](https://datautility.in/share-data-transformation-recipe): Build a data clean-up in your browser and share the steps with a link. It holds only your steps, never your data. Free, no sign-up, nothing uploaded.
- [Export Data Cleaning Steps as SQL, pandas or PySpark Code](https://datautility.in/export-data-cleaning-recipe-as-code): Clean or join a CSV in your browser, then export the steps as DuckDB SQL, pandas, PySpark or a dbt model. Free and private.
- [Delete Columns from a CSV File](https://datautility.in/delete-columns-from-csv): Remove one or more columns from a CSV or Excel file and download the result. Free, in your browser, and your file is never uploaded.
- [Reorder Columns in a CSV File](https://datautility.in/reorder-csv-columns): Drag columns into a new order, or send a column to the start or the end, in a CSV or Excel file. Free, in your browser, nothing is uploaded.
- [Remove Empty Rows and Columns from CSV](https://datautility.in/remove-empty-rows-from-csv): Remove rows with empty cells, rows that are completely empty, or columns with no values from a CSV or Excel file. Free, in your browser.

## Also try

- [Data Transformation](https://datautility.in/data-transformation)
- [Share steps with a link](https://datautility.in/blog/share-data-transformation-steps-with-a-link)
- [Export steps as code](https://datautility.in/blog/export-data-cleaning-steps-as-sql-pandas-pyspark-dbt-code)
- [SQL on your files](https://datautility.in/sql-on-your-files)
- [Remove duplicates](https://datautility.in/remove-duplicates-from-csv)

## More guides

- [Data Profiler: Check Data Quality Before You Use It](https://datautility.in/blog/data-profiler-check-data-quality)
- [Compare Two CSV or Excel Files: Find Added, Removed and Changed Rows](https://datautility.in/blog/compare-two-csv-files-find-differences)
- [Data Masking: Hide Emails, Phones and Names Before Sharing](https://datautility.in/blog/data-masking-hide-emails-phones-pii)
