Please always reply to the list! > > Hi! > I am sorry, but still I don't get it! > I am trying with this (the code is attached) > > csv_out=csv.writer(open('out1.csv', 'wb'), delimiter=' ', > quoting=csv.QUOTE_ALL, dialect='excel') > and > csv_out=csv.writer(open('out1.csv', 'wb'), dialect='excel-tab') > > When I open out1 with text editor, I get 6 columns, but when I open it with > excel I get one column (6 numbers on each cell, how can I separate it it???) > > The files from wich I get the columns are txt files. > > Many thanks!!
Use csv_out=csv.writer(open('out1.csv', 'wb'), dialect='excel') NOT dialect 'excel-tab' or with the delimiter field. Alternatively try following these steps, http://www.ehow.com/how_4449036_import-delimited-file-excel.html Ramit Ramit Prasad | JPMorgan Chase Investment Bank | Currencies Technology 712 Main Street | Houston, TX 77002 work phone: 713 - 216 - 5423 This email is confidential and subject to important disclaimers and conditions including on offers for the purchase or sale of securities, accuracy and completeness of information, viruses, confidentiality, legal privilege, and legal entity disclaimers, available at http://www.jpmorgan.com/pages/disclosures/email. _______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: http://mail.python.org/mailman/listinfo/tutor