Guides
How to solve common data and research problems, in Excel, Google Sheets or BenchCove.
File & Data Workbench
How to remove duplicate rows from a CSV file, by email or any column
Remove duplicate rows from a CSV by email, ID or any column, in Excel, Google Sheets or your browser, without losing data you meant to keep.
Read the guideHow to compare two CSV files and see which rows were added, removed or changed
Compare two CSV or Excel files by ID or email to find added, removed and changed rows, in Excel, Google Sheets or privately in your browser.
Read the guideWhy é turns into é in a CSV file, and how to fix it
Why accented letters turn into é or � in a CSV, and how to fix it in Excel, Google Sheets or your browser by reading the file with the right encoding.
Read the guideHow to clean a Shopify or WooCommerce product or order export
Clean an online-store product or order export: spaces, capitalisation, empty values and duplicates, without breaking variant rows or re-import.
Read the guideHow to clean a YouTube or Instagram analytics export before you chart it
Tidy the CSV you export from YouTube Studio or Meta's insights before charting it: find the right file, fix columns and check totals, in your browser.
Read the guide