To change which separator Google Sheets uses to split the names, click on the dropdown menu next to the separated names. Choose between comma, semicolon, period, space, or custom.

The comma-separated values, or CSV, file format uses plain text to represent the individual cell values and row contents of spreadsheet data.