ApprovedData and analyticscsv
Turn a table in an image into CSV
PL by Prompier Library
☆☆☆☆☆ New
Version 1 · updated Nov 10, 2026
Reviewed by moderator Prompier Library on Nov 10, 2026. Checked for personal data, secrets, risky instructions and a clear license.
About this prompt
Extracts a table from a screenshot or scanned page into clean CSV text and lists any cells it could not read with confidence. Use when you need data from a picture or PDF page in a spreadsheet.
Prompt text
You are a careful data-entry specialist. Convert the table in the image or pasted text into CSV I can save and open in a spreadsheet.
Inputs:
- The table (attached image or pasted text): {{table_source}}
- What the table contains and its units: {{table_description}}
- How to handle merged cells, footnotes and blanks: {{special_rules}}
- Delimiter and decimal style wanted (comma or semicolon): {{format_preferences}}
Steps:
1. Describe the table structure in one line: number of columns, header rows and notes. Ask up to 3 questions only if you cannot see the table at all.
2. Transcribe each cell exactly as shown. Keep numbers, symbols and signs unchanged; do not round, fix or reformat values.
3. Flatten multi-line headers into single header names (for example "Group A - Mean"). Repeat values from merged cells down their rows if I asked, otherwise leave them blank and say so.
4. Put footnote markers in a separate column or a note, as I specified.
5. Quote any text cell that contains the delimiter.
6. Check the output: every row has the same number of fields, totals still match if the table shows sums, and numbers look plausible for their column.
Output format:
- A single CSV code block.
- A list called Uncertain cells (row, column, what you read, alternative).
- A list called Assumptions made.
Quality bar: never guess an unreadable value; mark it as UNREADABLE in the CSV and list it. Do not add rows or columns that are not in the source. Keep the original order.
Variables
4 variables| Variable | What to enter | Example | Default |
|---|---|---|---|
| {{table_source}} | Attach the image or paste the table text | Region | Q1 | Q2 / North | 1,200 | 1,350 / South | 980 | ... | — |
| {{table_description}} | What the table shows and its units | Quarterly sales by region in thousands of dollars | — |
| {{special_rules}} | How to handle merged cells, footnotes and blanks | Repeat merged region names; drop footnotes; leave blanks empty | — |
| {{format_preferences}} | Comma or semicolon, and the decimal style | Comma separated, dot for decimals | — |
Try it
Live previewAttach the image or paste the table text
What the table shows and its units
How to handle merged cells, footnotes and blanks
Comma or semicolon, and the decimal style
Your finished prompt
You are a careful data-entry specialist. Convert the table in the image or pasted text into CSV I can save and open in a spreadsheet.
Inputs:
- The table (attached image or pasted text): {{table_source}}
- What the table contains and its units: {{table_description}}
- How to handle merged cells, footnotes and blanks: {{special_rules}}
- Delimiter and decimal style wanted (comma or semicolon): {{format_preferences}}
Steps:
1. Describe the table structure in one line: number of columns, header rows and notes. Ask up to 3 questions only if you cannot see the table at all.
2. Transcribe each cell exactly as shown. Keep numbers, symbols and signs unchanged; do not round, fix or reformat values.
3. Flatten multi-line headers into single header names (for example "Group A - Mean"). Repeat values from merged cells down their rows if I asked, otherwise leave them blank and say so.
4. Put footnote markers in a separate column or a note, as I specified.
5. Quote any text cell that contains the delimiter.
6. Check the output: every row has the same number of fields, totals still match if the table shows sums, and numbers look plausible for their column.
Output format:
- A single CSV code block.
- A list called Uncertain cells (row, column, what you read, alternative).
- A list called Assumptions made.
Quality bar: never guess an unreadable value; mark it as UNREADABLE in the CSV and list it. Do not add rows or columns that are not in the source. Keep the original order.
Sample output
Structure: 5 columns, 1 header row, 3 data rows, 1 footnote.
```csv
Parameter,Value,Unit,Standard error,Note
Learning rate,0.001,none,0.0002,a
Batch size,64,samples,,
Dropout,0.3,none,UNREADABLE,
```
Uncertain cells
- Row 3, Standard error: smudged; could be 0.02 or 0.03.
Assumptions made
- Footnote marker "a" kept in the Note column.
- Blank cells left empty, not filled with zero.
- Header "Standard error" came from a two-line heading in the image.
- Numbers copied exactly, including the trailing zero in 0.0002.
An example the author shared. Your result will differ.
Reviews
No written reviews yet. If you have used this prompt, tell others how it went.
0 forks
Public forks of “Turn a table in an image into CSV” by Prompier Library (v1).
Lineage: Original prompt → this prompt → 0 forks
No forks have been shared publicly yet.