Guides

Longer articles on cleaning and converting text data — the reasoning behind the tools, and the alternatives worth knowing.

• Cleaning Messy Text Data Before You Import It The right order of operations for cleaning an export, and why sequence matters. · 7 min read
• Five Ways to Remove Duplicate Lines, and When to Use Each Spreadsheet, command line, SQL or browser — a comparison of the real options. · 6 min read
• JSON Arrays in Practice: Escaping, Types and Common Mistakes Why hand-written JSON breaks, and how to read a parse error properly. · 6 min read
• Why It Matters That a Text Tool Runs in Your Browser What happens to text you paste online, and how to check for yourself. · 5 min read