Worked examples, real tasks
List cleaning guides
Start with the task you need to finish. Each guide shows the steps, an example you can check, and the details that matter before you reuse the result.
- Clean a spreadsheet column before reusing it
Turn a copied spreadsheet column into a clean, unique list without changing its order.
- Turn an Excel column into a comma-separated list
Join spreadsheet values for a search field, tag list, or other simple comma-delimited input.
- Convert a text list to a JSON array without broken escaping
Create a valid array of strings, including values with quotes, backslashes, and leading zeros.
- Sort filenames so file2 comes before file10
Put numbered filenames and labels in a human-readable order without renaming them.
- Count repeated answers in a one-column survey export
Turn one answer per line into a frequency table, with the most common answer first.
- Extract lines containing “error” from a copied log
Keep or remove log lines containing a literal fragment, without learning regular expressions.
Already know the operation you need? Browse all 16 free tools.