excel pdf option import not shown

Question

pdf import option not shown

Answer 1

Dear @Sonai Muthu, 

Thank you for posting your question in the Microsoft Q&A forum.  

As a moderator, I don't have the tools to investigate your specific account directly. Because this is a user-to-user support forum. Moderators, contributors including external Microsoft employees cannot directly intervene in Microsoft product features or access back-end systems. Our role is limited to providing technical guidance on reported issues, requests, or ideas. However, I will try my best to guide you as clearly as possible.   

First, so I can identify the root cause of this issue (as it could be due to the app, your account, etc.), please help me answer a few questions and run some tests. This will help me narrow down the cause: 

• Go to File > Account and look under Product Information. Please help me take a screenshot of your Product Information so I can see exactly which product and version you are using. Based on the documentation I’ve read, this feature is only available as part of an Office 365 subscription. Seeing your screenshot will help me confirm this.

References: 

Announcing data import from PDF documents | Microsoft Community Hub 

Power Query data sources in Excel versions - Microsoft Support 

• I noticed you are using an 'edu' tag. If that is the case, you are likely using an education subscription, which means you have access to Excel for the Web. Could you please open Excel in your web browser, go to the Data tab > Get Data, and check if the PDF option appears as shown in the image below? 

• Also, please try opening Excel in Safe Mode to see if the option appears there. To do this, press the Windows logo key + R on your keyboard, type excel /safe, and click OK. 

Please help me by providing the results of these three checks. This will help me determine if the issue is related to your account or your Excel app. 

I am looking forward to your response so we can move forward with this!