Compare customer or email lists: how to spot additions, removals and changes
A step-by-step method to compare two versions of a customer or subscriber list in Excel and find out who is new, who has left…
6 min read
Blog
Guides, tips and tricks to work better with Excel, CSV and spreadsheets.
-
-
How to compare two columns in Excel and find matches and differences
Formulas and conditional formatting to see which values match between two columns, which are missing from one of them and how to extract them…
6 min read -
Comma or semicolon: the CSV separator and regional settings explained
Why Excel sometimes saves CSV files with semicolons, why everything can end up in a single column, and how to control the separator and…
7 min read -
How to export data from your bank, ERP or online store to Excel and get it ready to use
Export transactions, orders or invoices from any system and turn them into a clean Excel table: amounts, dates, text and duplicates sorted out.
6 min read -
Excel and Google Sheets: how to move files between them without losing formatting
What is kept and what is lost when you move a spreadsheet from Excel to Google Sheets and back, and how to do it…
7 min read -
How to open a CSV file in Excel correctly: delimiter, encoding and import
If your CSV opens in a single column, with broken accented characters or missing leading zeros, here is how to import it properly and…
7 min read -
How to detect outliers and data entry errors in a spreadsheet
One extra zero or a misplaced decimal can skew an entire report. Learn to find outliers and data entry errors with formulas, conditional formatting…
6 min read -
Remove spaces and invisible characters in Excel: TRIM, CLEAN and the non-breaking space
A trailing space or a hidden character is enough to make VLOOKUP fail or let duplicates slip through. Learn how to find and remove…
6 min read -
Numbers stored as text in Excel: how to spot and fix them
If SUM returns 0 or VLOOKUP can't find a code you can see on screen, you probably have numbers stored as text. Here's how…
7 min read
