How to merge spreadsheets using Microsoft Excel



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. Select the email column in your original file, and click the "Sort and filter" button. Select the "Alphabetical ascendant" option.



Step 4. You'll get a warning about the other columns on your file, asking if you want to consider them for the upcoming sorting. Select "Expand the selection" and click "Sort".



Step 5. Repeat steps 3 and 4 for the CSV report file, just to be sure.



----------

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 (in this case, all cells containing information).

2. Click on Data at the top menu, and look for the Remove Duplicates option. Once selected, 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 "Ok" or "Remove".

----------



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



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



Step 8. 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 9. And, you're done!