7
2
I have a tab separated value file that I want to edit in Excel. When Excel saves the file it modifies any column with quotes. It puts quotes around the whole column, and then double any quotes within the content of the column ( "
-> ""
).
I don't want quotes around my columns and I don't want my quotes within columns escaped. The program that reads this file is not expecting quotes around the columns. Is there anyway to save or export the file without these added quotes?
Bloody genius! Works! Saved my bacon. Wilson, how in the world did you learn this?? – Doug Null – 2018-01-05T18:48:58.030
Whoops. Even using this method, Excel still erroneously inserts " at the beginning of cell in column-A if row follows a group. – Doug Null – 2018-01-05T19:22:24.703
@DougNull what does it mean by "row follows a group"? – wilson – 2018-01-08T04:13:10.370
If you manually do like this, you might end up with a bad encoding and when you read the same file in python you might get error like 'utf-8 codec can't decode byte.....' – Rajarshee Mitra – 2019-07-26T10:40:25.700