poorna Posted December 26, 2014 Share Posted December 26, 2014 Hi, I want to export all the details in stats in excel. If I export in csv it is not understandable. After that I have to convert csv to excel. That is not user friendly. I need the option to export directly as a excel format. Can anyone please. Link to comment Share on other sites More sharing options...
musicmaster Posted December 26, 2014 Share Posted December 26, 2014 The common problem with importing csv's exported from prestashop into excel is that Prestashop uses the semicolon as field separator while excel by default expects the comma. Problem is that Excel often doesn't ask. The common solution is to rename the .csv file into a .txt file and then to import it the same way as you would import a .csv file. That will force Excel to ask you which separator you want to use. Link to comment Share on other sites More sharing options...
Recommended Posts