Difference between revisions of "Importing BESA Statistics Results into Excel"
From BESA® Wiki
(Created page with "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...") |
|||
| Line 1: | Line 1: | ||
| − | 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). | + | 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. |
Revision as of 13:57, 12 May 2016
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.
