Forum Discussion

Kobus4838's avatar
Kobus4838
Copper Contributor
Aug 23, 2022

Downloading a file in CRV format and saving as Excel

Hi, I still used a much older Windows and Excel version and have had to very recently upgrade to MS 365 and Windows 10.  Downloading a (ie) bank statement in CSV and filing it as an Excel spreadshe...
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Aug 23, 2022
Have you tried opening the CSV directly from file explorer?

When you use Data | From Text/CSV, PowerQuery is invoked and may not be needed in this situation.
  • Kobus4838's avatar
    Kobus4838
    Copper Contributor
    Aug 23, 2022
    Yes I did and it opens in a PowerQuery mode - which I do not need

Resources