How to Password Protect a CSV File

Comma separated (CSV) files are usually files created to store large amounts of vital data such as customer contact information from an online newsletter software or company financial data from a money management software. It's in your best interest to protect the data within these files to make sure it doesn't get into the wrong hands.

...
Protect important data by password protecting CSV files within a ZIP file.

CSV files are simply formatted text files and have to be compressed to be secured. Standard practice suggests the compression of such files using a compression software like Winzip and password protecting the compressed file.

Manual Method

Step

Locate the CSV file on your computer. Your CSV file must be saved within a folder using a computer running the Windows operating system.

Step

Right click your CSV file from the saved location.

Step

Select “Send To” and then click on “Compressed (zipped) Folder” using a computer running Windows.

Step

Wait for the CSV file to be completely compressed.

Step

Double click the compressed CSV file.

Step

Click on "File" from your computer menu.

Step

Select "Add a Password."

Step

Enter the password you would like to use in the Password box when prompted.

Step

Reenter the password in the Confirm Password box.

Step

Click on "OK."

Using Software

Step

Download and install a CSV password protecting software like Spotmau PowerSuite (see Resources).

Step

Click on "PowerSuite Wincare 2010."

Step

Click on "Privacy Kit" from the column on the left side of the window.

Step

Select "Add Files" from the right side of the window and choose the CSV file you want to password protect.

Step

Set a password in the "Enter Password" field located at the bottom of the window. Enter the password again in the "Confirm Password" field.

Step

Choose the name you want save your CSV file as and enter the name into the "Save As" field.

Step

Click on "OK" button to save your settings.