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!