Articles
Excel & spreadsheet data
Match, compare, clean and reconcile Excel and CSV files without writing formulas.
11 articles
- Excel & Data
How to match two spreadsheets without writing a formula
Upload both files, click the matching column in each table (the connector shows what you picked), tick the columns you want copied across, then run it and download the result.
- Excel & Data
Excel names don't match? Find similar records with fuzzy matching
Open Fuzzy Lookup, upload both files, pick the column to match on, and set how close counts as a match. It finds records like "ABC Trading LLC" and "ABC Trading L.L.C." that an exact match would miss, and flags anything too close to call for you to review.
- Excel & Data
How to find duplicate rows in Excel
Upload your spreadsheet, choose which columns define a duplicate (or use the whole row), and the tool lists every duplicate group so you can review and remove them.
- Excel & Data
Find near-duplicate records even when the names differ slightly
Upload your spreadsheet, choose the column that should be unique, and set how close counts as a match. Records like "Jon Smith" and "John Smith" - the same person, entered slightly differently - are grouped as likely duplicates for you to review.
- Excel & Data
How to clean messy Excel data without writing formulas
Upload your spreadsheet and the cleaner trims extra spaces, fixes inconsistent capitalisation, standardises dates and numbers, and drops blank rows - reviewable before you apply anything.
- Excel & Data
What's actually in this spreadsheet? Check before you build on it
Open the Data Profiler - it shows what each column actually contains, how much is missing, and where the likely quality problems are, without changing your file at all.
- Excel & Data
How to compare two Excel files and find what changed
Upload both files, pick the column that identifies each row (like an ID), and the comparison shows exactly which rows were added, removed, or changed - and which specific values differ.
- Excel & Data
How to reconcile two Excel reports and find differences
Upload both reports, choose the reference column and the amount column, and the tool matches records between them and flags anything missing, extra, or where the amount does not agree.
- Excel & Data
Why does Excel drop leading zeros from my CSV?
Excel treats every CSV value as "General" format when it opens the file, which means anything that looks like a number is read as one - and a real number can never start with a zero, so it is dropped. Converting the CSV to Excel with those columns explicitly typed as text, rather than opening the CSV directly, avoids the problem entirely.
- Excel & Data
Why does Excel show my CSV numbers as 1.23E+12?
Excel's number type reliably stores about 15 significant digits. A 16-digit card or account number read in as a number gets rounded to fit and displayed in scientific notation - and the digits past the 15th are genuinely gone, not just hidden behind the display format. The fix is to keep that column as text from the start, rather than trying to reformat it back afterward.
- Excel & Data
Why does my CSV open in one column in Excel?
This happens when the file uses a different delimiter (usually a semicolon) than the comma Excel expects by default in your regional settings - common with files exported from systems set up for a European locale, where a comma is the decimal separator and a semicolon separates fields instead. Converting the file with the correct delimiter detected, or using Excel's Text to Columns feature, fixes it.