Name and address pairs pasted out of an email client or a notes app rarely arrive in any usable shape. Paste the list below, and it is split on the comma between each name and address, trimmed, and deduplicated so repeated contacts appear once. The result is a two-column table ready to download as CSV or Excel. Your text never leaves this browser.
Why email lists arrive messy
When you copy a block of contacts out of a mail client, a chat thread, or a plain-text note, each contact usually lands on its own line as a name followed by an address. There is no header row, the spacing is inconsistent, and the same person often appears two or three times because they were on more than one thread. Pasting that straight into a spreadsheet gives you one wide column of text that resists sorting, filtering, and mail merge.
What this page does with your list
The tool splits each line at the comma, so every contact becomes two cells: the name and the address. Leading and trailing spaces are trimmed from both cells. Because the header row option is off, every line is treated as data, so nothing is thrown away as a heading. Duplicate rows are removed, so a contact that appears several times in the paste survives exactly once in the table.
Numbers and dates are left alone
Names and addresses are text, and treating them as anything else causes damage. A name like May 4 or a suite number can look like a date or a number to a spreadsheet, so this page leaves number and date casting switched off. Every cell stays exactly the text you pasted, which is what a contact list should be.
Getting the result out
Once the table looks right, download it as CSV for mail merge tools and most spreadsheets, or as Excel if that is what your team opens. Both files are generated locally in your browser. If your list is longer than the preview shows, the download still contains every row.
Keeping the list tidy over time
Contact lists drift. People change addresses, threads accumulate repeats, and copied blocks pick up stray spaces that make near-identical rows look different to a spreadsheet. Because trimming runs before the duplicate check, two entries that differ only by padding collapse into one, and the counter under the preview tells you how many rows were removed. Re-running a refreshed paste through the page each time keeps the downloaded file consistent, so the list you merge from stays the list you meant to keep.
Questions
Does my email list get uploaded anywhere?
No. The splitting, trimming, and deduplication all happen in your browser, and the downloaded file is generated locally too. Nothing is sent to a server.
What separator should my list use?
The usual shape is one contact per line with a comma between the name and the address, and the automatic delimiter detection picks that up. If your list uses tabs, semicolons, pipes, or just spaces, pick that delimiter instead.
What happens to duplicate contacts?
Rows that are identical after trimming are collapsed to a single row, and the count of removed duplicates is shown with the results. If two entries differ by a stray space, trimming makes them match so they collapse too.
Will my addresses be turned into numbers or dates?
No. Number and date casting are switched off for this tool, so every cell keeps its original text. That protects names and address fragments that could otherwise be misread.
Can I sort the list alphabetically?
Yes. Pick a column and a direction in the sort controls and the rows are reordered before you download.