Link to home
Start Free TrialLog in
Avatar of Cindy
CindyFlag for United States of America

asked on

How to Copy or Convert a PDF Excel Table into an Excel Spreadsheet

I have an PDF document that has an Excel table with split Rows and columns.  How do I copy the entire table with formatting of data in the split rows and columns from PDF to Excel?  so I will not have to retype the entire table into an excel spreadsheet.  Thanks.
Doc5.docx
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

It depends on how the PDF was created in the first place.

It could be an image of the table or you might be lucky that it is selectable as text. What happens if you try to select the text as if it were an ordinary document?

If it selects like an ordinary document would then you're in luck. There are numerous PDF converter applications that will convert it for you.

If it selects the whole document then it is likely an image.
Avatar of Cindy

ASKER

It selects like an ordinary document.  Not like an image.
Avatar of Cindy

ASKER

Can you provide a PDF converter that I can use?  The cells are split into rows and columns.  Will the conversion include the split rows and columns formatting as designed?  Thanks.
A Google search will provide plenty of PDF Converters ranging from Free/Trial versions through to costly professional versions.

I don't know enough about any of them to be able to recommend but I suspect there are similar questions on here if you do a search using the search option at the top of the screen which will include recommendations.
ASKER CERTIFIED SOLUTION
Avatar of Joe Winograd
Joe Winograd
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I have successfully used Wondershare pdfelement and recently purchased Nitro PDF pro and used that.
Avatar of Cindy

ASKER

All provided me with great information to help me successfully complete my project.  I have some additional work to do the spreadsheet, but this was a tremendous helping in getting where I need to go for prepping the document.  Thank you such for your help.
You're very welcome, Cindy. Good luck on completing the project. Regards, Joe