Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 10 down vote accepted

To save Excel file into tab separated file (without quotes added):

  1. In Excel, press CtrlA to select all
  2. Press CtrlC to copy
  3. Open Notepad, press CtrlV to paste
  4. Press CtrlS to save and it is done
share|improve this answer

Find & Replace this: (") With a null value: () Manually.

Then,

Find & Replace 'All' of this ("") With this: (")

share|improve this answer
1  
If the Excel file is long, there will be a lot of human work. – wilson Nov 2 '10 at 6:45
3  
One option can be to replace ("") to a character which won't be there in the tab delimited file like (~) or (^), then to replace " to () and then finally (~) or (^) to ("). – jhamu Nov 2 '10 at 16:04
    
@jhamu, nice improvement to reduce human work :) – wilson Nov 3 '10 at 1:41

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .