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

2 Answers 2

up vote 7 down vote accepted

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

  1. In Excel, press Ctrl+A to select all
  2. Press Ctrl+C to copy
  3. Open Notepad, press Ctrl+V to paste
  4. Press Ctrl+S to save and you are 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

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.