If your data has commas between each item, use an editor to 'find and replace' the commas into newlines.
If each data item is on it's own line, Excel will automatically import the text into a single column.