When you transform a Microsoft Excel spreadsheet into comma-delimited text, the output process substitutes punctuation for the divisions among the rows and columns within a worksheet.

Is there anyway I can make it so if I copy and paste those comma separated list into it excel it automatically puts each thing into different fields.

A CSV (comma-separated values) file is a text file in which information is separated by commas. CSV files are most commonly encountered in spreadsheets and databases. You can use a CSV file to ...