A department name spans several Excel rows, but only one CSV record contains it. A visually merged label is not a separate value in every cell. Before importing the CSV elsewhere, prepare a table whose records make sense independently.
What the converter exports
FileMyLove reads the stored text of each cell for CSV. It does not copy a merged label into the other positions of its merged range. This differs from a spreadsheet preview, where one label can visually cover several columns or rows.
Microsoft explains that merging keeps one cell's contents and deletes the others. Unmerging is therefore not a way to recover previously deleted values. Keep the original workbook before restructuring a delivery copy.
Decide what each blank means
| Situation | Suggested preparation |
|---|---|
| Report title spans the first row | Keep it outside the import table if the recipient expects column headers first |
| Department label spans several records | Enter that department on each relevant record after checking the source |
| Blank means unknown | Preserve that meaning; do not copy a neighboring value automatically |
| Decorative spacing between sections | Decide whether the receiving system accepts those rows |
These are preparation recommendations, not automatic cleanup features. The website does not infer which blank cells belong to a department or which rows are decorative.
Export a reviewed copy
- Duplicate the workbook and identify the actual record table.
- Unmerge cells in the copy where necessary.
- Enter explicit values only where their meaning is established.
- Convert with Excel to CSV.
- Check the downloaded column headers and several records from each former merged group.
Compare the delivery file with the source before importing it into another system. A file that opens without an error can still assign records to the wrong group.
Check other export boundaries separately
Merged cells are separate from visibility settings. Read hidden rows in CSV exports before assuming hidden information is excluded. If several CSV files arrive in a ZIP, multiple-sheet exports explains the packaging. Review each delivered table independently.



