<aside> ⚠️

If you have many connections, you may receive your data in 2 separated files. You will need to merge the two files in order to upload one single combined file.

</aside>

A .csv (Comma-Separated Values) file is used to store data in a table format. If you have two .csv files you need to combine into one, this guide will help you open and merge them using spreadsheet software or basic text editors.

Option 1: Merge CSV Files in Microsoft Excel

Step 1: Open Both CSV Files

  1. Locate the two .csv files on your computer.

  2. Open each file in Microsoft Excel.

Step 2: Combine the Data

  1. In one file, highlight all rows of data except the header row (to avoid duplicates).

  2. Copy the data (Ctrl+C or Command+C).

  3. Switch to the second file.

  4. Scroll to the first empty row below the existing data and paste (Ctrl+V or ⌘+V).

Step 3: Save the Combined File

  1. Click File > Save As.

  2. Save the new file as a .csv file:

File Format: Comma-Separated Values (.csv).