1

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
  • 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, 2014 at 14:09

1 Answer 1

0

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 agree to our terms of service, privacy policy and cookie policy

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