Platform

Unmerge Excel merged cells and fill down values in CSV exports

Fill down blank cells in CSV exports caused by merged cell regions in Excel workbooks.

🛡️ Your rows never leave your browser.

Why Onfyt: Detects which columns likely have merged-cell patterns (runs of blanks interrupted by values) and suggests those columns automatically rather than requiring manual selection.

Interactive Sample Data

region	category	product	revenue
Nairobi	Solar	Panel 250W	4500
		Panel 300W	5200
	Battery	Lithium 100Ah	3800

How this tool works

When Excel worksheets use merged cells for visual grouping (a single region label spanning 5 rows), saving as CSV leaves those blank—Excel only writes the value to the top-left cell of the merged range and outputs empty strings for the rest. The resulting CSV has entire column runs of blank cells where the parent value should repeat. This tool implements 'fill down': for each column, if a cell is blank, it inherits the value from the nearest non-blank cell above it. This is the same operation as Excel's Home → Fill → Down, applied to specified columns of the CSV. Spreadsheets exported from enterprise software frequently contain merged title blocks and hierarchical category headers that produce empty cells in subsequent data rows when converted to CSV. Downstream analytics tools read these blank cells as null values, corrupting grouping calculations. DataFix detects merged blocks, unmerges cells, and automatically fills down header values to ensure every data row contains full category lineage. Merged cells in spreadsheet reports cause empty values in underlying data rows when exported to tabular CSV, breaking downstream SQL aggregation. Unmerging and filling down category labels restores full dimensional lineage to every row.

Things that usually go wrong

Excel does not preserve merge information in CSV exports. This tool uses fill-down as a heuristic, which works for most standard merged-header layouts.
If your blank cells are intentionally empty (not from merging), this tool will incorrectly fill them.

Edge cases we tested

🧪 Truly empty rows (all columns blank)

Empty rows not filled; detected as row separators and preserved or removed.

🧪 First row of a column is blank

No ancestor value to fill from; blank preserved with a warning.

🧪 Mixed merged and genuinely blank cells in same column

User can switch to column-specific fill-down to control exactly which columns receive fill-down treatment.

Frequently Asked Questions

What is the difference from Unmerge Cells and Fill?

These tools are functionally identical. 'Fix Excel Exports with Merged Cells' is named for the specific Excel context.

Can I fix merged cells without exporting to CSV?

Not in the current version — export to CSV first.

Related tools

Platform

Shopify Customer Export Cleaner

Normalize Shopify customer exports: merge split address fields, clean phones, and strip internal metadata.

Open Tool →

Platform

Stripe CSV to JSON

Convert Stripe balance and payment CSV exports to clean JSON with amount conversion and metadata parsing.

Open Tool →

Platform

Google Contacts CSV Fixer

Fix Google Contacts CSV exports to import into Outlook, Apple Contacts, or CRM platforms.

Open Tool →