Excel ignores comma delimiters in .csv files, but invokes the Text Import Wizard for .txt files that "appear delimited". Surely it should behave the same way for .csv files?

  • 1
    For me, I use a small PowerShell tool which I assigned to the extension CSV. The tool opens Excel and tells it to use the text import wizard to import the currently selected CSV – nixda Oct 26 '14 at 14:09

You can always compel the Wizard to appear.

First open Excel, then, using the Ribbon, goto the Data tab and then touch From Text in the Get External Data group.

If you do not need the Wizard, then simply double-click the file's icon to open it.

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.