Share via

Copy and Paste a Table from a pdf into word

Anonymous
2019-10-04T09:49:43+00:00

Hi

When I open up a pdf and it has a remittance advice in a table.  I highlight the data which would be on several pages.  I copy that data control C and then go to excel to paste the data. 

The problem is that the table does not come out properly on excel

What is the best way to do this.

Zia

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. DaveM121 871.3K Reputation points Independent Advisor
    2019-10-04T09:53:28+00:00

    Hi Zia

    It really depends on how that PDF file was put together . . .

    Open Microsoft Word, then choose File - Open and try to open that PDF file in Word

    Does the table render correctly in Word?

    If so, you should be able to copy and paste that table from Word into Excel . . .

    If not, when you paste that into Excel, are all columns ending up in the same column - if possible, please provide a screenshot of that pasted data, so I cam work out what is happening and how to provide a solution for you . . .

    3 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-10-04T12:41:06+00:00

    Hi Dave 

    That works perfectly. 

    Thank you 

    Zia

    0 comments