We found that exporting the Range Descriptions does not work in Export to Excel (Data Only) and (CSV)
Only numbers get exported, and the regular Export to Excel works fine.
Release: CODFSS99000-15.5-PPM SAAS FedRAMP-Sandbox-Small Environment
This is working by design
* Export to Excel (regular) is meant to provide a quick way to capture limited results that are seen on the screen in Classic out to Excel with Range Descriptions based on the Classic 'view' configuration.
* However, the Export to Excel (Data Only) and CSV are just meant to provide data and more rows for data use; we are not exporting the Classic 'view' configuration of showing a range description.
The reason it could actually work in some views is that there it's actually a Lookup value and not a Range Description.
For more info:
DE48112 Export to Excel (Data Only) on master object does not use the Range Description for the Aggregated Number Lookups and exports numbers only NAB