Excel – How to change default delimiter in the Text Import in Excel

csvimportmicrosoft excel

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?

Best Answer

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.