Normalize Vietnamese Excel and CSV data
Sửa lỗi font, dọn khoảng trắng, chuẩn SĐT, ngày, số và bỏ dấu theo quy tắc minh bạch — xem từng ô sẽ đổi trước khi tải, không AI, không sửa im lặng.
Thả file .xlsx, .xls hoặc .csv vào đây
Tối đa 50 MB · 1 file mỗi lần · file gốc không bị thay đổi
Thả file vào đây nhé! Mình sẽ sửa lỗi font, dọn khoảng trắng và chuẩn hoá SĐT, ngày, số theo đúng quy tắc bạn chọn.
How to normalize Vietnamese Excel and CSV data
Broken Unicode, stray spaces, phone numbers in three formats, mixed date styles, numbers stored as text — fix them all with transparent rules and a per-rule preview before you download.
- 1. Drop your Excel or CSV file
Drop an .xlsx, .xls or .csv file up to 50 MB. SheetDrop reads it right on your device — nothing is uploaded.
- 2. Pick the rules
Unicode repair and space trimming are on by default. Phone, date, number and diacritics rules are off by default — enable one and preview exactly what it changes.
- 3. Preview every change
Each column shows how many cells change per rule with before/after samples. Ambiguous cells such as 01/02/2025 are kept as-is with a warning — the tool never guesses for you.
- 4. Download the result
Download a new Excel file or a UTF-8 CSV that keeps Vietnamese diacritics intact. Your original file is never modified.
Frequently asked questions about normalizing data
Is my file uploaded to a server?
No. The file is read and processed entirely in your browser using fixed rules — no AI involved. SheetDrop sends nothing anywhere and never modifies the original file.
What does the tool normalize?
Six rules: Vietnamese Unicode repair, stray and hidden whitespace removal, Vietnamese phone numbers to 0xxxxxxxxx form, dates to dd/mm/yyyy, numbers like 1.000,5 / 1,000.5 to machine format for import, and Vietnamese diacritics removal for legacy systems.
How are phone numbers standardized?
Every form — 84xxx, +84xxx, or numbers that lost the leading zero in Excel — becomes 0xxxxxxxxx (10 digits with a valid Vietnamese mobile prefix). Results are stored as text so the leading zero never disappears. Landlines, product codes and amounts are never touched.
What does 01/02/2025 mean?
It is genuinely ambiguous — February 1st or January 2nd. The tool does not guess: ambiguous cells stay unchanged with a warning. Clear dates (25/03/2025) and year-first dates (2025-02-01) are always converted to dd/mm/yyyy.
Can diacritics removal be undone?
No. Removing diacritics is one-way — you cannot recover them from "Ha Noi". That is why the rule is off by default and shows a clear notice when enabled. Your original file stays untouched, so you can always start over.
Does the result keep colors and borders?
Not yet. The result keeps all of your data, but original colors, borders and formulas are not preserved (formulas are replaced by their calculated values). We are working on preserving formatting in a later release.
What should I do next with clean data?
Clean data works directly with the other SheetDrop tools: merge multiple reports (/tools/merge-excel), compare two periods (/tools/compare-excel), or unmerge cells if the file still has merged ranges (/tools/unmerge-excel). Everything runs right on your device.