Dataset Pseudonymizer

Replace selected CSV identifiers with local pseudonyms and optionally export their mapping.

Files stay on your device No sign-up Free to use
How this works

The tool runs in this browser. Your file or text is not uploaded to UseFreeTools. Check this tool's limits for anything it may save on your device.

Privacy details

Inspect input controls

Showing an example. Edit to see your own.

Up to 5 MiB, 20,000 data rows, 50 columns and 200,000 data cells. Every row must have the same width.

One exact header name per line. Case and spaces matter. Every selected column gets its own mapping; equal original values in different columns receive different tokens.

Drop your CSV file here

or choose one from your device

One file · CSV and TSV only

    Anyone with this file can reverse these substitutions. Keep it apart from the shared dataset. Pseudonyms do not make data anonymous.

    Adds an apostrophe to any exported cell beginning with a formula trigger, including unselected cells. The displayed table retains the original text.

    Processed in your browser. Your inputs stay on this device.

    How to use Dataset Pseudonymizer

    1. Paste or select a UTF-8 CSV with a unique header row.
    2. Enter exact header names to replace, one per line.
    3. Keep mapping download off unless you have a separate protected place for that sensitive file.
    4. Run the substitutions and inspect both selected and unselected columns before sharing the CSV.

    Example: Dataset Pseudonymizer

    Replace repeated names and emails without changing account-number text.

    You add
    CSV: name,email,account Ada,[email protected],0012 Ben,[email protected],0034 Ada,[email protected],0012 Selected columns: name and email on separate lines; mapping: off; formula protection: on.
    You get
    Four distinct column values receive random tokens. Rows 1 and 3 reuse their name token and email token; account values remain 0012, 0034 and 0012. Exact token text changes between runs.

    Options

    CSV with a header row
    Up to 5 MiB, 20,000 data rows, 50 columns and 200,000 data cells. Every row must have the same width.
    Column names to pseudonymize
    Header names are matched exactly, including case and spaces. Each chosen column has its own mapping, so equal values in different columns are treated independently.
    Also download the sensitive original-to-token mapping
    The original-to-token file can reverse these substitutions. Enabling it creates sensitive output; store it separately from the shared dataset.
    Guard CSV spreadsheet formulas on download
    The export prefixes formula-triggering cells to reduce spreadsheet execution, including values in columns you did not pseudonymize. The displayed table retains those original strings.

    Supported inputs and limits

    CSV input is limited to 5 MiB, 20,000 data rows, 50 columns and 200,000 data cells. Pseudonyms are consistent only within each selected column and run. This is not anonymization. Optional mapping files reveal originals. Download formula guarding can add an apostrophe to unselected cells; the preview retains their text.

    Where your input is processed

    This tool processes your input in this browser. Your text and files are not uploaded to UseFreeTools. Check this tool's limits for anything it may save on your device.

    Pseudonyms are not anonymity

    A stable token makes repeated records easier to compare, but unselected dates, account numbers or unusual combinations can still identify a person. Inspect the whole table before sharing. The mapping, if requested, directly links original values to tokens and must not travel with the supposedly protected dataset.

    A new run makes a new mapping

    Tokens are generated for the current job rather than restored from a saved mapping. Running the same CSV again can change every pseudonym. If downstream work requires stable tokens across files, this tool alone does not provide that workflow. Preserve an original copy separately when you need to repeat or audit the transformation.

    Questions about Dataset Pseudonymizer

    Is the output anonymous?

    No. Other columns, patterns or an exported mapping can still identify people.

    Do repeated identifiers receive the same replacement?

    Yes, under the page’s stated mapping policy within the current run.

    Should I share the mapping with the dataset?

    Only when intended recipients need it. The mapping reconnects replacements to original identifiers.

    Project manager: Tony Hines · Content updated 3 October 2026 · Report a problem