Tools › CSV → MERGE
Excel / CSV to SQL Server MERGE (upsert)
INSERT breaks when the email is already there. MERGE is update-or-insert. First row is headers. One key column.
MERGE has held a few locking surprises over the years. For a huge load, a staging table + UPDATE/INSERT pair is kinder. Related: CSV INSERT.
Learn it on a real ticket
Monday is free on WorkSQL. Write the T-SQL yourself. We mark it like a colleague would.
Clock in free