You will need 2 CSVs for this process to work, here's how you'll get that
1 - Campaign > Lead list > Download all leads (CSV A)
2 - Campaign > Lead list > Filter by email status > Replied (CSV B)
Then follow one of the following methods
Method 1: Using VLOOKUP
Open Google Sheets and create a new sheet.
Import CSV A and CSV B into separate sheets within the same Google Sheets document.
Assuming your email addresses are in column A of both CSVs, in a new column (let's say column C) of CSV A, enter the following formula in the first row of the C column:
=IF(ISNA(VLOOKUP(A2, 'CSV B'!A:A, 1, FALSE)), "Keep", "Remove")
This formula checks if the email address in cell A2 of CSV A is present in the 'CSV B' sheet. If it's not found (resulting in an error), it will mark "Keep," otherwise, it will mark "Remove."Drag the formula down for all rows in CSV A.
Now, you can filter or sort based on the "Keep" and "Remove" labels in column C to separate the rows you want to remove.
Method 2: Using QUERY
Open Google Sheets and create a new sheet.
Import CSV A and CSV B into separate sheets within the same Google Sheets document.
In a new sheet, enter the following formula in the first cell (let's say A1):
=QUERY('CSV A'!A:B, "SELECT * WHERE A NOT IN (SELECT A FROM 'CSV B'!A:A)")
This formula uses the QUERY function to select all rows from CSV A where the email address (column A) is not present in the email addresses of CSV B.This will display the filtered results in the new sheet, showing only the rows from CSV A that are not present in CSV B.
Please adjust the sheet names and column references based on your actual data. Additionally, make sure to double-check the results before making any important decisions, as data manipulation can be irreversible.