'%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 Extract a Table from an Image with Microsoft Copilot
Question details
The user needs to extract a data table from a screenshot embedded inside a PDF using Microsoft Copilot.
- Product
- Microsoft Copilot
- Device & OS
- not provided
- Scenario
- Attempting to convert an image of a table into structured, editable spreadsheet data.
- Observed behavior
- The extraction process fails or is unclear, as this capability is highly dependent on the specific Microsoft Copilot product tier and the organization's tenant configuration.
Confirm that your Microsoft 365 account has the correct Copilot licenses assigned and that your organization's IT administrator has enabled image and document processing features.
Consult the Official Microsoft Copilot Community
Since image-to-table extraction capabilities vary widely based on tenant configurations, contacting Microsoft's dedicated support channels is the most effective way to resolve licensing and feature access issues.
Microsoft Copilot's ability to process screenshots and extract tabular data from PDFs depends heavily on your specific enterprise environment. If the feature is missing or not working, it usually requires administrative troubleshooting or specific licensing checks.
Navigate to the Copilot for Microsoft 365 community forum at techcommunity.microsoft.com to search for similar image extraction issues.
Go to the Microsoft Q&A portal (learn.microsoft.com/en-us/answers/questions/ask/) and draft a new question describing your PDF screenshot issue.
Apply the 'Microsoft Copilot for Microsoft 365' tag to your post so that the dedicated support team and community experts can find and address your tenant configuration query.
Extract Tables from Images Instantly with WPS Office OCR
If your Microsoft Copilot configuration restricts image processing, you can bypass the complex tenant settings entirely. WPS Office features powerful, built-in OCR (Optical Character Recognition) tools designed specifically to extract tables from images and screenshots, instantly converting them into editable spreadsheets.
- 1. Open WPS Spreadsheet: Launch WPS Office on your computer and create a new blank spreadsheet.
- 2. Access the OCR Tool: Navigate to the 'Tools' tab on the top ribbon and click on the 'Picture to Excel' or 'OCR' option.
- 3. Upload your Screenshot: Select the image or PDF screenshot containing the table you want to extract and load it into the workspace.
- 4. Convert and Save: Click 'Convert'. WPS Office will automatically recognize the tabular data and generate an editable spreadsheet that you can format and save.
Frequently Asked Questions
Can I use Copilot to turn a picture of a table into Excel data?
Yes, but it depends on your version of Copilot. Copilot in Excel or Copilot for Microsoft 365 can process images if the tenant allows it, but you may need to prompt it specifically to 'extract data from this image into a table'.
Why is Copilot unable to read the screenshot in my PDF?
Copilot's ability to read images inside PDFs may be restricted by your organization's data policies, tenant configuration, or the specific PDF viewer integration you are using.
What is the best alternative for extracting tables from images?
If Copilot isn't working for your specific file, using dedicated OCR software like WPS Office's 'Picture to Excel' tool is often much faster and doesn't require enterprise cloud setups.
