"test@domain.com","John","Doe","New Orleans","LA","70129","555-555-5555","USA","1024 Meterie Rd.",""
in the CSV, you should not include the column name.
Remove that from the main CSV file and copy the column names list to another file.
use that other file for copying the column names list into the PHPMyAdmin interface when doing the import.
Okay! We're getting somewhere. John Doe is our first subscriber.
I like this message better: Import has been successfully finished, 2 queries executed.
The issue must be that I have test@domain.com rather than "test@domain.com"? If so, where to the quotes come from?