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.

How to Make a List of Excel Data Into Data Separated by Comma. Microsoft Excel 2010 stores data within cells, which are simply segregated pieces of the spreadsheet that Excel can then reference to ...

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.