In running either Classic reports like the Goal Search or spreadsheet reports like Goal Summary, the report is reflecting the goal category id's instead of the category names. So if the name is changed mid-year but the id remains the same, the category id gets displayed and this causes confusion in the reports. Reports should be updated to display the category name instead of the category id.
The category name field is inside the BLOB object in database.
So it is not possible to show that in spreadsheets now and this is not a defect.
In order to display the category name this field should be migrated to a relational field ( column in database) then only it is possible.
And this feature is considered as enhancement request as per our system design.
Goals Category Adhoc Report Spreadsheet report , KBA , LOD-SF-GM-REP , Reporting and Data Imports Exports , Product Enhancement