954,541 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Formatting Excel Data

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?

shoemoodoshaloo
Junior Poster
168 posts since May 2009
Reputation Points: 16
Solved Threads: 6
 

Sorry, I didn't realize that excel could read in data of several formats.

BTW if anyone is interested, here is a cool link;

http://www.developer.com/lang/other/article.php/3727616

shoemoodoshaloo
Junior Poster
168 posts since May 2009
Reputation Points: 16
Solved Threads: 6
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You