Merge multiple CSV files in one single CSV file

Merge multiple CSV files in one single CSV file

This procedure assesses all column names that are being used in a list of selected CSV files and merges the content of all files in the correct column of a single output file.

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 MergeCsv.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