Parse testssl scans results (in a JSON format) into Excel tables to facilitate the reporting process of penetration tests, especially useful when dealing with large scopes. Having scans results organised in Excel tables also allow customers and testers to use Excel powerful filtering capabilities.

The following Excel worksheets are generated:

• Host vs Certificate
• Host vs Certificates
• Host vs Protocol
• Host vs Protocols
• Host vs Vulnerability
• Host vs Vulnerabilities

$ git clone https://github.com/AresS31/testssl2xlsx
# python -m pip install -r testssl2xlsx/requirements.txt

testssl2xlsx.py [-h] -iJ INPUT_FILES [INPUT_FILES ...]
                [-oX OUTPUT_FILE] [-v]

optional arguments:
  -h, --help            show this help message and exit
  -iJ INPUT_FILES [INPUT_FILES ...], --input-json INPUT_FILES [INPUT_FILES ...]
                        input from testssl file(s) in JSON format
  -oX OUTPUT_FILE, --output-xlsx OUTPUT_FILE
                        output results to a specified <OUTPUT_FILE> in XLSX
                        format
  -v, --verbose         increase verbosity level

1. Generate the testssl input file with:

$ testssl --jsonfile-pretty testssl-results.json --quiet --nodns none --parallel --server-defaults --protocols --vulnerable --file ../nmap/SYN-*.gnmap

2. Run testssl2xlsx with the testssl JSON file generated in the previous step:

$ python testssl2xlsx.py -iJ testssl-results.json

• Adding new features, such as --protocols filtering.
• Enforce the correct file extensions (input file(s) must be .json, output file must be .xlsx)
• Reconfigure the logging module to load its settings with a configuration file
• Implement support for directory input rather than individual files.
• Source code optimisation.

• Via Bitcoin : 15aFaQaW9cxa4tRocax349JJ7RKyj7YV1p
• Via Bitcoin Cash : qqez5ed5wjpwq9znyuhd2hdg86nquqpjcgkm3t8mg3
• Via Ether : 0x70bC178EC44500C17B554E62BC31EA2B6251f64B

Copyright 2017 - 2019 Alexandre Teyar

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.