FG

How do you change default delimiter in the Text Import in Excel?

Fresh3 days ago
Mar 15, 2026260985 views
Confidence Score0%
0%

Problem

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?

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How do you change default delimiter in the Text Import in Excel?

Low Risk

(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. Or, if you're using the newer interface, go to the Dat…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment