KutoolsforOffice — One Suite. Five Tools. Get More Done.

Convert Image to Table in Excel: Turn Any Picture into an Editable sheet

AuthorXiaoyangLast modified

In daily data processing tasks, we often face a common challenge: important data is trapped inside screenshots, scanned documents, or photos of paper-based tables—making it impossible to copy directly. Manually retyping this information is time-consuming, labor-intensive, and prone to errors. So, is there a more efficient solution? Today, we’ll walk you through several quick and practical methods to convert images into editable Excel tables.

convert image to table

Convert Image to Table with Picture From File feature (Excel 365)

Convert Image to Table with ChatGPT

Conclusion

🔹 Convert Image to Table with Picture From File feature (Excel 365)

Microsoft Excel 365 now offers a powerful, built-in Picture From File feature that can intelligently analyze table data embedded in images — such as scanned documents, screenshots, or photos — and automatically convert it into a clean, fully editable Excel table. This eliminates the need for manual data entry, significantly speeds up your workflow, and helps reduce human errors when working with image-based data sources.

  1. Click a cell where you want to insert the data from the picture, and click Data > From Picture > Picture From File, see screenshot:
    click Picture From File feature
  2. In the popped out window, select your image that contains the table you want to import.
    select the image
  3. Excel will show a preview and automatically start processing the data. In the Data from Picture pane, review the suggested corrections — any questionable or unrecognized values will be highlighted in red. Simply click the red-marked cell, make the necessary adjustment. Then, click Accept button.
    review and correct the suggested corrections
  4. After reviewing and correcting any remaining detected errors, click Insert Data. Excel will then automatically convert the recognized content and insert the finalized table directly into your worksheet.
    review and correct the suggested corrections

Pros：

• The feature is native to Microsoft 365, meaning you can convert images to tables instantly without installing additional tools or plugins.• Works especially well with scanned documents, invoices, receipts, and neatly formatted printed tables where data structure is consistent.• Excel visually flags potential issues in red and lets you review and fix them one-by-one before inserting data, helping ensure accuracy and completeness.

Cons:

• Available mainly in Microsoft 365. Older versions do not include this feature.• Tables with merged cells, multi-line text, or unaligned columns may not convert cleanly and may require manual corrections.• Low-quality or blurry images may fail to convert.

🔹 Convert Image to Table with ChatGPT

Sometimes Excel's Data From Picture tool doesn’t quite get it right, especially with screenshots, mixed layouts, or hand-written text. That’s where ChatGPT shines. Just upload your image, ask ChatGPT to extract the table, and you’ll get a clean, editable version you can copy straight into Excel. It's fast, flexible, and surprisingly accurate — even with tricky table formats!

  1. Open ChatGPT website, and upload or paste your image into the chat box.
  2. Then, type your instruction and clearly tell ChatGPT to extract the table from the image, such as:
    Please extract the table from this image and format it as Excel table data.
    upload pictue and type instruction
  3. Then, click Send button or press Enter key. GPT will automatically analyze the image you upload and intelligently extract the table data from it.
  4. Once the extraction is complete, click the Copy button to copy the data and paste it back into your Excel worksheet.
    copy the data into Excel

Pros：

• Unlike traditional tools that require clean, printed tables, ChatGPT can accurately extract data from website screenshots, mobile app interfaces, PDF pages, and even stylized or lightly formatted table designs.• ChatGPT performs better when working with tables that include merged cells, multi-line text, nested headers, or inconsistent spacing. It can also follow your explicit formatting instructions and normalize data during extraction, reducing manual cleanup work.

Cons:

• Since ChatGPT runs in the cloud, extracting data requires a stable internet connection and access to a capable plan. It cannot be used in offline environments or restricted networks.• While ChatGPT is powerful, poor-quality images — such as blurry photos, low-resolution screenshots, angled shots, handwritten notes, or images with glare — may lead to recognition errors. In such cases, users may need to enhance the image or manually correct the extracted data.

🔹 Conclusion

Both Excel and ChatGPT significantly accelerate the conversion of image-based tables to editable data. The ideal method depends on your input source and workflow:

  • Use Excel for quick, clean conversions
  • Use ChatGPT for advanced recognition and flexible formatting

If you frequently work with images or scanned tables, consider integrating both tools into your data workflow for maximum efficiency.

Best Office Productivity Tools

🤖Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions…
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |  Round without Formula ...
Super Lookup: Multiple Criteria VLookup  |   Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |  Big Formula Bar   |  Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells   |  Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets:  12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more
Use Kutools in your preferred language – supports English, Spanish, German, French, Chinese, and 40+ others!

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

All Kutools add-ins. One installer

Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.

ExcelWordOutlookTabsPowerPoint
  • All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
  • One installer, one license — set up in minutes (MSI-ready)
  • Works better together — streamlined productivity across Office apps
  • 30-day full-featured trial — no registration, no credit card
  • Best value — save vs buying individual add-in