'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix the Missing PDF Connector in Excel Power Query
Question details
The user is unable to find or use the PDF import option in Excel Power Query to extract data from PDF files.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to import and transform data from a PDF document into an Excel spreadsheet using Power Query.
- Observed behavior
- The 'From PDF' option is completely unavailable or missing from the Data tab and Power Query connector list, despite Excel appearing to be up to date.
Verify your current Microsoft Office license, as the native Power Query PDF connector is currently exclusive to specific Microsoft 365 subscription tiers and may not be available in standalone versions like Office 2019 or 2021.
Convert the PDF to Excel or CSV Format Before Importing
If your Excel version lacks the PDF connector, converting the PDF into a spreadsheet format using trusted desktop software is the safest and most reliable workaround.
Instead of relying on online converters which can compromise sensitive information, use a dedicated desktop PDF editor to extract the tables.
Once converted, you can seamlessly import the resulting file into Power Query for further data transformation.
Launch a trusted PDF editing software like WPS Office or Adobe Acrobat that includes file conversion features.
Select the 'PDF to Excel' or 'PDF to CSV' conversion tool, select your document, and save the output to your local drive.
Open Excel, go to the 'Data' tab, click 'Get Data', and select 'From File' > 'From Workbook' or 'From Text/CSV' to load your extracted data into Power Query.
Check Microsoft 365 License and Update Excel
Ensure you are signed into an eligible Microsoft 365 account and that the latest feature updates have been installed to your Office applications.
Easily Convert and Extract PDF Data with WPS Office
Bypass Excel's restrictive version requirements entirely. WPS Office includes a powerful, built-in PDF to Excel converter that accurately extracts tables and data from PDF documents without needing complex Power Query setups.
- 1. Launch WPS Office: Open the WPS Office desktop application on your computer.
- 2. Access the PDF toolkit: Click on the 'PDF' tab or go to 'Tools' in the main interface.
- 3. Select PDF to Excel: Click the 'PDF to Excel' option and upload the PDF file containing the data you want to extract.
- 4. Convert the document: Click 'Convert'. WPS will automatically recognize tables and text, transforming them into a formatted spreadsheet.
- 5. Save or Edit: Save the newly created file as a standard .xlsx document, which can now be opened seamlessly in any spreadsheet software.
Frequently Asked Questions
Is the Power Query PDF connector available in Excel 2019 or 2021?
No, the native 'From PDF' data connector in Power Query is a premium feature exclusive to Microsoft 365 subscription versions of Excel. Standalone versions like 2019 and 2021 do not include it.
Are online PDF to Excel converters safe to use for business data?
It is not recommended to use free online converters for confidential or sensitive business data, as your files are uploaded to external servers. Always use trusted local desktop software like WPS Office or Adobe Acrobat for secure conversions.
Why does my converted PDF data look messy when imported into Excel?
If a PDF contains unstructured text rather than distinct tables, standard converters may struggle to align columns properly. For best results, use a PDF converter equipped with OCR (Optical Character Recognition) to properly identify and map table borders before importing into Excel.
