TECHBOOST · Operations toolkit

Data Workspace

Clean lists, compare files, remove duplicates, and export or copy Excel-ready results — without manual VLOOKUP or XLOOKUP formulas.

01Upload your files

Original file = the data you want to keep. Reference file = the rows to find and remove from it.

Original data file

Choose or drop original fileCSV, XLSX, XLS

Reference data file

Choose or drop reference fileRows to match against the original

Excel files (.xlsx/.xls) need the spreadsheet reader library to load. If you are offline and it has not loaded, use CSV files or open this app once while connected to the internet.

02Choose matching rules

Select the column in each file used to identify the same person or record.

Match records by

Action

Original file: matching column

Reference file: matching column

Ignore uppercase/lowercase differences Normalize phone numbers (digits only)

03Results & exports

Download kept rows and removed/matched rows separately. Original columns and values are preserved.

—

Original rows

—

Reference matches

—

Rows kept

—

Reference rows

Upload both files, choose a matching column, then process.

01Remove duplicate records

Upload a file or paste email addresses. Keep the first occurrence and remove later duplicates.

Upload a file (optional)

Choose or drop a fileCSV, XLSX, XLS

Column to check for duplicates

For email lists, choose the e-mail column. Other columns remain unchanged.

Or paste a list of emails / identifiers

When you paste a list, the tool removes duplicate lines and keeps the first instance.

Deduplication results

Download the clean file and the duplicate rows separately.

—

Input rows

—

Unique rows

—

Duplicates removed

—

Blank keys

Your results will appear here.

01Lookup & match

A practical no-formula alternative to VLOOKUP/XLOOKUP: bring a value from a reference file into the original rows by matching a key.

Original file

Choose original fileCSV, XLSX, XLS

Reference file

Choose reference fileCSV, XLSX, XLS

Original match key

Reference match key

Value to bring from reference

New column name

Lookup results

Original data plus the returned value in a new column.

—

Original rows

—

Matches found

—

No match

—

Duplicate keys in reference

Upload both files to begin.