Free online tool

Join, filter, clean and pivot CSV files in your browser

Drop in two CSV files and this free tool blends them in your browser: join them on a shared column, filter the rows, clean up whitespace and duplicates, then group and pivot the result — and download the merged CSV. It is a no-install Alteryx alternative for the everyday job of combining spreadsheets: nothing is uploaded, nothing is stored, and every step shows its row count so you can see exactly what changed.

Quick answer

Quick answer

Load two CSV files and CSV Blend Studio joins them free in your browser — inner, left, or full outer on any shared key — then filters, cleans, and pivots the result, with row counts at every step and a merged CSV download. Nothing is uploaded, and duplicate keys multiply rows instead of dropping them.

Open the interactive CSV Blend Studio

The interactive tool loads in the page. Enable JavaScript to enter data, process content, and download results.

Worked example — the built-in sample

The built-in sample: 6 orders and 4 customers, joined on the customer column.

Inner join5 rows — $43.90 total (Ana 2, Ben 2, Cara 1)
Left join6 rows — Dana's order kept, region and segment blank
Full outer join7 rows — Eli added, order columns blank
Pivot by region (sum of amount)North $28.20 across 3 orders; South $15.70 across 2 orders
Pivot by region (average amount)North $9.40; South $7.85; overall $8.78
Duplicate keys2 key values repeat (Ana and Ben each appear twice in the orders file)
Rows droppedNone silently — the inner join drops Dana's unmatched order and says so in the counts

Join types — what each keeps (built-in sample)

Join typeKeepsSample result
InnerOnly rows with a match on both sides5 rows, $43.90
LeftEvery row from file A; blanks where B has no match6 rows — Dana kept, region blank
Full outerEvery row from both files7 rows — Eli added, order columns blank

Pivot by region — sum of amount (inner join)

RegionOrdersTotal amountAverage amount
North3$28.20$9.40
South2$15.70$7.85
Total5$43.90$8.78

About this tool

About the CSV Blend Studio

Drop in two CSV files and this free tool blends them in your browser: join them on a shared column, filter the rows, clean up whitespace and duplicates, then group and pivot the result — and download the merged CSV. It is a no-install Alteryx alternative for the everyday job of combining spreadsheets: nothing is uploaded, nothing is stored, and every step shows its row count so you can see exactly what changed.

Detailed guide

How to get useful results from CSV Blend Studio

What a free Alteryx alternative does in a browser

Alteryx is a paid data-prep platform: you connect sources, join and clean them in a visual workflow, and output a prepared table. Most people who search for it need only the middle of that workflow — take two CSV exports, join them on a customer or order ID, tidy the result, and summarise it. CSV Blend Studio does that middle, free, in a browser tab, with no install, no account, and no file ever leaving your device.

The trade-off is honest. A desktop data-prep platform handles dozens of sources, scheduled runs, and database connectors. This tool handles two CSV files at a time, up to 20,000 rows and 5 MB each, in one sitting. If your job is merging two exports from a shop, a CRM, or a survey tool, that is the whole job — and doing it in the browser means there is nothing to install, update, or pay for.

How the three joins work — and which one to pick

A join matches rows from two files on a shared column, called the key — a customer name, an order ID, a product code. An inner join keeps only rows that match on both sides: orders with a known customer and customers with an order. A left join keeps every row from the first file and leaves blanks where the second file has no match, so you can see which orders have no customer record. A full outer join keeps every row from both files, so unmatched customers show up too.

Pick inner when you only want matched pairs — for example, orders you can actually attribute to a region. Pick left when the first file is the truth and you want to find its gaps, such as orders missing from the customer list. Pick full outer when you want a complete inventory of both sides, including orphans. The tool shows matched and unmatched counts for each side before you download anything, so a wrong join type shows up as a surprising number, not a silent mistake.

Duplicate keys: why a join can make more rows than either file

The most confusing join behaviour is also the most honest one. If a customer appears twice in the orders file and once in the customers file, the join makes two rows — one per matching pair. If a key appears twice on both sides, it makes four. That is how joins work in every database and spreadsheet tool, and it is how this tool works too: duplicates are multiplied, never silently dropped.

The tool reports how many key values appear more than once, so a jump in row count is explained instead of surprising. If you did not expect duplicates, check the key column first: a trailing space, a different capitalisation, or a repeated ID in an export are the usual causes. Keys are trimmed of surrounding whitespace before matching, but “Ana” and “ana” are still different keys — matching is exact, and the tool says so rather than guessing.

Filtering and cleaning before you trust the result

A join is only the first step. The filter step keeps rows that pass every condition you set — for example, region equals North and amount greater than 10 — and reports how many rows were removed. Conditions combine with AND, text matches are case-insensitive for “contains”, and numeric comparisons only apply when both sides are numbers, so a text value in an amount column never quietly compares as zero.

Cleaning then trims whitespace from every cell, drops rows that are entirely empty, and removes exact duplicate rows, with a count for each. Filling empty cells is optional: leave the fill box blank and blanks stay blank, or type a value such as “—” or “Unknown” and every empty cell takes it. Each count is shown on screen, so the path from joined rows to final rows is fully visible.

Group-by and pivot: sums, averages and counts without a spreadsheet

The optional pivot step groups the cleaned rows by one column and aggregates another: count rows per group, or sum, average, minimum, or maximum of a numeric column. Group the sample join by region and sum the amount column, and you get North $28.20 across 3 orders and South $15.70 across 2 — the same numbers a spreadsheet pivot table would give, without opening a spreadsheet.

Non-numeric values in the value column are skipped and counted, not treated as zero — a missing amount should not drag an average down. Count needs no value column at all: group by product and count, and you learn how many Notebook rows the join produced. The pivot result downloads as its own CSV, separate from the merged file.

Reading the built-in sample — 6 orders, 4 customers

Press “Load sample CSVs” and the tool fills both files for you. File A has 6 orders: Ana bought a Notebook for $12.50 and a Pen for $3.20, Ben bought a Pen for $3.20 and a Notebook for $12.50, Cara bought a Notebook for $12.50, and Dana bought a Marker for $5.00. File B has 4 customers: Ana in the North, Ben in the South, Cara in the North, and Eli in the East.

The inner join on customer gives 5 rows totalling $43.90 — Dana has no customer row, so her order drops out, and Eli has no order, so he never appears. The left join gives 6 rows, keeping Dana with blank region and segment. The full outer join gives 7 rows, adding Eli with blank order columns. Pivoting the inner join by region with sum of amount gives North $28.20 and South $15.70, and the averages are $9.40 and $7.85.

What CSV Blend Studio cannot do

This is a two-file blend: it cannot join three or more files at once, so blend them in pairs and download the result between steps. It matches keys exactly after trimming whitespace, so “Ana” and “ana” are different customers and a misspelled key will not match — fix the spelling in the source file or with a filter, not by hoping the tool guesses.

It also works on the text in the files: it cannot repair a file whose quotes are unbalanced or whose header row is missing, and it caps each file at 20,000 rows and 5 MB so a browser tab stays responsive. Large exports should be split before blending. Everything runs in this tab; no row is uploaded or stored, and the download is the only copy that leaves the page.

Quick guide

How to use this tool

  1. 01Load or paste two CSV files, each with a header row — or press “Load sample CSVs” to try a join in one click.
  2. 02Choose the join type (inner, left, or full outer) and the key column in each file, then read the matched and unmatched counts.
  3. 03Add filter conditions if you need only some rows, and set a fill value if empty cells should take one.
  4. 04Turn on the pivot to group by a column and count, sum, average, or find the min or max of another.
  5. 05Download the merged CSV — or the pivot CSV — and check the row counts against your own files.

Capabilities

Features and supported formats

  • Robust CSV parser: quoted fields, commas inside quotes, multiline quoted values, CRLF endings, and doubled quotes.
  • Inner, left, and full outer joins on any shared column, with matched/unmatched counts and duplicate-key reporting.
  • Row filters with ten operators — equals, contains, greater than, less than, is empty, and more — combined with AND.
  • Cleaning that trims whitespace, drops empty rows, removes exact duplicates, and optionally fills empty cells — every count shown.
  • Group-by pivot with count, sum, average, min, and max; non-numeric values are skipped and counted, never treated as zero.
  • Preview tables with row counts at every step, one-click sample CSVs, and merged/pivot CSV download — all in the browser, nothing uploaded.

Supported formats

Input: two .csv or .txt files, each with a header row — up to 20,000 rows and 5 MB per file — or pasted CSV text. Output: a merged CSV (inner, left, or full outer join) and, optionally, a pivot CSV with one row per group.

Answers

Frequently asked questions

Is CSV Blend Studio a free Alteryx alternative?

For the everyday job, yes: it joins, filters, cleans, and pivots CSV files free in your browser, with no install and no sign-up. Alteryx is a paid platform with database connectors, scheduled workflows, and many sources; this tool covers the two-file CSV blend that most people actually need, and it costs nothing.

How do I merge CSV files online with this tool?

Load or paste two CSV files, pick the join type (inner, left, or full outer), choose the key column in each file — the column both files share, such as customer or order ID — and download the merged CSV. The matched and unmatched row counts are shown before you download, so you can check the join looks right.

How do I join CSV files for free?

There is nothing to pay or install. Open the tool, load your two files, choose the shared key column and a join type, and download the result. Everything runs in your browser tab: no upload, no account, and no row ever leaves your device.

What is the difference between inner, left, and full outer joins?

Inner keeps only rows that match on both sides. Left keeps every row from the first file, with blanks where the second file has no match. Full outer keeps every row from both files. In the built-in sample, inner gives 5 rows, left gives 6 (Dana's order kept, region blank), and full outer gives 7 (Eli the customer added too).

Can I make a CSV pivot table online here?

Yes. After the join, turn on the pivot, pick a group-by column and an aggregation — count, sum, average, min, or max. Grouping the sample join by region and summing amount gives North $28.20 and South $15.70. The pivot downloads as its own CSV.

What happens to duplicate keys in a join?

A key that appears more than once makes one output row per matching pair — twice on one side and once on the other gives two rows; twice on both sides gives four. The tool reports how many key values repeat, so the row count is explained. Rows are never silently dropped.

Does the tool upload my CSV files?

No. Files are read with the File API and blended only in your browser tab. Nothing is sent to a server, nothing is stored, and the only copy that leaves the page is the CSV you choose to download.

What CSV formats does the parser handle?

Quoted fields, commas inside quotes, multiline quoted values, CRLF and LF line endings, and doubled quotes inside quoted fields. Rows shorter than the header are padded with empty cells and longer rows are trimmed — both counts are shown on screen.

Can I filter rows before downloading?

Yes. Add up to three conditions — equals, does not equal, contains, does not contain, greater than, less than, is empty, is not empty — combined with AND. The tool shows how many rows the filter kept and how many it removed.

How does cleaning work — what gets removed?

Cleaning trims whitespace from every cell, drops rows that are entirely empty, and removes exact duplicate rows. Each step reports its count. Filling empty cells is optional: type a value such as “Unknown” or leave the box blank to keep them empty.

Can I blend CSV files in 2027 without installing anything?

Yes — the tool runs entirely in a modern browser, so there is nothing to install, update, or renew. Open the page, blend your files, and download the result. It works on desktop and mobile browsers, and the same steps apply whenever you use it.

What are the limits of CSV Blend Studio?

Two files at a time, up to 20,000 rows and 5 MB per file, and keys must match exactly after trimming whitespace — “Ana” and “ana” are different keys. It cannot repair unbalanced quotes or a missing header row. For three or more files, blend them in pairs.