How-to · 10 Nov
How-to · 3 min read
How to remove duplicate lines and sort a list quickly
Anyone who pastes a list of emails, product codes or names from a spreadsheet often needs to drop duplicates and blank lines and sort it fast. The list came from three places, half the entries repeat, and some lines carry stray spaces at the end. You do not want to open Excel, write a formula or sign up for a website just to clean forty lines. You want to paste, click once and copy the clean result back.
01
Why it's hard
Spreadsheets can remove duplicates, but you have to paste the list into a column, find the right menu and copy it back out, and the steps differ between programs. A plain text editor usually has no deduplicate button at all. Many online list cleaners work, but they send whatever you paste to their server, which is not great when the list holds customer emails, phone numbers or internal codes that should stay inside the company. And duplicates are often not exact, because a trailing space or different capitalization makes two lines look different to a computer.
This part describes the usual way. It makes no claims about 모아키트 MoaKit, so nothing is quoted here.
02
How 모아키트 MoaKit does it
MoaKit, a free collection of 151 browser tools, has a line organizer (줄 정리 도구) that handles this on one screen. It sorts a multi-line list, removes duplicate and blank lines, adds numbers or text before and after each line, and can turn the list into a comma-separated one. The site says the text you enter is not sent to a server and is processed only in your browser, and there is no sign-up or install. When you are done, you copy the result in one go or save it as a file, and the same screen is ready for the next list without any setup.
여러 줄 목록을 정렬하고, 중복·빈 줄을 지우고, 번호나 앞뒤 글자를 붙이고, 쉼표 목록으로 바꿔요.Quoted from moakit.win
입력한 텍스트, 이미지, 파일은 서버로 전송되지 않으며 이용자의 브라우저 안에서만 처리됩니다.Quoted from moakit.win
화면 상단의 검색 버튼 또는 단축키 Ctrl+K(Mac은 ⌘K)로 어느 페이지에서든 도구 검색 창을 열 수 있습니다.Quoted from moakit.win
03
Step by step
- 1Open moakit.win and search for the line organizer, or press Ctrl+K on any page and type its name.
- 2Paste your list with one item per line, straight from the spreadsheet, email or chat where it came from.
- 3Turn on duplicate removal and blank line removal.
- 4Pick a sort order if you want the list in alphabetical order, or leave it unsorted to keep the original sequence.
- 5Add numbering, or a prefix and suffix, if the list is going into a document or code.
- 6Copy the result, or switch it to a comma-separated list before copying.
04
Tips
Clean up spaces before you trust the duplicate count. Two entries that differ only by a trailing space or a capital letter count as different lines to most tools, so compare the result with what you expected and fix the odd ones by hand.
General advice. Not a claim about the product.
Use the comma output when the list is going into a form field, a tag box or a query. Turning a column into a comma list by hand is exactly where missing commas and typos creep in.
여러 줄 목록을 정렬하고, 중복·빈 줄을 지우고, 번호나 앞뒤 글자를 붙이고, 쉼표 목록으로 바꿔요.Quoted from moakit.win
If you need to see what changed between two versions of a list, open the text compare tool. It puts both side by side and marks added, deleted and changed parts by line, word or character.
두 글을 나란히 놓고 추가·삭제·바뀐 부분을 줄·단어·글자 단위로 한눈에 비교해요.Quoted from moakit.win
Switch the interface language if you do not read Korean. The main tools can also be shown in English, Japanese, Chinese, Spanish and Portuguese.
주요 도구는 한국어, 영어, 일본어, 중국어, 스페인어, 포르투갈어로 볼 수 있어요.Quoted from moakit.win
05
Questions
Is the text I paste uploaded anywhere?
No. Text, images and files you enter are processed only in your browser and are not sent to a server.
입력한 텍스트, 이미지, 파일은 서버로 전송되지 않으며 이용자의 브라우저 안에서만 처리됩니다.Quoted from moakit.win
Do I need an account to use it?
No. There is no sign-up or install, and the tools are free.
회원가입도, 설치도 필요 없어요.Quoted from moakit.win
Can it add numbers to each line?
Yes. The line organizer can number lines or add your own text before and after each one.
여러 줄 목록을 정렬하고, 중복·빈 줄을 지우고, 번호나 앞뒤 글자를 붙이고, 쉼표 목록으로 바꿔요.Quoted from moakit.win
More from 모아키트 MoaKit
All 3 answersHow-to · 6 Nov