GM.
  1. gibin.in
  2. Free tools
Free tools · no sign-up

Free data tools that never upload your data

Small tools for the jobs I keep doing by hand: matching messy lists, cleaning CSVs, checking data quality, testing scraper selectors. They all run in your browser, so your files stay on your machine.

Which tool do I need?

I have two lists of names that should match but are spelled differentlyFuzzy match → One column has the same thing spelled many ways (UK, U.K., United Kingdom)Value standardizer → My file has repeated rows or messy spacesRemove duplicates → Someone sent me a CSV and I want to know what's wrong with itCSV profiler → My dates are in different formats and won't sortDate normalizer → I got a .json file and need it in ExcelJSON to CSV → I need a CSV loaded into a databaseCSV to SQL → I want to know how much time or money automation savesFTE and savings calculator → I need to read or check a passport's MRZ linesMRZ parser → I'm writing a web scraper and need working selectorsSelector tester →
Nothing leaves your browser

The tools read your file on your own device. There's no server behind them, so there's nowhere to upload to.

Free, no account

No sign-up, no email gate, no row limit I make you pay to lift. Big files are limited only by your machine.

Built from real work

Each one comes out of a problem I've solved in production. The case study is linked on every tool page.

Free toolMatching

Fuzzy match two lists

tested on 20,000 × 20,000 rows

Paste two lists or upload CSVs. Every row gets its best match, a 0 to 100 score and a verdict. Works as a fuzzy VLOOKUP.

Open the toolFree toolCleaning

Standardize messy values to one master list

controlled vocabularies, by hand

Map UK, U.K. and Untied Kingdom onto United Kingdom. Exact, alias and fuzzy rules, and you decide the leftovers.

Open the toolFree toolCleaning

Clean a CSV or JSON file and remove duplicates

exact and near duplicates

Trim, strip invisible characters, blank out N/A, then drop exact or near-duplicate rows. CSV, JSON and JSON Lines.

Open the toolFree toolData quality

Check a CSV's data quality in seconds

14 checks per column

Every column profiled: real type, missing values, placeholders, outliers, mixed formats and IDs that repeat.

Open the toolFree toolConversion

Turn a CSV into SQL

4 SQL dialects

CREATE TABLE with inferred types and batched INSERTs for PostgreSQL, MySQL, SQLite and SQL Server. Leading zeros kept.

Open the toolFree toolConversion

Flatten nested JSON into a CSV

3 ways to handle arrays

Nested objects become dotted columns. Lists are joined, spread into columns, or exploded into one row per item.

Open the toolFree toolDocuments

Read and check a passport MRZ

TD1, TD2, TD3 and visas

Decodes passport, ID card and visa MRZs and recalculates every ICAO 9303 check digit. Spots O-for-0 misreads.

Open the toolFree toolScraping

Test scraping selectors on real HTML

CSS and XPath

Paste page HTML, write CSS or XPath per field, watch the rows fill in. Copy the result as Python or Playwright code.

Open the toolFree toolCleaning

Turn messy dates into one format

20+ input formats

Mixed date formats into YYYY-MM-DD or any format you like. Works out day/month order from the data and flags what's ambiguous.

Open the toolFree toolBusiness case

How much will automation save you?

FTE explained, maths shown

Hours and FTE saved by an automation from a few plain questions. Money is optional. Every step of the maths shown.

Open the tool