Encrypting CSV files

To switch to CSV mode, select the CSV Files option at the top left of the Data Privacy dialog.

The Encryption tab for CSV files lets you do the following:

Select files and fields

1. Click the Browse button to navigate to a CSV file.
2. Change the header row if necessary.
3. From the Field drop-down list, select the field or fields you want to apply a privacy method to.
4. For each field, select the correct field type (character, number, etc.) from the Field type drop-down list.

You can repeat this for multiple files.

Apply data privacy methods

From the Data privacy method drop-down list, you can apply one of the following data privacy methods to each field:

• Pseudonymize (default): Encrypts the field using a password. This method is reversible.
• Anonymize: Replaces content with random characters while keeping the same type and size. Irreversible.
• Zeroize: Sets all digits to 0 or characters to empty. Irreversible.
• Eliminate: Removes the field entirely from the output. Irreversible.
  
  

Specify an output file name and location

Unless you've selected the Replace the existing CSV file option at the bottom of the dialog, you can accept or overwrite the suggested output path and file name in the Output CSV file name field or use the Browse button to navigate to the folder where you want to save the file. Each output file must have a unique name. The app auto-generates names with a DPE (Data Privacy Encrypted) suffix.

Set a password (required for pseudonymization only)

When you choose pseudonymization as a privacy method, you must provide a password. This password is used to encrypt the data in a reversible way, allowing only those who know the password to decrypt and access the original content. Without the correct password, it is impossible to recover the encrypted data.

To ensure compatibility with the encryption algorithm, your password must have at least 13 characters, contain letters, numbers and symbols, and only use characters from the supported list.

Features:

• Generate random password: Click this button to automatically generate a random password.
• Copy the password : Select this icon to copy the password to your clipboard.
• Send the password via email : Select this icon to open your email client with the password prefilled.

Output options

• Save as new CSV file (default): Creates new files with the modified data.
• Replace the existing CSV file: Overwrites the original files.
• Speed boost: Is enabled by default for CSV files, offering much faster processing.
• Ultra security: Makes processing extra secure.

Start the process

Once everything is set, click Process. The app will begin encryption and show a progress dialog.

You can cancel the process at any time:

• If you select to save progress, the partially processed file will be kept.
• If you discard, the original state will be restored.