38개 중복 제거. 1247개 셀 트리밍. 89개 날짜 표준화. 무엇이 변경되었는지 정확히 알려드립니다.
무료 온라인 Excel 및 CSV 데이터 클리너 — 중복 제거, 공백 트리밍, 날짜·숫자 정규화, 보이지 않는 문자 수정, 빈 행 제거. 모든 클리닝에 작업별 투명성 보고서와 선택적 병렬 차이 워크북 제공. 가입 불필요. 파일당 최대 50MB.
Fortune 100 금융 기관의 미션 크리티컬 워크플로우에서 사용되는 엔터프라이즈급 문서 처리 기술과 동일한 클래스 위에 구축 — 무료, 출력 품질에 타협 없음.
- 🔒 256-bit HTTPS
- ⏱ 1-hour Auto-Delete
- ✅ GDPR Compliant
- 👁 No Human Review
- 🤖 No AI Training on Your Data
- 📊 Per-action Transparency Report
Excel 또는 CSV 파일을 여기에 드롭하거나 클릭하여 찾아보기
최대 50MB · xlsx, xlsm, xls, xlsb, ods, csv, tsv
왜 "클린"이 보통 "블랙박스"를 의미하는가
대부분의 무료 Excel 데이터 클리너는 다운로드 버튼만 주고 끝납니다. 무엇이 제거되었는지, 무엇이 다시 쓰여졌는지, 도구가 합쳐서는 안 되는 두 고객을 조용히 합쳤는지 볼 수 없습니다. ExcelMaster의 데이터 클리너는 엔터프라이즈급 문서 처리 위에 구축됩니다 — 모든 클리닝에 작업별 투명성 보고서와 선택적 병렬 차이 워크북이 제공됩니다. 커밋하기 전에 몇 개의 중복을 삭제할지, 몇 개의 셀을 트리밍할지, 어떤 날짜를 다시 쓸지 정확히 보여드립니다.
클리닝 대상
Exact dedupe + optional AI fuzzy dedupe
Drop full-row duplicates, or scope to specific columns ("same customer regardless of timestamp"). Optionally let Claude catch near-duplicates that exact match misses — "John Smith" vs "Smith, John", "Acme Inc" vs "Acme Incorporated".
Whitespace and invisible chars
Trim leading/trailing spaces, collapse runs of internal whitespace, strip NBSP / zero-width space / BOM / control chars that came in via copy-paste from web pages or PDFs.
Date standardisation
Recognises MM/DD/YYYY, DD-MM-YYYY, ISO, "May 7 2026", "2026年5月7日", "2026년 5월 7일" and rewrites them all to one target format. ISO by default — sorts correctly as text, machine-readable everywhere.
Number standardisation
Strips currency symbols ($ € ¥ £ ₹ R$ kr…) and thousands separators (en "1,234.56" / de "1.234,56" / fr "1 234,56"). Output is a real Excel number you can SUM, AVERAGE, chart.
Case transformation
UPPER, lower, Title Case or Sentence case across the whole sheet or scoped to specific columns ("Title Case the Customer Name column only").
Blank row & column removal
Removes rows where every cell is empty after trimming. Optionally remove blank columns too. Header row is always preserved.
Excel 데이터를 온라인으로 클리닝하는 방법
- 1Upload your Excel or CSV file — drag & drop, max 50 MB, no signup required.
- 2Click Preview impact — we estimate how many rows, cells and dates we'd touch, before you commit. Industry-first transparency.
- 3Pick cleaning actions — dedupe, trim, normalise dates, normalise numbers, change case, remove blanks. All toggles default to conservative settings.
- 4Click Clean now — typically under 3 seconds for 10k rows. Download the cleaned file plus the optional side-by-side diff workbook so you can verify every change.
ExcelMaster가 대안을 능가하는 이유
Per-action transparency report
Industry standard is the black-box "your file is cleaned" success card. We tell you exactly: 38 duplicate rows removed (3 by fuzzy AI), 1247 cells trimmed, 89 dates standardised, 23 invisible chars stripped. Audit-grade.
Side-by-side diff workbook
Optional second .xlsx: original vs cleaned rows, changed cells highlighted yellow, plus a "Cleaning Summary" sheet. Verify every cleaning decision before accepting. No competitor ships this in a free tool.
AI fuzzy dedupe — opt-in
Catches "John Smith" vs "Smith, John", "Acme Inc" vs "Acme Incorporated". Powered by Claude Sonnet 4.6 via our LLM Proxy. Conservative — only merges when confident. Capped at 500 rows for cost.
11 languages, 145 date locales
Recognises Chinese (2026年5月7日), Japanese (令和8年5月7日 / 2026年5月7日), Korean (2026년 5월 7일), German (07.05.2026), French (07/05/2026), and more. Same engine that powers our PDF→Excel multilingual extraction.
Header row protected
We never trim, normalise, or case-change your header row. Your column titles arrive verbatim — the convention every spreadsheet tool gets wrong eventually.
Free — no compromises on output quality
Same engine the $49/month commercial tools use. We've made it free with no row caps, no watermarks, no signup. Funded by our paid Excel AI Add-in for desktop — most users never need to upgrade.
자주 묻는 질문
How is this different from Excel's built-in "Remove Duplicates"?
Excel's built-in dedupe only does exact-match comparison and offers no transparency. We add fuzzy AI dedupe (catches "John Smith" vs "Smith, John"), per-action transparency report, side-by-side diff workbook, and 6 other cleaning actions in one pass. And it's free — Excel's commercial-grade equivalent (Power Query) requires Office 365.
Will fuzzy AI dedupe wrongly merge two distinct entities?
We tuned the prompt to be conservative — "better to miss a near-duplicate than to wrongly merge two distinct entities". The AI is asked to skip merges it isn't confident about. The opt-in toggle is off by default. Even when on, the side-by-side diff workbook lets you verify every merge before accepting the cleaned file. If you spot a wrong merge, you can rerun without the fuzzy toggle.
What date formats are recognised?
MM/DD/YYYY, DD/MM/YYYY (with - / . separators), ISO 8601, "May 7 2026" / "7 May 2026", Chinese (2026年5月7日), Japanese, Korean (2026년 5월 7일), German (7. Mai 2026), French (7 mai 2026), and Excel's native serial number format. We use the .NET DateTime parser with 8 culture fallbacks. Anything that ambiguously parses is left untouched.
What invisible characters do you strip?
NBSP (U+00A0), zero-width space (U+200B), zero-width non-joiner (U+200C), zero-width joiner (U+200D), BOM (U+FEFF), word joiner (U+2060), and all control characters U+0000–U+001F except tab (U+0009), newline (U+000A), and carriage return (U+000D). These are the chars that creep in via copy-paste from PDFs and web pages.
Is there a row limit?
Up to Excel's native row limit per sheet (1,048,575 data rows). We use a streaming load when source files exceed 200,000 cells to avoid memory pressure. The fuzzy AI dedupe pass is capped at 500 rows for cost reasons — we'll surface a warning when your sheet exceeds that and skip just the AI pass while still doing exact dedupe.
Will my data leave the server?
Files are processed on our servers in EU and uploaded over TLS. Cleaning happens entirely in our infrastructure. The optional fuzzy AI dedupe pass sends row signatures (the cells you asked us to compare) to Claude via our LLM Proxy — that's the only outbound data leg. Files auto-delete from our servers within 1 hour. We do not train on your data.
Does it work for CSV?
Yes. CSV and TSV are first-class inputs — most "clean my CSV online" SEO traffic arrives via messy-csv use cases. Output can be CSV, xlsx, xlsm, xls, xlsb, or ods. CSV output flattens to the first sheet only.
Can I clean a password-protected workbook?
Yes. Provide the open password and we clean as usual. We never brute-force, we never share, we never log the password. (For workbooks where you've lost the password, see our Excel Unlock tool.)
What's the difference between "Remove blank rows" and "Remove duplicates"?
Blank-row removal drops rows where every cell is empty after trimming. Dedupe drops rows where every cell value matches another row. They are independent toggles — you can run either alone or both together.
Can I scope dedupe to specific columns?
Yes. By default we compare the full row, but you can pick specific column indices — "two rows are duplicates iff these specific columns match". Useful for "same customer (col 0,1,2) regardless of timestamp in col 5". The same scoping applies to the optional fuzzy AI pass.
Why is the cleaned file slightly smaller / larger than the source?
Smaller is usually because we removed blank rows / duplicates / strip currency symbols. Slightly larger can happen when you turn on AI fuzzy dedupe + diff workbook generation — the diff is a separate file. The transparency report's "source rows" vs "output rows" tells you exactly how many rows were dropped.
Do you keep my Excel formatting / formulas?
Cell values are cleaned; cell styles and number formats are preserved. Formulas are preserved when the cell type stays the same (text → text). When we normalise a string-typed currency cell into a real number, the formula on dependent cells stays intact and now sees a real number — that's usually what you want. The diff workbook lets you verify case-by-case.