PDF table does not export correctly to Excel

Forum for the PDF-XChange Editor - Free and Licensed Versions

Moderators: PDF-XChange Support, Daniel - PDF-XChange, Chris - PDF-XChange, Sean - PDF-XChange, Paul - PDF-XChange, Vasyl - PDF-XChange, Ivan - Tracker Software, Stefan - PDF-XChange

Davide78
User
Posts: 171
Joined: Fri Mar 10, 2023 9:14 pm

PDF table does not export correctly to Excel

Post by Davide78 »

Hello, a PDF document contains a table intended as a "structure" composed of rows and columns, but its export to Excel is very messy.
The starting table is actually very clean, the divisions of rows and columns are missing graphically but the structure is clear.
Is it possible to make some changes to the PDF file to facilitate a correct export?
Greetings
User avatar
Daniel - PDF-XChange
Site Admin
Posts: 11036
Joined: Wed Jan 03, 2018 6:52 pm

Re: PDF table does not export correctly to Excel

Post by Daniel - PDF-XChange »

Hello, Davide78

These 3 options will have the largest impact on the layout of the resultant Excel File, and depending on the document layout, you may need to change them on a case-by-case basis to get the best result.
image.png
Generally, the settings I have show should be the closest to a "catch all" solution, but there are always exceptions.

In any case, if you are experiencing issues with the conversion quality, it would be best if you could provide sample files, both the PDF, and the output Excel file, as well as a screenshot of your Convert to Excel settings.

Kind regards,
You do not have the required permissions to view the files attached to this post.
Dan McIntyre - Support Technician
PDF-XChange Co. LTD

+++++++++++++++++++++++++++++++++++
Our Web site domain and email address has changed as of 26/10/2023.
https://www.pdf-xchange.com
Support@pdf-xchange.com
Davide78
User
Posts: 171
Joined: Fri Mar 10, 2023 9:14 pm

Re: PDF table does not export correctly to Excel

Post by Davide78 »

I couldn't find the settings you mention.
I attach files used to explain better.
{B194FC1F-0A68-4A99-B58F-45960FE1D6FE}.png
tabella da pdf ad excel.pdf
tabella da pdf ad excel.pdf
tabella da pdf ad excel.zip
You do not have the required permissions to view the files attached to this post.
Willy Van Nuffel
User
Posts: 2746
Joined: Wed Jan 18, 2006 12:10 pm

Re: PDF table does not export correctly to Excel

Post by Willy Van Nuffel »

Hello,

Supposing you are using the latest version 10.6.0 build 396 of PDF-XChange Editor, you will see the "Convert to Excel Options" from the moment that you have clicked the File-menu > Export > Export to Microsoft Excel.

Kind regards.

Willy
User avatar
Jordan - PDF XChange
Site Admin
Posts: 254
Joined: Mon Jul 03, 2023 3:10 pm

Re: PDF table does not export correctly to Excel

Post by Jordan - PDF XChange »

Hello Davide78,

Thank you for the provided files.

In this document's case you will have a better result if you use the settings that Willy provided, but not use the "Make Invisible Text Visible..." option :
image.png
And this will produce more cleaner result:
image(1).png
I hope this helps.
You do not have the required permissions to view the files attached to this post.
Best regards,
Jordan
Davide78
User
Posts: 171
Joined: Fri Mar 10, 2023 9:14 pm

Re: PDF table does not export correctly to Excel

Post by Davide78 »

In fact your export is almost perfect...unfortunately I have a previous build, the layout of the settings window is different, but there is the same flag that you suggest me to disable...unfortunately the result is better but not as much as yours
User avatar
Daniel - PDF-XChange
Site Admin
Posts: 11036
Joined: Wed Jan 03, 2018 6:52 pm

Re: PDF table does not export correctly to Excel

Post by Daniel - PDF-XChange »

Hello, Davide78

In that case, the only solution we can offer you is to update the software to the current latest release, if you wish to benefit from the latest improvements to the software.

Kind regards,
Dan McIntyre - Support Technician
PDF-XChange Co. LTD

+++++++++++++++++++++++++++++++++++
Our Web site domain and email address has changed as of 26/10/2023.
https://www.pdf-xchange.com
Support@pdf-xchange.com
Davide78
User
Posts: 171
Joined: Fri Mar 10, 2023 9:14 pm

Re: PDF table does not export correctly to Excel

Post by Davide78 »

Unfortunately it doesn't depend on me...
I solved it using a free online service but I hope to be equipped with the most recent build of the program in the future
User avatar
Stefan - PDF-XChange
Site Admin
Posts: 19868
Joined: Mon Jan 12, 2009 8:07 am

Re: PDF table does not export correctly to Excel

Post by Stefan - PDF-XChange »

Hello Davide78,

Glad to see you resolved the issue, and hope that your IT team will update our products for you soon!

Kind regards,
Stefan