The string field is showing as integer when opening a report exported as csv file

Question & Answer
1

I am having a field with values like ‘000’,‘001’ and so on. I have exported the report as csv file. When I double click to open the file the above field is showing as integer with values like ‘0’,‘1’ and so on. How to retain the values intact?
Note: When i open the csv file in notepad++, it is showing the values correctly

2

Hi @Vishy - Welcome to AWS QuickSight community and thanks for posting the question. This is not a problem with QuickSight and it is a standard behavior of csv file. You can format that column to string.

Regards - Sanjeeb

1 Like