How to mask CSV and TSV personal information in columns and cells

Columns to check in CSV · TSV

• Name, email address, phone number, address, date of birth
• Customer ID, membership number, order number, device ID, and IP address
• Passwords, API keys, tokens, and destination URLs
• Personal information and internal information that is mixed in remarks and free descriptions

Instructions to maintain and mask the structure

1. Load the CSV or TSV and verify that the delimiter, character encoding, and header row were detected correctly.
2. Review the automatically selected columns and add any sensitive columns unnecessary for sharing to the masking targets.
3. Compare the input and result with the right and right-click the cell you need to explain.
4. Select the output de er, character code, and line break, and check whether there is a de er in the table calculation software.

Notes on CSV formula and free description

When the cell starts with =, +, -, @, it may be executed as a formula with the table calculation software. If the value received from the outside is included, use the Apostrophe function disable setting at the beginning.

Column names alone cannot determine whether notes fields contain sensitive information. Check not only the first page but also the end and exceptional rows, and search the results for the original names or domains.

Emoji and some symbols not supported by Shift_JIS will be replaced when saved. Output as UTF-8 if you do not want to lose characters.

Example: Convert CSV to survey data

For a CSV containing customer IDs, names, email addresses, phone numbers, and status, keep the status column and mask the four columns that identify individuals. Replacing repeated customer IDs and email addresses with consistent substitutes preserves history across rows.

Note columns may contain addresses and names of staff who cannot be determined by column names. Pages are sent to the results table and searches for the original company name or domain.

1. Load the customer list file and verify that the headers and delimiters are displayed correctly.
2. statose to customerId, name, email, phone, and status.
3. Compare the input and result, and confirm that the same email address was replaced with the same pseudonym.
4. Select UTF-8 and CRLF to save and check whether there is no columnarization or characterization with the table calculation software.

If you delete columns that are not necessary for the survey, you can reduce the impact of the leak when you delete them from the file that shares the column itself, not just the value masking.

Frequently asked questions

Is CSV/TSV file uploaded to the server?

No upload. Loading, analysis, masking, and file generation are done in the browser you are using.

Can I find all personal information automatically?

The general item is from the column name and value format, but it is not possible to determine the free description and original name completely. Please check the column setting and output result.