CSV export was one of those missing features, but now its finally available.
Its commonly used as an intermediary format to move data between applications.
The wait is over!
Microsoft
You just get the raw data, and for cells with formulas, only the final data is included.
Source:Microsoft 365 Insider Blog
