Prompier
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
VariableWhat to enterExampleDefault
{{table_source}}Attach the image or paste the table textRegion | Q1 | Q2 / North | 1,200 | 1,350 / South | 980 | ...—
{{table_description}}What the table shows and its unitsQuarterly sales by region in thousands of dollars—
{{special_rules}}How to handle merged cells, footnotes and blanksRepeat merged region names; drop footnotes; leave blanks empty—
{{format_preferences}}Comma or semicolon, and the decimal styleComma separated, dot for decimals—

Try it

Live preview
Attach 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.