Forum Discussion

A_Me77's avatar
A_Me77
Copper Contributor
Apr 05, 2022

Data, separation marks change

I would like to ask for your help with the transformation of the CSV file into an excel file. After I download the CSV and import it, there’s a problem with the separation marks. (Excel version: 2102...
BI & Data Analysis
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 05, 2022

A_Me77 

How do you import csv file, using Power Query or 3-steps legacy wizard?

  • A_Me77's avatar
    A_Me77
    Copper Contributor
    Apr 05, 2022
    Dear Sergei!
    I want to say a huge thank you! It is workin with legacy wizard!
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Apr 05, 2022

      A_Me77 

      It shall work with both. Just with legacy wizard you may define separators on third step

      with Power Query is through encoding and delimiter with converting texts to numbers using locale.