I have a CSV with data like this:


I know that it is possible to specify "Text" when using the Import Wizard and defining columns. But is there a way to tell Excel to treat quoted values as Text when Excel opens a CSV file?


There is no way to do it automatically. You need to convert the file to the following format first:


If your files do have the format as you said (i.e. all you need is to add = in the beginning of every line) then the conversion is easy. Create a CONVERT.BAT file on your Desktop with the following code:

@echo off
mkdir "%USERPROFILE%\Desktop\Converted CSV files"
if '%1'=='' goto done
set CSV="%USERPROFILE%\Desktop\Converted CSV files\%~nx1"
for /F "tokens=*" %%A in ('TYPE %1') do echo =%%A >>%CSV%
goto next

Now you can drag-n-drop your .CSV files on the CONVERT icon. The processed files will appear in the Converted CSV files folder.

  • That is also the only way I know. Excel is pretty braindead when it comes to CSV handling. You can't even tell it to treat everything in the file as plain text (which should be the default imho if you doubleclick the CSV instead of importing it via the File-Open wizard). – Tonny May 15 '13 at 18:43
  • How do you do that when opening the file? Or I am missing something... – Jerry May 15 '13 at 18:49
  • @Jerry Edit the file with a plain text editor like Notepad before loading it into Excel. Yes... I know... You might just as well start Excel first and then open the CSV through File-Open and set the type via the wizard. That's actually less hassle. As I said. Excel is stupid about CSV handling. – Tonny May 15 '13 at 21:40
  • Ah, okay, that clears the process up :) And yes, even if I were to use a script to add the equal sign... the import wizard would be a much simpler and faster method. – Jerry May 16 '13 at 6:24

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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