How to merge spreadsheets using Google Sheets



Step 1. Go to your session details section and export your report by clicking on "Export all emails".



Step 2. Compare your files. It's very likely they are not in the same order. We will force both files to be sorted by the email address columns so that the data aligns in both files.



Step 3. Go to the Email column in your Google Sheets file, click on the drop menu and select "Sort sheet A to Z". Do the same with your report file so we can make sure they're both sorted.



----------

OPTIONAL STEPS: Just in case you have duplicates in your original file. 

1. Select the range of cells that has duplicate values you want to remove (for this case, all cells containing information).

2. Click on Data at the top menu. Once there, click on Data clean-up and select "Remove duplicates".

3. Check or uncheck the columns where you want to remove the duplicates (for this case, you usually need to keep only the email column and uncheck the rest), and click on "Remove Duplicates".

----------

Step 4. Compare your files again. The alphabetical order should be the same in both files now.



Step 5. Go to the CSV report file, select the information you need, and copy it.



Step 5. Now, go to your original file and select the first empty cell beside the existing information. Paste the information that you copied from the report file.



Step 6. And, you're done!