Clean Copied Text

Prepare text for Excel

Clean lists and convert them into rows, comma-separated values or tab-separated values for Excel and Google Sheets. Trim each cell, drop empty rows and remove duplicates so your data pastes cleanly.

26 characters · 4 words · 5 lines · 2 paragraphs

0 characters · 0 words · 0 lines · 0 paragraphs

Or pick where your text came from

Your text stays in your browser. Clean Copied Text does not upload or store what you paste.

What this tool fixes

  • Empty rows removed
  • Each cell trimmed of stray spaces
  • Duplicate rows removed
  • One item per line, ready to paste as a column

How to use it

  1. 1Paste your textDrop in the messy text you copied from anywhere.
  2. 2Click cleanClean Copied Text fixes the formatting instantly, in your browser.
  3. 3Copy the resultCopy the clean text or download it as a .txt file.

Common uses

Pasting a clean column into a spreadsheetBuilding a CSV from copied textDe-duplicating data before importPreparing tab-separated values

Related tools

Convert a list to comma-separated textTurn a vertical list into comma-separated values for spreadsheets, forms, tags, prompts or databases. Optionally quote items and remove duplicates.
Remove duplicate linesPaste a list and remove repeated lines while keeping the first occurrence. Case-insensitive options for lists, emails, keywords and spreadsheet data.
Sort lines alphabeticallySort any list from A to Z or Z to A. Clean empty lines, trim spaces and organize text quickly — all in your browser.
Remove extra spaces from textClean double spaces, leading and trailing spaces, tabs and messy spacing copied from documents, emails or websites — instantly and privately.

Frequently asked questions

How do I get a comma-separated or tab-separated result?
Use the comma or tab conversion options. Tab-separated values paste neatly across spreadsheet columns.
Does it remove duplicate rows?
Yes — duplicate rows are removed by default while keeping the first occurrence.