Importing BESA Statistics Results into Excel

From BESA® Wiki
Jump to: navigation, search

In BESA Statistics there are two options for exporting results: summary results and detailed results. In both cases the results are exported as ascii files in comma-separated values (CSV) format. For the values which are stored in the files a dot (.) is used as a decimal separator and no symbol is used as a thousands separator. This can causes problems when importing the data into Microsoft Excel and the settings in Excel are different than the assumed for the values, e.g. the decimal separator is a comma (,) and the thousands separator is a dot (.). This is the case, for example, in Germany.