Extract data from screenshots into Excel with Claude Cowork | Alpha | PandaiTech

Extract data from screenshots into Excel with Claude Cowork

Provide a folder of data-heavy images for Claude to analyze and reorganize into a complete spreadsheet featuring data comparisons.

Learning Timeline
Key Insights

The Advantages of Multi-Step Planning

Claude Cowork doesn't just jump into a task blindly. It has the capability to 'plan and reason' beforehand. This is extremely useful for complex tasks involving multiple image files, ensuring more consistent spreadsheet results.

Tips for Future Data Updates

If there are new AI models or additional data, simply add the new screenshots to the same chat. Claude can 'massage' or update the existing spreadsheet file without needing to rebuild everything from scratch.
Prompts

Screenshot Analysis & Spreadsheet Generation

Target: Claude Cowork
I have provided access to a folder containing screenshots of various AI model benchmarks. Please analyze all the images, extract the data points, and compile them into a comprehensive Excel spreadsheet. Organize the data to compare Anthropic, OpenAI, and Google models fairly. Use multiple tabs if necessary to make the data clear. Push yourself to impress me.
Step by Step

Extract Screenshot Data to Excel with Claude Cowork

  1. Create a dedicated folder on your computer containing all the screenshots you want to analyze.
  2. Open Claude Cowork and grant access to that folder through the tool interface.
  3. Enter a prompt that provides clear context about the images and state your final objective.
  4. Ensure your prompt includes instructions to generate a spreadsheet that organizes the data logically and includes comparative elements.
  5. Include the instruction 'Push yourself to impress me' in your prompt to encourage Claude to provide more comprehensive and creative results (such as detailed tab breakdowns).
  6. Allow Claude to execute a 'multi-step plan' where it strategizes the analysis before processing the files.
  7. Review the generated spreadsheet to ensure all data from the screenshots has been extracted and categorized correctly (e.g., AI model comparisons).
  8. Save the file to your local file system through a command to Claude.

More from Boost Productivity & Research with AI

View All