Difference in Data Format while Downloading the xlsx & CSV File

Get Help
1

I have created a native query (sql query) in Metabase (v0.44.2). While downloading the data in xlsx & CSV we are getting the same data but one is formatted and another is unformatted.

In xlsx (excel) download we are getting formatted data with numbers as Millions (M) whereas in csv we are getting actual number without any format. So kindly suggest me how i can fix the csv file or xlsx file to get the same data. For reference screenshot has been attached for the same.
Download in csv
Download in excel
UI data which is formatted as Millions

2

Hi @Pintu_Kumar
Metabase cannot create formatting on CSV, since the format doesn't allow that, so they will always be different.
https://github.com/metabase/metabase/issues/17422 - upvote by clicking :+1: on the first post

3

Thanks @flamber , any estimation when it will get also fixed in CSV. Since it is not considering defined formatting as per UI.

4

@Pintu_Kumar I cannot give you timeline on any issues.

5

Ok, Thanks, anyway @flamber.