Find secrets and convert to CSV format

README.md

Detect Secrets

Install Detect Secrets. Run following command to detect the secrets:

detect-secrets scan --all-files  --disable-plugin Base64HighEntropyString --disable-plugin HexHighEntropyString   > secrets.json

Run scripts to convert to CSV format.

python main.py

main.py

import json
import pandas as pd

rows  = []

with open('secrets.json') as json_data:
    d = json.load(json_data)
    result = d["results"]
    for key,value in result.items():
        for xs in value:
            rows.append({
                "file": xs["filename"],
                "type": xs["type"],
                "line": xs["line_number"],
                "hashed_secrets": xs["hashed_secret"],
            })

df = pd.DataFrame(rows)
df.to_csv("secrets.csv")

requirements.txt

pandas