Tableau Prep alternative: clean CSV files for free — Trusty CSV

tableau prep alternative

A Tableau Prep alternative for cleaning CSV files

Tableau Prep is built for flows that feed Tableau: it comes with a Creator licence, you build a flow of steps, look at a sample of your data and write a new output. If what you have is CSV files and what you need is clean CSV files, Trusty CSV does it in your browser, for free, on every row, in the file itself.

Clean a file now

or try it with

world-cities.csv

free no licence nothing uploaded

why switch

What changes when you clean in Trusty CSV

Free, on any computer. No licence and no annual contract, nothing to install: it runs in the browser, on Windows, macOS or Linux.

Every row, not a sample. You clean the rows themselves, all of them, each column in its colour and lined up.

No flow to build. Open the file, clean it, save it. It keeps its delimiter, quotes, encoding and line breaks, and changes only where you changed it.

Problems found for you. Quality Check reads the whole file and lists 32 kinds of problems in the order to fix them, most with a one-click fix.

Hand edits at the speed of a code editor. Multiple cursors, a whole column at once, find and replace inside a column, rows and columns moved with a key.

side by side

Trusty CSV and Tableau Prep

trusty-csv-and-tableau-prep.csv

aspect Trusty CSV Tableau Prep
price Free in the browser. With a Tableau Creator licence: $75 per user per month on Standard, billed annually.
runs on Any modern browser; a desktop app for Windows, macOS and Linux is on its way. Windows and macOS.
what you edit The file itself. Saving keeps its format. A flow of steps, with an output written as a new file, an extract or a table.
what you see Every row of the file, coloured and lined up. A sample while you build the flow (by default, up to 393,216 rows); all of them when it runs.
titles above the table Found when the file opens and removed with one click; a header written on several rows joined into one. You set the header row and the row where the data starts, in the input step.
finding problems 32 kinds found for you, most with a one-click fix. The profile pane of each step.
editing by hand Type anywhere, multiple cursors, a whole column at once. Values edited in the profile of a clean step.
similar values Yes: same words, same letters, similar spelling, same sound. Yes: by hand, pronunciation, common characters, spelling.
reshaping Yes: columns to rows and back, swap rows and columns, summarize. Yes: Pivot and Aggregate steps.
combining files Yes: append rows, join two files. Yes: Union and Join steps.

vocabulary

What you do in Tableau Prep, in Trusty CSV

The steps you build a flow with have their place in Trusty CSV, in the menu named after what they change.

tableau-prep-to-trusty-csv.csv

in Tableau Prep in Trusty CSV
Input step: Set as header, Set as data start Remove Them, in the notice when the file opens; Rows › Delete Rows Above the Cursor; Columns › Header Names › Join Header Rows…
Clean step: the profile pane View › Column Profile, and Table › Quality Check
Clean step: Group Values Cells › Group Similar Values…
Clean step: Split Columns › Split Column…
Clean step: Keep Only, Exclude Columns › Filter…, then Rows › Remove Rows Hidden or Shown by Filter
Clean step: Make Uppercase, Trim Spaces… Cells › Change Case, Cells › Whitespace
Pivot: columns to rows Table › Columns to Rows…
Pivot: rows to columns Table › Rows to Columns…
Aggregate step Table › Summarize…
Join step Table › Join with Another Tab…
Union step Table › Append Rows from Other Tabs…
Output step File › Save, or Save As in CSV, TSV, Excel, ODS, JSON, SQL, Markdown or HTML

fair to say

When Tableau Prep is still the tool

Trusty CSV is for CSV files: you open one, clean it and save it. Tableau Prep is for pipelines that end in Tableau, and if that’s your work, it’s still the one to use:

Data in databases. Tableau Prep connects to them, and can write its output back to a table.

The same steps on new data. A flow runs again on next month’s data. Trusty CSV can’t repeat a list of steps yet.

Output for Tableau. Extracts and published data sources for Tableau Desktop and Cloud.

Scripts and predictions in R or Python, as steps of the flow.

For a CSV that has to come out clean, and still be a CSV, Trusty CSV is the shorter way, and the free one.

Clean a file now

What else Trusty CSV does

Compared on 13 November 2026, from Tableau’s own pages: pricing (the Creator licence that includes Tableau Prep Builder) and technical specifications , read on 12 November, building a flow , configuring the data set (the data sample, the header and data start rows), cleaning and shaping data and saving the output .

Tableau Prep changes, and so does Trusty CSV. If something here is out of date, write to hello@calmly.studio and we’ll correct it. See also Trusty CSV and OpenRefine .

Clean a file now

or try it with world-cities.csv

What else Trusty CSV does

pricing

technical specifications

building a flow

configuring the data set

cleaning and shaping data

saving the output

Trusty CSV and OpenRefine