Hi guys, I have a pdf with the tables, but I don't have the excel file. Is it possible to copy the pdf table to excel? There are too many numbers, so I wouldn't be able to copy one by one
Hi guys, I have a pdf with the tables, but I don't have the excel file. Is it possible to copy the pdf table to excel? There are too many numbers, so I wouldn't be able to copy one by one
Hi ShinWaka: Welcome to the forum.
Depends on the pdf. If you can select text on the pdf, select it all, try C/P into Excel. If you can't select and it's a scanned image, run OCR on the file, and try again.
If you can select, dump into Excel, and either do a text to columns to parse it out, or better yet, do a power query to break out the fields.
Pete
if you have Adobe Acrobat Pro, it can export to Spreadsheet.
alternatively, if the text is selectable, then you could try to select everything on the table, copy (CTRL+C), then click once on the first cell of excel, and paste (CTRL+V).
------------------------
Last edited by ShinWaka; 11-12-2021 at 02:56 PM.
are you clicking once on the cell, or double clicking?
clicking once on the cell just selects the cell, double clicking goes into the cell.
You can also get a PDF into excel using Power Query which is called Get & Transform Data and found on the Data Tab.
Here is a tutorial on how to make that happen.
https://www.youtube.com/watch?v=C6vqy30PDnE
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks