Clean inputs before the next task

Data cleaning tools

Fix two common sources of messy data: repeated lines and inconsistent capitalization. Each tool shows a focused transformation and keeps the original input under your control.

Available cleanup tools

Choose based on the structure of your input. A plain list and a spreadsheet row are not the same thing.

Local · plain text lists

Remove Duplicate Lines

Keep the first original line while optionally ignoring case, trimming whitespace or removing empty lines. Best for copied ID, email, name or code lists.

Remove repeated lines →
Local · text, TXT, DOCX, XLSX

Text Case Converter

Apply uppercase, lowercase, sentence case or title case. File behavior varies: XLSX string cells can remain in a workbook, while DOCX input is extracted and downloaded as text.

Normalize capitalization →

Use the smallest tool that matches the problem

Cleaning a copied list

Use Remove Duplicate Lines when every record occupies one line. Decide whether `ABC` and `abc` should count as the same item before enabling case-insensitive matching.

Cleaning capitalization in a spreadsheet

Use the XLSX mode of Text Case Converter for names or labels stored as string cells. Review abbreviations and proper nouns afterward; title case cannot understand every real-world naming convention.

Spreadsheet duplicate rows are different

This site does not yet offer a duplicate-row finder that compares chosen spreadsheet columns. Do not paste raw CSV into the line tool and assume it understands identifiers, quoted commas or row relationships. More specialized data tools can be added later after their preview and export behavior is properly tested.

Data cleaning questions

Do these tools change my original file?

No. Browser tools work with the selected input and produce a new result. Keep the original until you have checked the output.

Does title case validate names?

No. Case conversion changes presentation only. It does not verify spelling, identity, required fields or duplicate people.