How do I merge individual APX export files together?

Below is an explanation on how to merge CSV files out of an APX export together using the common buildingId field, inserting the name and address from one file to another file. This example uses the buildings.csv file and the Contact.csv file, pulling data from two columns in buildings.csv and placing it in the Contacts.csv file in two new columns. The following assumes buildingId is in column A of Sheet1 (buildings.csv), Building Name is in column B, and Address is in column c. 

1. In Sheet2, Populate Building Name (Column B)

Go to Sheet2, in B2 (assuming Building ID is in A2), enter:

• A2 → The Building ID in Sheet2.
• Sheet1!A:C → The lookup range in Sheet1 (where Building ID, Building Name, and Address exist).
• 2 → Retrieves column B (Building Name) from Sheet1.
• FALSE → Ensures an exact match.

2. In Sheet2, Populate Address (Column C)

Go to C2 in Sheet2, enter:

• 3 pulls from column C (Address).

3. Drag the Formulas Down

• Click on the bottom-right corner of the formula cell.
• Drag down to apply it to all rows.