Has anyone here ever used python to produce data files which can be immediately read by excel? I thought at first if I just tab-delimited my data, I could copy and paste an entire data file into excel. This is not the case. When I take a tab delimited data set:
'hi' 'there' 'guys'
And copy/paste into excel, all of the data gets read into just one cell, instead of being split into three adjoining cells. I have no idea how to split my data correctly for excel. I am working with multiple rows and columns, and would like to be able to avoid the excessive copy and pasting column by column. Any advice?