CSV Value Mapper
Replace exact CSV cell values using a two-column lookup, retain unmatched values and download an audit of counts locally.
This tool processes its input contents in your browser instead of sending them to a processing service. Page, asset and fixed usage-measurement requests are described on the Privacy page.
Replace selected whole CSV cell values through a unique two-column dictionary, preserving unmatched cells and reporting their frequencies.
How to use it
- 1Read the source CSV and select which columns to map.
- 2Supply a two-column mapping with one row per original value.
- 3Review match counts, then download the mapped table and unmatched-values list.
Example
- Input
- Source: id,status 001,A 002,C Mapping: original,replacement A,Active
- Output
- id,status 001,Active 002,C
Select status. A matches exactly and becomes Active; C is unchanged and appears in the unmatched-values download.
What happens to your data
Both tables and lookup results remain in this browser tab. The unmatched-values download contains original source text; review it before sharing.
Last updated November 2026
Translate codes or standardize reviewed aliases with a CSV lookup table. Paste the source and a two-column mapping, then select which source columns to update. CSV Value Mapper replaces exact whole-cell matches, preserves every unmatched value and gives you a separate unmatched-values file to review.
How it works
The mapping CSV needs a header and exactly two columns. Its first column holds original values; its second holds replacements. Header names can be any distinct nonempty text. Every original mapping value must appear once, including an empty original value. A repeated key stops processing, even when both replacements agree, so dictionary ambiguity is visible. At least one mapping data row is required. Both inputs use the delimiter you select.
Matching uses the complete original cell text, with case and whitespace significant. A does not match a or a value padded with spaces. Each selected source cell is looked up exactly once against the original dictionary. With A→B and B→C, an original A becomes B; it is not replaced again with C. Unselected columns, headings and source-row order stay unchanged. Blank keys and blank replacements are supported, but they remain deliberate exact mappings rather than guessed missing values.
The result distinguishes matched cells from changed cells. A mapping A→A counts as a match without counting as a change. Unmatched cells remain in the main CSV. The separate unmatched-values CSV contains each distinct unmatched text once, in first-appearance order, with its occurrence count across selected columns. It contains real source values, so review it before sharing. Unused mapping-key counts help identify a dictionary that does not cover the export you expected. A dictionary with too many distinct unmatched values to fit the 10,000-record report limit stops processing with a clear limit error.
This is exact replacement, not fuzzy matching or automatic reconciliation. Use CSV Cell Cleaner first if you deliberately want to normalize spaces or case, or CSV Join when you need to attach several lookup columns rather than replace values.
Use UTF-8 input up to 500 KiB, 10,000 records including the header, 128 columns and 200,000 cells. The output is limited to 2 MiB, 10,000 records including its header and 200,000 cells. Comma, semicolon and tab delimiters are supported; choose the correct delimiter explicitly. Each header must be nonempty and unique. Invalid quotes or unequal record widths stop processing instead of silently repairing the table.
CSV output uses UTF-8 without a byte order mark and CRLF record endings. Quoting may be rewritten while logical cell text is preserved. Formula-like text is not prefixed or removed automatically; spreadsheet applications can interpret such text as formulas, so review the file and import columns as text where appropriate. The downloadable JSON report records operations and counts rather than original cell values. Processing happens in this browser tab.
Worked example: Translate a known code and retain an unknown one
- Input
- Source: id,status 001,A 002,C Mapping: original,replacement A,Active
- Result
- id,status 001,Active 002,C
Select status. A matches exactly and becomes Active; C is unchanged and appears in the unmatched-values download.
Common use cases
- Translate exported status codes into reviewed labels.
- Replace approved product aliases without guessing spelling similarity.
- Convert a controlled set of category values while retaining unknown ones.
- Export unmatched values and frequencies to improve a lookup dictionary.
Frequently asked questions
Does CSV lookup matching ignore case or spaces?+
Matching is exact and case-sensitive. Whole cells are compared, including boundary spaces. Clean selected columns first if normalization is intentional.
Are replacements applied repeatedly?+
Each original cell is mapped once. With A→B and B→C, an original A becomes B. This avoids replacement order changing your result.
What happens to an unmapped code?+
It remains unchanged in the main CSV and appears in the separate unmatched-values CSV with its occurrence count. Nothing is silently dropped.
Can a mapping key appear twice?+
No. Duplicate original values stop processing even when their replacements are identical. Keep one mapping row per exact original value.
How is this different from CSV Join?+
A join attaches columns by relationships between tables and can create extra rows when keys repeat. This mapper preserves source row count and replaces only the selected whole-cell values using a unique dictionary.
Related tools
JSON Array Splitter
Split a JSON array into fixed-size batches, preserving value spelling and source order. Download all JSON files and a manifest in one ZIP.
CSV to XML
Convert CSV to XML with original headers, leading zeros and empty strings preserved.
XML to CSV
Convert a selected XML record path to CSV, keeping attributes, namespaces and repeated fields.
Merge Excel Files
Merge 2–10 XLSX files as separate tabs or header-aligned rows with source lineage, all in your browser.