Exporting PDF To Excel (Format Problems)

Question

Hi all! I have the following PDF that I'm trying to export to and Excel format.

I'm having trouble getting the formatting right so the data ends up in the correct cells. Here's the resulting Excel document.

Link To Excel Document

All the data ends up in one row. That's not so helpful. After experimenting further I tried exporting as a Word document, copying the contents of the table from that document, then pasting that information into a blank Excel workbook. Here is what that looks like.

Link To Word Document

Link To New Excel Document Using Pasted Data From The Above Word Document

As you can see, this is closer to what I'm after however the rows and data still don't line up correctly.

Any tips on how to accomplish this would be helpful.

Dipesh - T1000 · Accepted Answer

Sorry I think I got the above instructions wrong.

In Step 3, you need to click on the 'Delete Tag' option so all the tags disappear from the list.

Then if you convert the document, it looks like it should.

girijaAgarwal · Answer

Hi Loufubu7,Thank you for reporting the issue.It seems the problem lies in the tag structure embedded in the document for the table. The table contains almost all content in a single row and hence such output.I suggest you to try the following and see if that works for you:1. launch Acrobat and open the pdf2. Expand the left hand panel and click on "Tags:View and Edit structured PDF information"3. Right click on the "Tags" and then "Delete Tag"4. Right click on "No Tags Available" -> "Add Tags to Document"5. Now try exporting this pdf to excelI hope this helps!Thanks and Regards,Girija AgarwalaSoftware Engineer IIAdobe Systems

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