posted an update —

Architecture update on PDF Retype: Solving borderless financial statement reconstruction

Over the past few weeks, we've tackled one of the hardest layout engineering challenges in document reconstruction: converting multi-page, borderless financial balance sheets and audit schedules from PDF into native Microsoft Excel and Word.

When naive converters process borderless tables, they treat the page as a 2D coordinate canvas. This leads to three widespread failure modes:

  1. Multi-line line items split into orphan rows, causing blank columns and formula misalignment.
  2. Silent non-breaking spaces (CHAR 160) between currency signs and digits cause Excel =SUM() formulas to return zero without warning.
  3. Negative values formatted in accounting parentheses (1,450.00) turn into uncalculable strings.

Our TrueLayout engine focuses on establishing vertical whitespace projection envelopes and unifying multi-line text blocks into single cell paragraphs before table generation. This ensures that extracted spreadsheets feature genuine, dynamic cell grids that expand naturally with edits and calculate out-of-the-box.

You can test the latest table extraction capabilities on live documents at https://pdfretype.com.