Converting PDF to Excel and Issue with Structure and Character Artifacts

Question

I am trying to convert a standard report from a tax software application to Excel. Screenshots of a standard snippet from the PDF report and the Excel conversion result are below. I think the starting point is finding some way to systematically remove the box graphics; once those are removed, a lot of the structure issues are easier to address. I think.

But I am desperate. The software vendor has confirmed they have no way to get these reports in Excel rather than PDF, not that they're willing to invest in, at least. But figuring this out would save a lot of time.

PDF with Structure and Formatting:

Excel Conversion Result:

accountingforme · Answer

One update, I was able to figure out that the root cause is the wingdings font. If I can select and delete all the instances of text with wingdings font I think that will go a long way towards clearing this up.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded