What is the problem or goal the end user is trying to solve or accomplish?
Currently, both Excel and Pivoted CSV export of a Pivot table produces different formats.
What is the recommended solution by the Customer?
Standardise the export format so that both file types can be interchangeable.
In the Interactive Pivot Table chart type, right clicking to export will preserve the format of the table.