- In short
- Creates a visual selection list. Writes the selected text to the cell and places the matching image in the next cell. Config icons (images added later on click). Your source data stays unchanged; Undo Last brings it back if needed. The whole operation happens locally; nothing is sent anywhere.
What it is for
Image Validation is used to add value-mapped image-picker icons that drop the matching image next to a cell.
When to use it
It earns its place whenever you have to add visual validation to a product/color/status list.
Example scenarios
- Add visual validation to a product/color/status list.
What it needs
A single-column selection (≤500, unmerged, no formulas, unprotected) + pick value-list column + image-list column (row counts match) + confirm. Supported data types: text, number, date (by selection).
How to use it
- Select the range to work on.
- Run Image Validation from the Practical group on the XLMind Data tab.
- Confirm; config icons (images added later on click).
What it produces
Config icons (images added later on click).
Effect on your data and undo
Image Validation does not change your source data; the result is added as a separate item. If it is not what you wanted, Undo Last restores the previous state.
How it differs from similar tools
It works without formulas and never touches the source range; the result is produced separately, so the original table keeps its formulas intact.
Good to know
Merged cells rejected; protected cells refused; size limits (≤500, unmerged).
Limitations
Merged cells rejected; protected cells refused; size limits (≤500, unmerged).
Frequently asked questions
- Where is the output written?
- Config icons (images added later on click).
- What happens to invalid or unexpected values?
- Row-count mismatch refused.
- How are blank cells handled?
- Empty targets expected.
- Does the result stay linked to the source?
- The result is a snapshot of the data at run time; after bigger edits, run the tool again for a current view.
- Any known limits?
- Merged cells rejected; protected cells refused; size limits (≤500, unmerged).
Works well with
- Afterwards, try Create Barcode
- As a complement, use Export to PDF
Your Excel data is processed on your own computer and is not shared with AI services. The limited data needed for licensing, sales and support is held on our infrastructure in Türkiye.