How to import data from pdf to excel?
1 answer(s)
Excel has a tool built right in for this. It's quite easy.
First, go to the 'Data' tab at the top. Then look on the left for 'Get Data'. Click that, then go to 'From File', and then choose 'From PDF'.
Just find your PDF document and open it. A new window will pop up. It shows you all the tables it found in the file. You just need to pick the table you want and click the 'Load' button. The data will then go straight into a new worksheet for you. Hope that helps, cheers.