Try the Data Cleaning Spreadsheet Formulas

This demo is a live spreadsheet running in your browser. The columns show a messy vendor import in A and B, dirty notes in C and a clean master table in D and E. Pick a formula below, or type one into a cell and press Enter, just like in Sheets, to see how the Data Cleaning Spreadsheet Formulas match, clean and deduplicate.
Everything runs locally, nothing is uploaded.
New here? Open Help > Guided tour and it walks you through every formula step by step. It is the fastest way to see what this demo can really do.

100%
A1
1 DataWrangle Data Wrangler Flookup Data Wrangler
2 Global Logistics Ltd 42000 St. John's Café - MÜNCHEN Global Logistics Logistics New York
3 ACME CORP. 18500 ACME CORP. - HANNOVER Acme Corporation Manufacturing New York City
4 northwind trading 7200 café au lait GmbH Northwind Traders Retail NYC
5 TechSolutions Inc. 31000 Tech Solutions Inc Software Berlin
6 Innovate Corp 12400 Innovate Industries Consulting Berlin
Try these:

Convinced? Run these formulas on your own data in Google Sheets, up to 50,000 rows per run.

Install Flookup in Google Sheets Get Started Free

Select a cell, then click an example below or type a formula and press Enter. Formulas may return one value or spill across several cells, exactly as they do in Google Sheets. The real add-on runs inside Sheets with the same matching and cleaning engine. See the full function reference or install Flookup in Google Sheets.

Frequently Asked Questions

Do I need an account to use the Flookup demo?

No. The demo opens directly in your browser with no sign-in, no installation and no Google Sheets required.

Which formulas can I try in the demo?

All eight Data Cleaning Spreadsheet Formulas: NORMALIZE, FUZZYSIM, FLOOKUP, SHEETMERGE, QLOOKUP, HFLOOKUP, DEDUPE and ULIST. Pick an example above the grid or type any formula into a cell.

Is my data uploaded when I use the demo?

No. The spreadsheet and every formula run locally in your browser. Nothing you type is sent to a server.

How does the demo compare to the Flookup add-on?

The demo runs the same matching and cleaning engine, but on sample data. The Flookup add-on installs in Google Sheets and runs these formulas on your own data, up to 50,000 rows per run.