How to form an excel sheet using the picture
- User
How to form an excel sheet using the picture
Assistant
To create an Excel sheet from a picture, use Excel's Data from Picture feature, which converts images of tables into editable data. Here's how to do it across devices:
Desktop (Windows/Mac)
- Capture the image: Take a screenshot (Windows:
Win + Shift + S/ Mac:Cmd + Shift + 4) or save a photo of the table[3][7]. - Import into Excel:
- Go to Data > From Picture > Picture from File (or Picture from Clipboard for screenshots)[1][7].
- Select the image and click Open.
- Review and correct:
- Excel analyzes the image and displays a preview. Use Review to fix errors (e.g., misread text or numbers)[2][7].
- Click Insert Data to finalize[1][2].
Mobile (iPhone/Android)
- Open the Excel app and create a new workbook[6].
- Insert Data from Picture:
- Tap Insert > Data from Picture.
- Capture a new photo or select an existing image[1][6].
- Adjust and confirm:
- Crop the image to focus on the table and tap Confirm[1][6].
- Edit any errors in the preview and tap Insert[6].
Tips for Best Results
- Image quality: Use clear, well-lit, head-on photos[1][2].
- Crop extraneous content: Remove non-table elements before importing[1][7].
- Supported languages: Works for English, Spanish, French, German, and 17 other languages[1][6].
Alternative Tools
- Microsoft 365 app: Use Actions > Image to Table for direct camera-to-spreadsheet conversion[1].
- Google Sheets + OCR: Upload the image to Google Drive, open with Docs, and copy extracted text into Sheets[5].
- Third-party apps: ABBYY FineReader or CamScanner for complex tables[5].
Excel’s AI-powered tool saves time but may require minor corrections for accuracy[2][7]. For repeated use, ensure consistent image formatting to streamline the process[1][5].
- Capture the image: Take a screenshot (Windows:
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.