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 want to import a CSV file to Excel. The CSV file has comma separated data (go figure), but the delimiter in the Text Import Wizard is set to "Tab" by default. How can I change the default to "Comma" instead?

share|improve this question
fergulator has an answer that works well – pypmannetjies Oct 30 '12 at 14:19
up vote 8 down vote accepted

This is a Windows setting that will be used by all programs that refer to it (Excel in this case).

  1. Click the Start button, and then click Control Panel.
  2. Open the Regional and Language Options dialog box.
  3. Do one of the following: In Windows Vista/7, click the Formats tab, and then click Customize this format. In Windows XP, click the Regional Options tab, and then click Customize.
  4. Type a new separator in the List separator box.
  5. Click OK twice.
share|improve this answer
This doesn't works... – Stormenet Sep 16 '11 at 8:33
It works when you use the normal file->open procedure – pypmannetjies Oct 30 '12 at 14:19
Excel ignores this locale setting for common data file extensions like .dat and .txt – pokeeffe Aug 21 '15 at 20:12

(Assuming the Office 2003 interface)

Don't use File > Open.

Instead use Data > Import External Data > Import Data...

This will invoke the Text Import Wizard, which lets you choose the delimiter. Text Import Wizard - Step 1 Text Import Wizard - Step 2

Or, if you're using the newer interface, go to the Data tab > From Text:

Text Import 2007

This will pull up a File Open dialog, followed by the same Text Import dialog.

share|improve this answer
Yes, I am aware of the Text Import Wizard, I should have mentioned it in the question, not just the title. What I want to do is change the default from "Tab" to "Comma" in that wizard. Its a pain to have to change it when I never have tab delimited imports. – Lars Jun 1 '11 at 11:13
@Lars: datatoo's pointer to Dave Peterson's solution works perfectly well for me. – PonyEars Jan 9 '14 at 1:56

Excel appears to use the last used delimiter in the session. Dave Peterson describes a possible solution here You essentially create a macro that sets the default delimiter and place it in the xlstart folder. If you are doing this for a file on other peoples machines, that is not probably going to work, but this is how you would approach it, programatically on your own system, and you may adapt it to your situation. Running the following code should set the delimiter for you beforehand. This will operate on an existing session. So if you have content that expects specific delimiters setup, run something like this prior to your import, setting whatever parameters you like

With ThisWorkbook.Worksheets(1).Range("a1")
 .TextToColumns Destination:=.Columns(1), DataType:=xlDelimited, TextQualifier:=xlDoubleQuote,  ConsecutiveDelimiter:=True, Tab:=False, Semicolon:=False, Comma:=True, Space:=False, Other:=False
End With
ThisWorkbook.Close SaveChanges:=False
share|improve this answer

You must log in to answer this question.

protected by Community Oct 12 '13 at 19:47

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

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