0

Hey guys,

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?

1
Contributor
1
Reply
2
Views
7 Years
Discussion Span
Last Post by hughesadam_87
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.