Either this
John Doe, (e-mail address removed)
Patricia Roe, (e-mail address removed)
or this
John, Doe, (e-mail address removed)
Patricia, Roe, (e-mail address removed)
will import happily, the first into two fields, the second into three.
Where things get complicated is if you have commas actually in the data,
as in these examples which most English-speaking humans can parse but
which computers find difficult:
Peter, Paul and Mary, (e-mail address removed)
Sue, Grabbit & Runne, Attorneys at Law, (e-mail address removed)
For these you need either to use tabs to separate the fields
Peter, Paul and Mary<tab>
[email protected]
or else enclose text fields in quote marks
"Peter, Paul and Mary", (e-mail address removed)