All data tools
Showing 9 of 9 data tools
VLOOKUP Online
Bring columns from one sheet into another, without writing a formula.
Open toolDuplicate Finder
Find duplicate rows by whichever columns actually define a duplicate.
Open toolSee What Is in My File
See what is actually in a spreadsheet before you rely on it.
Open toolMatch Similar Names
Match records whose names never quite agree between two systems.
Open toolFind Similar Records
Find the duplicates that an exact match will never catch.
Open toolCompare Spreadsheets
See what changed between two versions of the same data.
Open toolData Cleaner
Tidy a spreadsheet, and see exactly what changed, with real before-and-after examples.
Open toolCheck Two Systems Agree
Reconcile two systems and see exactly where they disagree.
Open toolCSV to Excel
Convert CSV to Excel the way it should work - leading zeros, long IDs and accented text all survive.
Open toolMost spreadsheet problems are not really spreadsheet problems. They are two files that should line up and do not, a total that is wrong because something was counted twice, or a column that turns out to hold three different kinds of value.
These tools are built around that. They tell you what is wrong with the data before they process it, they never change a value without showing you, and they run entirely in your browser - which matters when the file is a customer list or a payroll export.
Which data tool do you need?
- To bring columns from one sheet into another, use VLOOKUP Online. It works between two sheets of one workbook or between two separate files, and can return several columns at once.
- When the names never quite agree between two systems, use the fuzzy lookup. You set how similar counts as a match, and every row comes back with its confidence.
- To find rows that appear more than once, use the duplicate finder. You choose which columns define a duplicate, rather than being forced to compare entire rows.
- For duplicates that are close but not identical - the same customer typed three different ways - use the fuzzy duplicate finder.
- To see what changed between two versions of the same export, use compare spreadsheets. It reports added, removed and changed rows, and which values moved.
- To reconcile two systems on a reference and an amount, use Data Reconciliation. It reports both totals, the gap between them, and every difference beyond your tolerance.
- To tidy a file before any of the above, use the data cleaner. Every change is counted and shown, with real before-and-after examples, and can be undone.
- To understand a file before you use it, use the data profiler. It reports each column's type, blanks, duplicates and range, plus a quality score that shows how it was calculated.
A sensible order to work in
Profile first, clean second, then match. The profiler tells you which columns are usable and which are a mixture of things; the cleaner fixes the spacing, hidden characters and numbers-stored-as-text that break a lookup; and only then is a match worth running.
Doing it the other way round is the usual reason a lookup returns half a result. The matching tools do check the key columns and warn you before they run, but a file that has been cleaned once is easier to work with every time afterwards.
Why lookups fail when the values look identical
A trailing space. A non-breaking space pasted in from a web page. An invoice number stored as text on one sheet and as a number on the other. Each of these defeats an exact comparison while looking completely normal in the cell, and between them they account for most of the #N/A results people spend afternoons chasing.
Rather than silently cleaning your data, these tools count the affected rows, show you real examples from your own file, and let you decide. When you accept, the tidied-up value is used for comparison only - the cells that come back in your result are exactly the ones you started with.
What "stays on your device" means here
The spreadsheet is read by your browser using the same engine as the rest of VSThiran's file tools. No part of the file is sent to VSThiran or to anyone else, there is no upload step, and no copy is stored anywhere.
That is a statement about where processing happens, not a claim that the site works offline. You need to load the page; once it has loaded, your data never leaves the tab.
Frequently asked questions
Are these data tools free?
Yes - free, with no sign-up, no watermark and no limit on how many files you process.
Is my spreadsheet uploaded anywhere?
No. Your files stay on your device. Everything is read and processed by your browser, so nothing is transmitted and no copy is stored.
What file formats can I use?
XLSX and XLS workbooks, and CSV files. The delimiter of a CSV is detected automatically, so semicolon-separated European exports work without any setting.
How large a file can these handle?
There is no server limit because nothing is uploaded. The practical ceiling is your device's memory; workbooks beyond about two million cells are refused rather than being allowed to freeze the tab.
Will the tools change my data?
Only when you ask. Cleaning up spacing or capitalisation is used for comparison, never written into your result - the original cells are copied through unchanged. Removing duplicate rows is an explicit action with its own download button.
Do you support fuzzy or close matching?
Yes, in the VLOOKUP tool, and it is off by default. A close match is only ever used when there is no exact match, and where two candidates score almost the same the row is marked "Needs Review" instead of one being chosen for you.
Other free tools on VSThiran
How to clean up a messy spreadsheet
Check it, fix the formatting, then find the duplicates - in that order, and why.
How to compare two spreadsheets
Three different jobs people call comparing, and which tool each one needs.
Free PDF tools
Convert a PDF to Excel, split pages, merge files and compress.
Free text tools
Compare two texts, count words and clean up whitespace.
Free business tools
Invoices, quotations and receipts as proper A4 PDFs.
Free calculators
Percentages, loans, EMI and everyday maths.