Member Avatar for hughesadam_87

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
  • 112 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by hughesadam_87
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.