Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

2 Answers 2

up vote 6 down vote accepted

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

  1. In Excel, select all (Ctrl-A)
  2. Copy (Ctrl-C)
  3. Open Notepad, paste (Ctrl-V)
  4. Save (Ctrl-S) and done
share|improve this answer
add comment

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.