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.
freeno licencenothing 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
| 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.
| 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.
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.