SonarQube community edition has no direct way to export issues to excel file. Here are the steps to export;
- Install Python from here
https://www.python.org/downloads
Go through custom installation. Specify a manual path e.g. c:\Python313. Check all checkboxes.
Verify installation using “Python –version” in python console.
Clone following repository from GitHub;
https://github.com/talha2k/sonarqube-issues-export-to-excel
open “sonarqube-issues-export-to-excel” in python IDE (IDLE) and edit SonarQube URL, Project_Key and Token. Save file.
Run the script
python sonar-export.py
The script will fetch the issues and save them to an Excel file named sonarqube_issues.xlsx.
Hope this will help someone.