How to Convert PDF to Excel - EASY

preview_player
Показать описание
How to convert PDF to Excel? In this tutorial, I show you how to convert a PDF file to Excel spreadsheet. This means you can import data from a PDF into Excel for free without any software. Converting an Adobe PDF into a Microsoft Excel is easy and can include all PDF formatting, data, and tables. Let me know in the comments if you have any questions while you convert a PDF to Excel.

Follow the steps below to convert PDF to Excel:
1. Open Excel on your Windows 10 computer or Mac.
2. In the top menu of excel make sure you are on the Data ribbon.
3. In the Data ribbon, select Get Data then From File.
4. Under From File, select From PDF.
5. In the PDF navigator, select the portion of the PDF file you want to import to Excel. This can be the whole page, a table, or selected data.
6. Once ready to import the PDF data to Excel, select Load at the bottom of the window.

#Excel #PDF #MicrosoftExcel

Convert PDF to Excel Timestamps:
Intro - 00:00
Sample PDF with table - 00:20
How to Import PDF Data into Excel - 00:30
Outro - Please Subscribe - 2:12

Disclaimer: Some of the links in this description are affiliate links. As an Amazon Associate and a partner of other affiliate programs, this mean I earn a small commission from qualifying purchases through these links. This helps support the channel and allows us to continue to make videos like this. Thank you for the support!

😀 SUPPORT THE CHANNEL 😀 (Paid links)

FOLLOW ME!

HOW DO I DO IT? (Paid Links)
Рекомендации по теме
Комментарии
Автор

I can not find the PDF when i click " get data then file " there is not PDF option in my excel. I`m using the MacOS version of Office 365.

walkeraraujoataide
Автор

The best explanation I have seen - thank you a thousand times!

donaldcrain
Автор

I was literally looking for that this morning. Thx!

hardwin
Автор

When loading to excel it split my pdf data into two tables and the first row in excel combined the first two rows from the pdf. There also were two rows missing. For example my first excel row looked like this: Smith, Joe Jones, Harry....and each additional column contained the data from row 1 and row 2

ciruzzi
Автор

You are a life saver! Thank you so much.

soniakim
Автор

i can not find the PDF when i click " get data then file " there is not PDF option in my excel . how can i enable that option ?

LiveTesla
Автор

Perfect timing! You are a lifesaver! I was trying to do this for almost 2 hrs last night, and completely gave up! Thank you, sir! This is why I’m subscribed!

BTW…do you still review watches?

feartheroo
Автор

Fantastic explanation solved my issue in under 5 minutes!

jb
Автор

thank you! is there a way to select to load multiple pages and/or tables at the same time?

keleelee
Автор

import from file was there for me but not my wife’s work computer. i clicked customize this ribbon but couldn’t find the get info command.

limited
Автор

can i do this for 12 pdf's all at once and have them go into one annual xls file?

helinghaus
Автор

You are working on office 365 version. But how will we do those who hv older version?

parthasen
Автор

Hello, I don't have a option for import data > PDF :l is there another way to do this? Does this require Microsoft 360? I don't have Microsoft 360

MidnyteKitten
Автор

Hi, I'm running Excel on a MAC - There is no "file" option when going to Get Data pull down, only from database, HTML, text or SQL server - ant idea how to imprt the PDF is file isn't a choice in get data?

TheGpagano
Автор

와우 엑셀은 정말 대단하네요 이런 기능이 있다니요 정말 감사해요. PDF 하나하나 타이핑 덕분에 밤세지 않고 퇴근시간을 당겼습니다. 땡큐땡큐

betty
Автор

how to convert 9 page PDF to single excel sheet

thiyagarajank
Автор

It keeps telling me the folder or file is empty.

sarahwhite
Автор

PDF is not a file option in Excel for Mac

THerd-umtl
Автор

I just don't have that option. what should I need to do?

joeljefferson
Автор

You haven't converted PDF to Excel, you have just imported a table from PDF to excel...

vsenikizanety