BEEPS CSV help

In addition to the Stata format, the data from the BEEPS surveys are also available in ASCII comma delimited format. This is a common way to save large datasets and allows the data to be imported to all mainstream statistical packages as well as to Microsoft Excel easily. In order to import the data, please follow the instructions below, and consult your software’s manual/help files where necessary. 

Importing ASCII data files to Excel

1. Download the files by right clicking on them. Do not open them directly.

2. Launch MS Excel.

3. Go to Data/Import External Data/Import Data and select the file from which you would like to import the data and click open. The programme will launch “Text Import Wizard”

a) Step 1: The wizard should automatically recognise the file as delimited. If not, then choose this option manually.

b) Step 2: The data is in comma delimited form. Please tick this box.

c) Follow the remaining steps and specify the location where you would like to import the data.

4. The text import wizard will then import as much data as will fit a single Excel worksheet.

5. To continue importing the data, repeat the same operation on another Excel worksheet, this time excluding the data already imported.

IImporting ASCII data files to other statistical packages

Please consult the manual of your package on how to import external data.