Importing BESA Statistics Results into Excel - Revision history

Robert at 09:07, 5 May 2021

2021-05-05T09:07:23Z

Robert at 11:06, 2 February 2021

2021-02-02T11:06:49Z

Jaehyun at 08:18, 16 June 2017

2017-06-16T08:18:54Z

Todor at 13:45, 12 May 2016

2016-05-12T13:45:37Z

Todor at 13:43, 12 May 2016

2016-05-12T13:43:24Z

Todor at 13:39, 12 May 2016

2016-05-12T13:39:49Z

Todor at 13:36, 12 May 2016

2016-05-12T13:36:47Z

Todor at 13:27, 12 May 2016

2016-05-12T13:27:44Z

Todor: Todor moved page Importing BESA Statistics Results into Excell to Importing BESA Statistics Results into Excel without leaving a redirect

2016-05-12T12:58:42Z

Todor moved page Importing BESA Statistics Results into Excell to Importing BESA Statistics Results into Excel without leaving a redirect

Todor at 12:57, 12 May 2016

2016-05-12T12:57:36Z

@@ Line 2: / Line 2: @@
 |title = Module information
 |module = BESA Statistics
-|version = 1.0 or higher
+|version = BESA Statistics 1.0 or higher
 }}

← Older revision		Revision as of 11:06, 2 February 2021
Line 37:		Line 37:
	6. Click <tt>OK</tt> and then on <tt>Finish</tt> to complete the <tt>Text Import Wizard</tt>. The data should be imported correctly now.		6. Click <tt>OK</tt> and then on <tt>Finish</tt> to complete the <tt>Text Import Wizard</tt>. The data should be imported correctly now.

−	[[Category:Statistics]]	+	[[Category:Statistics]] [[Category:Data Import/Export]]

@@ Line 5: / Line 5: @@
 }}
-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.
+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.
 In order to make sure that the results are imported correctly into Excel one has to follow the next procedure.
-[[File:MicrosoftExcelDataTab.png|none|Figure 1 Microsoft Excel Data tab]]
+. Open Excel and select the <tt>Data</tt> tab
-=== Click on the icon <tt>From Text</tt> and select the corresponding CSV-file.===
+[[File:MicrosoftExcelDataTab.png|none|Figure 1 Microsoft Excel Data tab|500px]]
-=== The <tt>Text Import Wizard</tt> dialog opens. In the first step choose the option <tt>Delimited</tt> and click <tt>Next</tt>.===
+. Click on the icon <tt>From Text</tt> and select the corresponding CSV-file.
-[[File:TextImportWizardStep1.png|none|Figure 3 Microsoft Excel Text Import Wizard Step 1]]
+[[File:MicrosoftExcelFromText.png|none|Figure 2 Microsoft Excel Data tab, From Text button|500px]]
-[[File:TextImportWizardStep2.png|none|Figure 4 Microsoft Excel Text Import Wizard Step 2]]
+. The <tt>Text Import Wizard</tt> dialog opens. In the first step choose the option <tt>Delimited</tt> and click <tt>Next</tt>.
-=== In the third step click on <tt>Advanced...</tt> and in the <tt>Advanced Text Import Settings</tt> dialog select a dot (.) as a decimal separator and empty character as a thousands separator.===
+[[File:TextImportWizardStep1.png|none|Figure 3 Microsoft Excel Text Import Wizard Step 1|600px]]
-=== Click <tt>OK</tt> and then on <tt>Finish</tt> to complete the <tt>Text Import Wizard</tt>. The data should be imported correctly now.===
+. In the second step choose as a delimiter <tt>Semicolon</tt> and click next.
 [[Category:Statistics]]

@@ Line 17: / Line 17: @@
 [[File:MicrosoftExcelFromText.png|none|Figure 2 Microsoft Excel Data tab, From Text button]]
-=== The <tt>Text Import Wizard</tt> opens. In the first step choose the option <tt>Delimited</tt> and click <tt>Next</tt>.===
+=== The <tt>Text Import Wizard</tt> dialog opens. In the first step choose the option <tt>Delimited</tt> and click <tt>Next</tt>.===
 [[File:TextImportWizardStep1.png|none|Figure 3 Microsoft Excel Text Import Wizard Step 1]]

@@ Line 9: / Line 9: @@
 In order to make sure that the results are imported correctly into Excel one has to follow the next procedure.
-===1) Open Excel and select the <tt>Data</tt> tab===
+=== Open Excel and select the <tt>Data</tt> tab===
 [[File:MicrosoftExcelDataTab.png|none|Figure 1 Microsoft Excel Data tab]]
-===2) Click on the icon <tt>From Text</tt> and select the corresponding CSV-file.===
+=== Click on the icon <tt>From Text</tt> and select the corresponding CSV-file.===
 [[File:MicrosoftExcelFromText.png|none|Figure 2 Microsoft Excel Data tab, From Text button]]
-===3) The <tt>Text Import Wizard</tt> opens. In the first step choose the option <tt>Delimited</tt> and click <tt>Next</tt>.===
+=== The <tt>Text Import Wizard</tt> opens. In the first step choose the option <tt>Delimited</tt> and click <tt>Next</tt>.===
 [[File:TextImportWizardStep1.png|none|Figure 3 Microsoft Excel Text Import Wizard Step 1]]
-===4) In the second step choose as a delimiter <tt>Semicolon</tt> and click next.===
+=== In the second step choose as a delimiter <tt>Semicolon</tt> and click next.===
 [[File:TextImportWizardStep2.png|none|Figure 4 Microsoft Excel Text Import Wizard Step 2]]
-===5) In the third step click on <tt>Advanced...</tt> and in the <tt>Advanced Text Import Settings</tt> dialog select a dot (.) as a decimal separator and empty character as a thousands separator.===
+=== In the third step click on <tt>Advanced...</tt> and in the <tt>Advanced Text Import Settings</tt> dialog select a dot (.) as a decimal separator and empty character as a thousands separator.===
 [[File:TextImportWizardStep3.png|none|Figure 5 Microsoft Excel Text Import Wizard Step 3]]
-===6) Click <tt>OK</tt> and then on <tt>Finish</tt> to complete the <tt>Text Import Wizard</tt>. The data should be imported correctly now.===
+=== Click <tt>OK</tt> and then on <tt>Finish</tt> to complete the <tt>Text Import Wizard</tt>. The data should be imported correctly now.===
 [[Category:Statistics]]

← Older revision		Revision as of 13:27, 12 May 2016
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) 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.		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.
		+
		+	In order to make sure that the results are imported correctly into Excel one has to follow the next procedure.
		+
		+	1) Open Excel and select the <tt>Data</tt> tab
		+
		+
		+	2) Click on the icon <tt>From Text</tt> and select the corresponding CSV-file.
		+
		+
		+	3) The <tt>Text Import Wizard</tt> opens. In the first step choose the option <tt>Delimited</tt> and click <tt>Next</tt>.
		+
		+
		+	4) In the second step choose as a delimiter <tt>Semicolon</tt> and click next.
		+
		+
		+	5) In the third step click on <tt>Advanced...</tt> and in the <tt>Advanced Text Import Settings</tt> dialog select a dot (.) as a decimal separator and empty character as a thousands separator.
		+
		+
		+	6) Click <tt>OK</tt> and then on <tt>Finish</tt> to complete the <tt>Text Import Wizard</tt>. The data should be imported correctly now.

← Older revision	Revision as of 12:58, 12 May 2016
(No difference)

← Older revision		Revision as of 12:57, 12 May 2016
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.