Guides
BasisFile Guides
Quick guides for the most common spreadsheet headaches marketers and analysts deal with every week.
Merge Google Ads with Meta Ads exports
Combine campaign exports from Google Ads and Meta into one tidy spreadsheet — no manual VLOOKUPs.
Read guide →Remove duplicate rows from a CSV
Catch exact and near-duplicate rows (trailing spaces, casing, formatting) in seconds.
Read guide →Fuzzy match names across spreadsheets
Reconcile customer or company names that don't match exactly — typos, suffixes, abbreviations.
Read guide →The best online OpenRefine alternative
Clean and reconcile data in your browser without installing Java or learning GREL.
Read guide →Standardise date formats in Excel
Normalise mixed DD/MM/YYYY, YYYY-MM-DD and text dates into one consistent format.
Read guide →Got a cleaning workflow you wish was a one-click tool? Tell us and we'll write the guide.