failure to convert pdf to excel properly

"For example, if I try to covert or copy and paste the number 395.49, it converts to F,1o5,"

Copy and paste doesn't convert it. You will get what is stored in the PDF file. It is a issue of the font encoding.

Hi Basia,

Thank you for reaching out.

Would you mind sharing the PDFs that you are trying to convert?

Also, share the converted Excel sheet. 

As there is an issue in translation, please confirm if the PDF was created by you in the Acrobat application or received from an external source.

Thanks,

Meenakshi

Portable Document Format files are not like word processing or spreadsheet files, meaning they don’t contain formatting, rows, and columns. In order for the regular PDF to Excel conversion to give accurate results, the PDF file (and any table inside it) needs to be tagged.

Since dealing with a tagged PDF is such a rare case that you’ll encounter, the most common practice is to simply accept the fact that the quality of your conversion results will be poor and to manually clean up the content using the spreadsheet application of your choice afterward.

Fortunately, there’s a better way to go about PDF to Excel conversion formatting problems. Follow along as we explain how to get accurate results and extract tables that will be useful from the get-go by using Able2Extract Professional – PDF to Excel converter software recommended by professionals from various industries dealing with a massive amount of spreadsheet data locked inside PDFs.

With Custom PDF to Excel advanced options in Able2Extract Professional, you can change up the table selection, set up table structure, manually edit rows and columns, and preview the end result prior to the conversion.

These features help you create a tailored conversion layout so you can get the tables and data you need perfectly formatted and set up for your spreadsheet before you even convert the PDF content.

In the following example, we’ll demonstrate how to use the Custom Excel feature in order to change the layout created automatically by the program.

Notice that the PDF page in this example has two tables surrounded by text.

PDF page with tables surrounded by text

Performing a regular PDF to Excel conversion will result in a spreadsheet that needs a lot of follow-up work in order to be useful. Just take a look at the results seen in this image below:

Automatic PDF to Excel conversion resulting spreadsheet

To analyze the data, you’d need to delete a large part of the text in order for your functions and formulas to work properly. Moreover, you may need a specific portion of that extra text alongside the tables. 

A solution is to use the feature that differentiates Able2Extract from all other PDF converter tools – Custom PDF to Excel.

Regards,

Rachel Gomez