A PNG lookup table cannot join your dataset until its fields are text
Convert a table saved as a PNG into plain records for a spreadsheet import or script. Keep the original image for comparison and pay particular attention to empty fields, which must stay aligned with the correct column.
Reference data distributed as image attachments
Recover a PNG lookup table as CSV, then validate codes and missing values before using it in a data join.
Image exports from report designers
Prepare visible report values for a text-based import when you cannot obtain the original dataset from the report owner.
Keep blank fields aligned when preparing PNG data
- Upload the full-resolution PNG and keep the table's header row in view.
- Inspect empty cells and confirm that nearby values have not shifted left or right.
- Download CSV and explicitly configure text columns for codes in the destination import.
Empty PNG cells, small text and identifiers changed on import
- Can PNG to CSV read a table with empty cells?
- It can attempt to preserve the visible structure, but blank fields need review. Compare adjacent values and column counts before downloading.
- Does resizing a small PNG improve CSV recognition?
- Enlarging the same pixels cannot restore missing detail. Obtain a larger original or make a new capture with readable text where possible.
- Will the CSV contain the PNG's colors or cell borders?
- No. CSV represents field values. Choose Excel if you need a worksheet for subsequent formatting, and retain the image as a visual reference.
- Why does a code change after I open the CSV?
- Spreadsheet applications may infer a number or date from a text field. Import identifier columns as text and compare them with the PNG.
- Is the CSV from a PNG comma-separated or semicolon-separated?
- It is comma-separated. Fields that contain a comma, a quote or a line break are wrapped in double quotes, and rows end with CRLF. If your spreadsheet expects semicolons, pick comma in its import dialog instead of editing the file.
- Why do accented letters look wrong when I open the CSV in Excel?
- The file is UTF-8 without a byte-order mark, and double-clicking it can make Excel read it in another encoding. Import it with Data, From Text/CSV, and choose UTF-8 as the file origin. Most import tools let you set the encoding explicitly.
- Does the CSV include a header row?
- It includes whatever rows are in the grid, and the first one is treated as the header. If the PNG has column headings, they come first. If it does not, name the columns in the importing tool rather than typing over a data row.
- Can I merge several PNG tables into one CSV file?
- Each PNG is converted on its own, and Batch mode, a Premium option, returns a ZIP with one CSV per image. To make one file, open the CSV files and paste the rows under a single header after checking that the columns match.




























