Issue to convert PDF to Excel
Hi...I'm using Adobe Acrobat Pro licensed. I got issue during convert from PDF to Excel. Why after conversion, the columns and figures in Excel misalign or merge across a single column?
Hi...I'm using Adobe Acrobat Pro licensed. I got issue during convert from PDF to Excel. Why after conversion, the columns and figures in Excel misalign or merge across a single column?
Hi @shariffah_1972,
Thank you for reaching out, and I'm sorry to hear that you're experiencing issues when converting your PDF to Excel.
When you export a PDF to Excel, Acrobat must interpret the Table's structure. If the PDF doesn't contain an actual table structure, Acrobat may misread the columns, which can cause numbers or text to merge into a single column.
Here are a few things you can check:
The PDF isn't a real table
Many PDFs visually resemble tables, but internally, they're just text blocks, which can cause Acrobat to guess the column boundaries incorrectly.
Scanned or image-based PDF
If the PDF is scanned, Acrobat uses OCR, which may not accurately detect columns.
Irregular spacing or formatting in the source PDF
Even slight misalignment in the original file can cause columns to shift after export.
Please try the following in Acrobat Pro:
Enable OCR for scanned PDFs
Go to Tools > Scan & OCR
Click Recognize Text
Choose 'In This File', then re-run the export to Excel
This helps Acrobat detect each cell more accurately.
Repair the table structure before exporting
Go to Tools > Accessibility
Select Reading Order
Highlight the table area and mark it as Table, then tag the header and data cells
Re-export the PDF to Excel afterward.
Use Acrobat's Export PDF options
Open the PDF
Go File > Export To > Spreadsheet > Microsoft Excel Workbook
In the export dialog, check for table detection or layout options
These can improve column accuracy.
Please let us know if this helps or if you have any further questions.
Thanks,
^BS
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.