Skip to content

A Python script that anonymizes an Excel file and synthesizes new data in its place.

License

Notifications You must be signed in to change notification settings

Welding-Torch/Excel-Anonymizer

Repository files navigation

Excel Anonymizer

A Python script that anonymizes an Excel file and synthesizes new data in its place.

Downloads

Excel_Anonymized_Demo Convert your sheets with sensitive data into anonymized data.

What is Excel Anonymizer

Excel Anonymizer is a python script that helps to ensure sensitive data is properly managed and governed. It provides fast identification and anonymization for private entities in text such as credit card numbers, names, locations, phone numbers, email address, date/time, with more entities to come.

Use case

Data anonymization is crucial because it helps protect privacy and maintain confidentiality. If data is not anonymized, sensitive information such as names, addresses, contact numbers, or other identifiers linked to specific individuals could potentially be learned and misused. Hence, by obscuring or removing this personally identifiable information (PII), data can be used freely without compromising individuals’ privacy rights or breaching data protection laws and regulations.

Overview

Anonymization consists of two steps:

  1. Identification: Identify all data fields that contain personally identifiable information (PII).
  2. Replacement: Replace all PIIs with pseudo values that do not reveal any personal information about the individual but can be used for reference.

Excel Anonymizer uses Microsoft Presidio together with Faker framework for anonymization purposes.

F.A.Q.

  1. Is this encryption?
    No, Excel Anonymizer does not perform encryption. Encryption implies that the data can be decrypted. XLSX files anonymized with Excel Anonymizer cannot be changed back into the original data.

  2. What data types can it detect and anonymize?
    Excel Anonymizer can detect and anonymize Name, Phone Number, Email, Location, Date/Time, and Credit Card Numbers.

  3. How did this project originate?
    I'm glad you asked, see this.

Quickstart

  1. Install Excel Anonymizer
    pip install excel-anonymizer
    

Note: Spacy will install a Natural Language Processing package on the first run (587.7MB).

  1. Download personal_information.xlsx from this repository, and then type
    excel-anon personal_information.xlsx
    

That's it!

Usage

To use Excel Anonymizer with your Excel file, simply input the file.

excel-anon your_excel_file_here.xlsx

Author

Siddharth Bhatia
License: MIT License