From the course: 20 Nano Tips for Maximizing Excel with Mike Tholfsen

How to import PDF data in Excel

From the course: 20 Nano Tips for Maximizing Excel with Mike Tholfsen

Start my 1-month free trial

How to import PDF data in Excel

“

- [Instructor] How to import PDF table data right into Excel. So here's a PDF I have opened, and it has a bunch of different information. What I really want is this table right here. Switch to the Data tab here and then choose Get Data, and then go to From File and choose From PDF right here. Now select Sample Data and click Import. This brings up the little dialog that lets you select the data, so here are the different tables that it found in that PDF. So I don't want that one, I don't want that one. Ah, here's the one that I want, all the speed driver car information. Click Load right here, and there it is. It's imported right into Excel.

Contents