Big CSV Tools

Dedupe, compare, merge, split and profile CSV or TSV files that are too big to paste into a chat.

Add to Claude Read the docs

Big CSV Tools works on CSV and TSV files that are given as public URLs. A file is read in ranges and processed in small batches, so it does not have to fit in a chat message or in memory. Five operations are available: remove duplicate rows by chosen columns, compare two files by a key column (added, removed and changed rows with the changed columns), join two files on a key (inner, left or full), split a file by number of rows or by the value of a column, and profile a file (row count, columns, empty percentage, distinct count estimate, sample values).

Results are hosted as CSV download links that expire after 7 days. Quoted fields with commas and line breaks, a byte order mark and CRLF line endings are handled. XLSX files: save as CSV first.

Example prompts

Remove duplicate rows from https://example.com/contacts.csv by the email column, keep the first one, and give me the download link.
Compare https://example.com/prices-old.csv with https://example.com/prices-new.csv by the sku column and tell me what was added, removed and changed.
Split https://example.com/orders.csv into one file per country.
Profile https://example.com/export.csv: how many rows, which columns are mostly empty, how many distinct values per column?

Add it to Claude

  1. In Claude, open Settings, then Connectors, then Add custom connector.
  2. Enter the URL https://bigcsv.tidybutton.com/mcp and save.
  3. Choose Connect. A sign-in page asks for your email address and sends a six digit code. No password is needed.

Plans

Free

$0
  • 3 jobs per month
  • Files up to 10,000 rows
  • Hosted CSV downloads for 7 days

Pro

$12 per month
  • 100 jobs per month
  • Files up to 1,000,000 rows
  • Hosted CSV downloads for 7 days

Details on the pricing page.