Hi Harshad,
This does not seem to be exclusive to grid2. https://medium.com/mendix/import-export-data-in-mendix-using-csv-module-d3eba261ae49
Have you tried the export to csv with the excel exporter module instead? https://docs.mendix.com/appstore/modules/excel-exporter/