How do I convert a PDF file to an Excel file and access its data?

my work is pdf file convert to excel file and work from data but not data tab and file option not show pdf file please provide this fratures



[Re-Titled by Moderator]


Mac mini, macOS 15.3

Posted on Mar 27, 2025 10:48 PM

Reply
Question marked as Top-ranking reply

Posted on Mar 28, 2025 4:28 AM

This works well. If a column has a plain email or URL, Adobe will hyperlink it during the conversion process.


The Windows 11 version of Microsoft 365 or Office 2021/2024 can use the Excel Data menu > Get Data > From PDF and do a direct conversion from the PDF table right into the Excel spreadsheet. The Mac versions do not offer this feature, nor does LibreOffice Calc.

5 replies
Question marked as Top-ranking reply

Mar 28, 2025 4:28 AM in response to TheLittles

This works well. If a column has a plain email or URL, Adobe will hyperlink it during the conversion process.


The Windows 11 version of Microsoft 365 or Office 2021/2024 can use the Excel Data menu > Get Data > From PDF and do a direct conversion from the PDF table right into the Excel spreadsheet. The Mac versions do not offer this feature, nor does LibreOffice Calc.

Mar 28, 2025 8:35 AM in response to VikingOSX

This works well. If a column has a plain email or URL, Adobe will hyperlink it during the conversion process. The Windows 11 version of Microsoft 365 or Office 2021/2024 can use the Excel Data menu > Get Data > From PDF and do a direct conversion from the PDF table right into the Excel spreadsheet. The Mac versions do not offer this feature, nor does LibreOffice Calc.

———-


Thanks for the info!

Mar 28, 2025 8:44 AM in response to TheLittles

On Sequoia v15.3.2, I opened a PDF containing a spreadsheet in Word v16.95.1 and it converted it to a perfect Word table in the resulting DOCX.


I could then copy that Word table to the clipboard and use Excel Paste Special in an open Excel 16.95.1 spreadsheet. That Paste Special offers an alternative link feature that creates an active Excel spreadsheet that updates when the Word table is changed.

Mar 28, 2025 8:58 AM in response to rohit_patel

"How do I convert a PDF file to an Excel file and access its data?: my work is pdf file convert to excel file and work from data but not data tab and file option not show pdf file please provide this fratures"

-------


Ask this in the Microsoft Community.

Being Excel is a Microsoft product…

  1. Go Here: Microsoft 365 and Office - Microsoft Support Community
  2. Select: Excel” for “Apps
  3. Tap: Ask a new question


Note: You’ll need to create a login profile for this site, if you don’t already have one. Already having registered Office, you would have provided your eMail for its registration. So, that is the eMail address I recommend you use.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How do I convert a PDF file to an Excel file and access its data?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.