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!