Unmerge Excel cells into a clean flat table
Tách mọi ô gộp, điền giá trị vào từng ô, gợi ý bỏ dòng tổng và dòng trống — xem trước rồi mới áp dụng để ra bảng phẳng sạch.
Thả file .xlsx hoặc .xls 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ẽ bỏ gộp ô, điền giá trị và giúp bạn làm phẳng bảng luôn.
How to unmerge Excel cells into a clean flat table
Reports full of merged cells, multi-row headers and total rows are hard to merge or filter — flatten them right in your browser.
- 1. Drop your Excel file
Drop an .xlsx or .xls file containing merged cells. SheetDrop reads it right on your device and shows each sheet’s structure.
- 2. Unmerge and fill values
Every merged range is split and the top-left value is filled into each cell, both down columns and across rows.
- 3. Review and drop unneeded rows
Check the suggested total and blank rows, untick the ones to keep and adjust the header row if needed.
- 4. Download the flat table
Download a new Excel file: one flat table per sheet with a single header row, ready to merge or analyze further.
Frequently asked questions about unmerging Excel cells
Is my file uploaded to a server?
No. The file is read and processed entirely in your browser. SheetDrop sends nothing anywhere and never modifies the original file.
Where do the values go after unmerging?
Excel keeps the value only in the top-left cell of a merged range. SheetDrop fills that value into every cell of the range, both vertically and horizontally, so no data is lost.
Are total rows removed automatically?
Never automatically. SheetDrop only suggests rows that look like totals or blank rows; you preview them, tick or untick each row, and only then apply.
Why are .xlsx and .xls accepted but not CSV?
CSV files are plain text with no merged cells, so there is nothing to unmerge. To clean or combine CSV files, use SheetDrop’s Merge Excel tool.
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 can I do with the flat table next?
A flat table with a single header row works directly with the Merge Excel tool: combine sheets and files, or compare two reporting periods.