F5F Stay Refreshed Software General Software PDF to Excel font issue encountered

PDF to Excel font issue encountered

PDF to Excel font issue encountered

E
enoga
Junior Member
Find
21
11-10-2023, 05:05 AM
#1
Hi,
I'm attempting to transform a collection of PDFs into Excel files. The documents are easily readable in Adobe Acrobat Pro, but when converting to Excel the text appears as brief lines. I've included a link for you to review the image. This situation matches the problem described in a post on the Adobe forum.
Reply
Reply
E
enoga
11-10-2023, 05:05 AM #1

Hi,
I'm attempting to transform a collection of PDFs into Excel files. The documents are easily readable in Adobe Acrobat Pro, but when converting to Excel the text appears as brief lines. I've included a link for you to review the image. This situation matches the problem described in a post on the Adobe forum.

Reply
Reply
C
cowcow4321
Senior Member
Find
623
11-10-2023, 08:35 AM
#2
Not certain about all the efforts made.
Disclosure: I didn’t download the linked image.
My idea is that Excel isn’t properly configured or set up to import the target PDF table correctly.
Perform a Google search for "Excel import pdf table" and restrict it to the past year.
Adjust the search terms as you read and learn.
Use a copy of the original PDF and test the Excel import settings.
After achieving the right format, you can adjust the font settings if needed.
Reply
Reply
C
cowcow4321
11-10-2023, 08:35 AM #2

Not certain about all the efforts made.
Disclosure: I didn’t download the linked image.
My idea is that Excel isn’t properly configured or set up to import the target PDF table correctly.
Perform a Google search for "Excel import pdf table" and restrict it to the past year.
Adjust the search terms as you read and learn.
Use a copy of the original PDF and test the Excel import settings.
After achieving the right format, you can adjust the font settings if needed.

Reply
Reply
B
BBlogan_
Junior Member
Find
5
11-19-2023, 03:02 AM
#3
The .pdf format is considered an end format and is only meant for displaying the document, not for any further processing.
Reply
Reply
B
BBlogan_
11-19-2023, 03:02 AM #3

The .pdf format is considered an end format and is only meant for displaying the document, not for any further processing.

Reply
Reply
J
jrobbs7
Member
Find
235
11-19-2023, 07:31 AM
#4
I was considering the approach from the guide at https://www.howtogeek.com/770474/how-to-...oft-excel/.
It mentioned "trying to convert a series of PDFs into excel documents".
Could you share more details or examples about what you need?
Please include any screenshots of the original files, making sure to remove personal information.
You can send them to imgur using the provided link.
Reply
Reply
J
jrobbs7
11-19-2023, 07:31 AM #4

I was considering the approach from the guide at https://www.howtogeek.com/770474/how-to-...oft-excel/.
It mentioned "trying to convert a series of PDFs into excel documents".
Could you share more details or examples about what you need?
Please include any screenshots of the original files, making sure to remove personal information.
You can send them to imgur using the provided link.

Reply
Reply
J
JPP_Miam
Member
Find
108
11-20-2023, 09:28 AM
#5
The PDF is generated from an invoicing tool that typically uses Arial font. However, imgur is restricted on the work network. It seems the files might have been created incorrectly. I suggest the end user attempt a different method—using the export to PDF feature directly in Adobe Acrobat Pro would be quicker.
Reply
Reply
J
JPP_Miam
11-20-2023, 09:28 AM #5

The PDF is generated from an invoicing tool that typically uses Arial font. However, imgur is restricted on the work network. It seems the files might have been created incorrectly. I suggest the end user attempt a different method—using the export to PDF feature directly in Adobe Acrobat Pro would be quicker.

Reply
Reply
I
Ironchicken121
Member
Find
59
11-26-2023, 05:26 PM
#6
Fonts are just for appearance. Based on what I need, you only require the invoice information in a format compatible with Excel import.
Could you confirm if the invoicing system allows exporting data in formats like .csv, .xls_, or .txt?
It’s helpful if the software can send data directly through its tables (database?) rather than requiring the invoice/report structure.
Direct import to Excel and other programs would be ideal.
Exporting via PDF might be quicker, but only if the final file can still be imported correctly.
Reply
Reply
I
Ironchicken121
11-26-2023, 05:26 PM #6

Fonts are just for appearance. Based on what I need, you only require the invoice information in a format compatible with Excel import.
Could you confirm if the invoicing system allows exporting data in formats like .csv, .xls_, or .txt?
It’s helpful if the software can send data directly through its tables (database?) rather than requiring the invoice/report structure.
Direct import to Excel and other programs would be ideal.
Exporting via PDF might be quicker, but only if the final file can still be imported correctly.

Reply
Reply