Hello. We want to convert a consolidated statement from PDF to Excel. It's five pages with headers and footers that should have 167 rows of data. Instead the row data is put into five rows. Is there a setting we are missing? When we upload the PDF to Adobe for conversion, it comes back as we expect. I would like to attach the source PDF, the results from PDF Tools and the results from Adobe. Thank you for your help.
Chris
PDF to Excel combies page of table data into one row instead of separating rows
Moderators: TrackerSupp-Daniel, Tracker Support, Vasyl-Tracker Dev Team, Chris - Tracker Supp, Sean - Tracker, Tracker Supp-Stefan
-
- User
- Posts: 2
- Joined: Thu Dec 03, 2020 4:19 pm
- TrackerSupp-Daniel
- Site Admin
- Posts: 8593
- Joined: Wed Jan 03, 2018 6:52 pm
Re: PDF to Excel combies page of table data into one row instead of separating rows
Hi, csfreimuths
The option you are looking for is in the Editor preferences (Ctrl+K), under "convert from PDF > excel > setup" if you change this setting to "line" mode, it should result in a more normal conversion. This is actually intended to be the default setting, and should be changing in the next release as well.
Kind regards,
The option you are looking for is in the Editor preferences (Ctrl+K), under "convert from PDF > excel > setup" if you change this setting to "line" mode, it should result in a more normal conversion. This is actually intended to be the default setting, and should be changing in the next release as well.
Kind regards,
Dan McIntyre - Support Technician
Tracker Software Products (Canada) LTD
+++++++++++++++++++++++++++++++++++
Our Web site domain and email address has changed as of 26/10/2023.
https://www.pdf-xchange.com
Support@pdf-xchange.com
Tracker Software Products (Canada) LTD
+++++++++++++++++++++++++++++++++++
Our Web site domain and email address has changed as of 26/10/2023.
https://www.pdf-xchange.com
Support@pdf-xchange.com
-
- User
- Posts: 2
- Joined: Thu Dec 03, 2020 4:19 pm
Re: PDF to Excel combines page of table data into one row instead of separating rows
I've set the Option to Line. There are extra rows in the output but the data is still bunched into a row per page. Left is Option : Paragraph. Right is line.
Here's the PDF, too.
Please let me know your recommendation.
Thank you.
Chris
Here's the PDF, too.
Please let me know your recommendation.
Thank you.
Chris
- TrackerSupp-Daniel
- Site Admin
- Posts: 8593
- Joined: Wed Jan 03, 2018 6:52 pm
Re: PDF to Excel combies page of table data into one row instead of separating rows
Hi, csfreimuths
I see this document contains some sensitive data. As such this case is not something I believe we should handle over the public forums. Could I ask you to please email us with a copy of the PDF document itself, as a screenshot like this is not enough for us to work with and investigate.
Our email is support@pdf-xchange.com
Please also include a link to this post for context.
Kind regards,
I see this document contains some sensitive data. As such this case is not something I believe we should handle over the public forums. Could I ask you to please email us with a copy of the PDF document itself, as a screenshot like this is not enough for us to work with and investigate.
Our email is support@pdf-xchange.com
Please also include a link to this post for context.
Kind regards,
Dan McIntyre - Support Technician
Tracker Software Products (Canada) LTD
+++++++++++++++++++++++++++++++++++
Our Web site domain and email address has changed as of 26/10/2023.
https://www.pdf-xchange.com
Support@pdf-xchange.com
Tracker Software Products (Canada) LTD
+++++++++++++++++++++++++++++++++++
Our Web site domain and email address has changed as of 26/10/2023.
https://www.pdf-xchange.com
Support@pdf-xchange.com