CODEWITHSUNDEEP
excel
Roy
Roy

Reputation: 31

Import CSV in Excel 2016 without PowerQuery

I have used Excel for many years, but this PowerQuery is not helpfull in my day to day work. It lays on to much functionality not needed. I.E Automatic formating, connection to CSV file etc. It also have problems with decimal convertions.

In Excel 2013 I select Data - From text and i get a Text Import Wizard. But in 2016/365 I automatical get PowerQuery with wrong converts of numbers 7,87 (desimal sign is comma) - and values is handled as text.

Is there any option to turn of use of PowerQuery, and get back to Text Import Wizard instead?

Upvotes: 0

Views: 4479

Answers (1)

joda
joda

Reputation: 405

Yes, it is possible! The following is from professor-excel.com:

  1. Go to File
  2. Go to Options
  3. Go to Data
  4. Check all required legacy wizards, as shown in the image below.
  5. The legacy wizard is now available under the tab Data --> GetData.

Changing the Excel settings: Change the Excel settings

Now the old text import wizard is available: Now the old text import wizard is available

Upvotes: 8

Related Questions