Spreadsheets with empty cells
Parse spreadsheets with gaps, merged headers, and irregular structure — reliably.
Docen ParseDocen Layout
THE CHALLENGE
Real spreadsheets are messy: empty cells, merged headers, subtotals, and blocks that don't line up. Naive parsing produces misaligned rows and silent errors.
THE DOCEN APPROACH
Docen reads the actual grid — including gaps and merges — and returns rows that stay aligned to the right headers, so downstream code doesn't inherit the mess.
- Detect headers, including merged ones.
- Preserve empty cells rather than collapsing rows.
- Keep rows aligned to their columns.
- Return clean, structured tabular data.
parse → sheet.json
{
"headers": ["region", "q1", "q2", "q3"],
"rows": [
{ "region": "North", "q1": 41, "q2": null, "q3": 48 },
{ "region": "South", "q1": 33, "q2": 39, "q3": null }
],
"empty_cells_preserved": true
}aligned
rows & headers
preserved
empty cells
no
silent errors
[→]GET STARTED
Try it on yourown documents.
Bring a sample of the documents behind this use case and we'll show you the structured output.