Hi! I'm trying to report my data summary to excel but when I open the file it seems like this:
What can I do?
Thanks!
Excel has opened a CSV file, which is a text file of comma separated values. Sometimes Excel can recognize the data boundaries and format the data into columns automatically. Other times, depending on your Excel settings and/or the format of the data, you need to help Excel break the data into columns.
If you go to the main ribbon, and go to the Data tab, you should find a button labeled "Text to Columns":
Clicking this button will open a wizard to help Excel parse your data appropriately.
Most commonly the cause of this is having your computer set to a different locale, in which the comma is used as the decimal separator. In that case Excel expects CSV files to use the locale and is looking for semicolons (;) as field separators (which makes me wonder if the people at Microsoft stopped to think what CSV stands for in the first place... wasn't the whole point to have a machine-independent format)? FlexSim on the other hand does use commas as it should. I ran into this issue with our Dutch computers as well and ended up just setting Window's number format settings to English so I don't have to think about this every time I open a text file in Excel.
8 People are following this question.
