Skip to content
FileMyLove

Merged Excel cells leave blanks in CSV: prepare a flat table

Understand why merged labels are not repeated in CSV and prepare explicit values for every record before sharing the export.

By FileMyLove Team2 min read

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

  1. Duplicate the workbook and identify the actual record table.
  2. Unmerge cells in the copy where necessary.
  3. Enter explicit values only where their meaning is established.
  4. Convert with Excel to CSV.
  5. 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.