Guides
Short, practical how-tos for the everyday list and text jobs our tools are built for — with formulas for Excel and Google Sheets where they help.
How to Extract Email Addresses from a Website, Document or Text
Five ways to pull email addresses out of web pages, documents and text, and how to clean the result.
Read the guide →How to Compare Two Columns in Excel or Google Sheets and Find Differences
Find what is in one column but not another, with formulas, conditional formatting and a faster no-formula method.
Read the guide →How to Remove Duplicate Lines from a List (Excel, Sheets, Notepad and Online)
Every common way to delete duplicate lines, and how to keep only the repeats or only the unique ones.
Read the guide →How to Convert a Column to a Comma-Separated List (Excel, Sheets, SQL)
Turn a column into a comma-separated list for SQL, code or email, and split it back again.
Read the guide →Text Case Styles Explained: camelCase, snake_case, Title Case and More
What each case style means, where it is used in writing and in code, and how to convert between them.
Read the guide →