# Extract a table from an image or screenshot into a spreadsheet

Turn a photo, screenshot, or scanned list into clean tab-separated rows you can paste straight into Excel or Google Sheets.

- Topic: Data & Analysis
- Framework: Few-Shot
- Level: Standard
- Tags: Design, Data & Analytics, Fill-in Template
- Source: https://www.thinkwithprompt.com/prompts/extract-a-table-from-an-image-or-screenshot-into-a-spreadsheet

## Prompt

```text
Extract the data from the image I've attached into a spreadsheet-ready table.

**What the image shows:** [e.g. "a list of companies", "a receipt", "a printed price list", "a table in a slide"]
**Columns I want:** [e.g. "Name, Ticker, Exchange" or "keep the columns as shown"]
**Formatting rules:** [e.g. dates as YYYY-MM-DD, numbers without currency symbols, lowercase codes]
**Extra columns to add (optional):** [e.g. "a category for each item", "the country for each city" - information not shown in the image]

Rules:
- Copy text exactly as it appears. Do not correct spellings or guess at blurry characters - mark unreadable cells as [UNCLEAR].
- Keep one row per item, in the order shown.
- Split combined values into separate columns only if I asked.
- If I asked for extra columns with information that is not in the image, put them in a separate column and mark any you are not certain of with [CHECK]. Never present a guess as fact.

Return:
1. The table as tab-separated values inside a code block, with a header row, so it pastes into separate columns.
2. The same data as a Markdown table for a quick visual check.
3. A short list of cells marked [UNCLEAR] or [CHECK] so I can verify them against the original.
```

## What to fill in

- e.g. "Name, Ticker, Exchange" or "keep the columns as shown"
- UNCLEAR
- CHECK

Free to copy and use. From ThinkWithPrompt (https://www.thinkwithprompt.com/), a library of 2,663 curated AI prompts.