Data Export Widget Output

Hello Aditya,

In fact it's the specific issue of Excel not always opening CSV files correctly. See this post on Stack Overflow, it discusses it in great detail. Also consult with "official" Office documentation here.

To summarize, there are four things you can do to make it work:

1. Rename the file to abc.txt and open it via File > Open. Excel will ask you for delimiter, and you select comma (as described in the Office documentation);
2. Configure your Windows' regional settings to use , as a system-wide lists delimiter (as described in that Stack Overflow post);
3. In Excel use Data > From Text/CSV (as described in the Office documentation), this will also allow you to select delimiter;
4. Excel-specific hack -- add this to the beginning of your CSV file and just open it:
   

   SEP=,​

It's up to you to choose the one which works best for you and your users.

Long story short -- ThingWorx generates correct CSV files, but Excel treats them in its own unique way.

/ Constantine