How to Import PDF to Excel // #shorts

this micro tip will show you how to import pdf table data right into excel without any add-ins or extra tools so here's a pdf i have opened it has a bunch of different information what i really want is this table right here now if i selected this table normally and copied it and tried to paste into excel it's a bunch of junk so let's do it the right way 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 dialogue 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 if i wanted to change the data maybe i didn't want a certain column in here you want to get rid of it i could click transform data and go modify it before importing but i'm just going to click load right here and there it is it's imported right into excel this is a fully sortable table everything i can normally do with excel directly from my pdf

Channel: Mike Tholfsen

Views: 641,060

Keywords: import pdf to excel, pdf to excel, pdf to excel table, convert pdf to excel, convert pdf to excel file, convert pdf to excel without software, import pdf into excel, excel, import, excel 365, excel data from pdf, excel tips and tricks, convert pdf into excel, how to convert pdf into excel file, microsoft excel, microsoft 365, Mike Tholfsen, import pdf to excel spreadsheet, how to import pdf to excel sheet, import data from pdf to excel, how to import pdf file in excel sheet

Id: _5nGeEwx9ZI

Length: 0min 58sec (58 seconds)

Published: Tue Feb 16 2021