- In short
- Creates a masked copy of the columns you choose on a new sheet, so you can share the file without showing sensitive values. Your original sheet is not changed. Identity numbers, tax numbers, card like numbers, names, emails, phone numbers and account numbers can be hidden while the text still looks realistic and leading zeros are kept. This runs inside Excel and your workbook is not sent anywhere. There is no undo because a new sheet is created, so delete that sheet if you do not want it. A new 'XLMind Masked' sheet with masked data. The source table is left as it is.
What it is for
Mask Data is used to write a masked copy of the selected table to a new sheet (privacy).
When to use it
It earns its place whenever you have to redact personal data (ID, IBAN, phone) before sharing.
Example scenarios
- Redact personal data (ID, IBAN, phone) before sharing.
What it needs
A table selection (whole col → used band; single cell/whole-row refused) and an options dialog; ≥1 masked column required. Supported data types: text, number, date (by selection).
How to use it
- Select the range to process.
- Run Mask Data from the Codes & Output group on the XLMind Data tab.
- Pick the settings you need in the window that opens.
- Confirm; a new 'XLMind Masked' sheet with masked data.
What it produces
A new 'XLMind Masked' sheet with masked data.
Effect on your data and undo
Mask Data does not change your source data; the result is added as a separate item.
How it differs from similar tools
Compared with a hand-built formula setup there is nothing to maintain; the source table keeps its formulas and formats untouched.
Good to know
Single cell only; whole row refused; size limits (≥1 masked column required.).
Limitations
Single cell only; whole row refused; size limits (≥1 masked column required.).
Frequently asked questions
- Where does the result go?
- A new 'XLMind Masked' sheet with masked data. Nothing is written on the sheet holding your source table.
- Are formulas affected?
- Values never parsed; formulas → resolved value; error cells → readable text.
- How are blank cells handled?
- Blanks stay blank.
- Does the result stay linked to the source?
- No, the output is static; rerun the tool after changing the source data for a current view.
- Any known limits?
- Single cell only; whole row refused; size limits (≥1 masked column required.).
Works well with
- Afterwards, try Number to Words
- A good companion is 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.