You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

Saving a set of data in this format will removing any special Excel formatting from the data and simply place it in a list, with a comma separating each piece of data.