Spreadsheet Tips & Guides
Practical tutorials on merging, comparing, deduplicating, and pivoting CSV and Excel data — no jargon, no paywalls.
5 Common Excel Data Tasks You Can Now Do Entirely in Your Browser
From merging files to building pivot tables, these everyday spreadsheet tasks no longer require Excel to be installed on your computer.
VLOOKUP vs INDEX MATCH vs Browser-Based Merge: Which Should You Use?
A practical comparison of the three most popular ways to look up and combine spreadsheet data — with a clear recommendation for each scenario.
How to Pivot CSV Data: Turning Rows Into Columns
Pivot tables are one of Excel's most powerful features — but you don't need Excel to use them. Here's how to pivot CSV data in your browser.
How to Find and Remove Duplicates in Excel or CSV Files
Go beyond Excel's Remove Duplicates button — learn how to group, count, and inspect duplicate rows before deciding what to keep.
How to Compare Two Spreadsheets and Find Differences
A practical guide to spotting exactly what changed between two versions of a spreadsheet — with colour-coded row-by-row diffing.
How to Merge Two Excel Files Without VLOOKUP
Learn how to combine data from two spreadsheets using a browser-based SQL-style JOIN — no formulas, no errors, no Excel required.