Generic converters and copy-paste flatten layout. To convert PDF to Excel without losing the structure, you need table reconstruction, not a text paste.
Step 1: Avoid copy-paste from PDF viewers
Copy-paste usually produces one column of text, breaks multi-line headers and splits wrapped descriptions across rows.
Step 2: Use a layout-aware converter
pdfintoexcel groups words into rows and columns by their position on the page, merges wrapped lines and drops repeating page headers and footers before writing Excel.
Step 3: Use Accurate mode for scans
For scanned documents, Accurate OCR handles small print and dense tables better than Fast. Digital PDFs do not need OCR at all.
Step 4: Check number types and headers
Open the workbook and confirm amounts are numeric, dates sort correctly and the header row matches the PDF. "Formatting" here means structure and data types; fonts and colours from the PDF are not copied.
Try the converter on your hardest table first.