Raw data files in JSON format

This procedure is followed if raw data comes in a file in any type of JSON format.

Install Python

1. Install Python, for example from https://www.python.org/downloads/.

Command prompt window (Windows)

1. Open the command prompt window.
2. Enter py in the commands line.

Export of raw data to preparatory file

1. Run the script ConvertJson2Csv.py.
2. Use the following name as output file name: [Name of the input file][Short title of the project]PREP[initials of the operator][date of creation using the format YYMMDD].csv
3. Save the output file in directory Raw Data of the dataset.
4. Repeat all previous steps of this paragraph for all raw data files.

See also

• Raw data preparation with Excel
• Raw data files with tab separated values
• Raw data preparation
• Product directory