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

trusty-csv-and-tableau-prep.csv
aspectTrusty CSVTableau Prep
priceFree in the browser.With a Tableau Creator licence: $75 per user per month on Standard, billed annually.
runs onAny modern browser; a desktop app for Windows, macOS and Linux is on its way.Windows and macOS.
what you editThe 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 seeEvery 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 tableFound 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 problems32 kinds found for you, most with a one-click fix.The profile pane of each step.
editing by handType anywhere, multiple cursors, a whole column at once.Values edited in the profile of a clean step.
similar valuesYes: same words, same letters, similar spelling, same sound.Yes: by hand, pronunciation, common characters, spelling.
reshapingYes: columns to rows and back, swap rows and columns, summarize.Yes: Pivot and Aggregate steps.
combining filesYes: 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 Prepin Trusty CSV
Input step: Set as header, Set as data startRemove Them, in the notice when the file opens; Rows › Delete Rows Above the Cursor; Columns › Header Names › Join Header Rows…
Clean step: the profile paneView › Column Profile, and Table › Quality Check
Clean step: Group ValuesCells › Group Similar Values…
Clean step: SplitColumns › Split Column…
Clean step: Keep Only, ExcludeColumns › Filter…, then Rows › Remove Rows Hidden or Shown by Filter
Clean step: Make Uppercase, Trim Spaces…Cells › Change Case, Cells › Whitespace
Pivot: columns to rowsTable › Columns to Rows…
Pivot: rows to columnsTable › Rows to Columns…
Aggregate stepTable › Summarize…
Join stepTable › Join with Another Tab…
Union stepTable › Append Rows from Other Tabs…
Output stepFile › 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.