Forum Discussion

Gregmac's avatar
Gregmac
Copper Contributor
Jan 13, 2019

Import CSV to Excel

Greetings would appreciate some help. New laptop with windows 10 & office 365. Unable to download csv. files to excel & separate info to columns with comma of the csv format. Region settings English South Africa. Region, Format, Additional Settings - list separator is a comma & even resetting, double OK button & reboot doesn't change the format.

excel

5 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 13, 2019

    Please clarify what is your last sentence means

    list separator is a comma & even resetting, double OK button & reboot doesn't change the format

    What is your default list separator, comma or not?

    You tried to change it, from what on what?

    • Gregmac's avatar
      Gregmac
      Copper Contributor
      Jan 14, 2019

      Hi Sergei,

      thanks for your response, apologies for my late return.

      If I to 'Control Panel', 'Region', 'Formats', Additional Settings' - the list separator is already a comma ,  Tried re entering it & then 'apply' didn't work, read somewhere double click 'OK' also didn't help. Then tried with rebooting, but still no help. Region settings are all identical to my previous laptop, but perhaps something has been changed now.

      • Gregmac's avatar
        Gregmac
        Copper Contributor
        Feb 24, 2020

        Greetings 

        Old story line but the answer to this question was found....

         

         

        Regional & language settings, Additional date & time & regional settings - south africa, english south africa
        Change date time or number format - all south africa
        Additonal settings - decimal . - list seperator ,
        Regional & language settings, Additional date & time & regional settings - south africa, english south africa
        Change date time or number format - all south africa
        Additonal settings - decimal . - list seperator ,
        Location - south africa

         

         

  • Eva Vogel's avatar
    Eva Vogel
    Iron Contributor
    Jan 13, 2019
    Hi! Just let’s check something:
    Can you pls open the csv file in your Windows Explorer with Right-Click it and choose „Open with....“
    Maybe your brandnew stuff does not know that csv shall be opened with excel. Can you open it now? Greets, Eva
    • Gregmac's avatar
      Gregmac
      Copper Contributor
      Jan 14, 2019

       Hi Eva,

      Thanks for your reply, sorry for the late response.

      I can do open with right click 'open with' & that is set for excel. The problem is that our banks provide statements for downloading only in csv format. During the download comma separation does not function leaving all detail in one line. This is the same whether saved as excel or as csv.

      I had similar problem on previous laptop & managed to resolve it by changing the regional settings - for some reason doing that with this one dose not work.

      Greetings Gret

       

Resources