Forum Discussion

SStudio2015's avatar
SStudio2015
Copper Contributor
Jul 28, 2022

Excel data import_Wrong numbers

Hello,

 

I'm having big problems importing data to excel. I import point values from a txt file.

 

Instead of a number, it inserts a date for me.
If I insert the data as a number, it inserts completely different values.
But if I insert data as text, I can't use formulas (this numbers are correct).

 

Due to the incorrect entry of values, very large errors can occur in my work.

How can I edit this so that the input is correct.

 

Thank you.

 

BI & Data Analysis
excel

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jul 28, 2022

    SStudio2015 Do NOT copy and paste directly from the txt file, but use Data, From Text/CSV or Data, Get Data, Legacy Wizards, From Text.

     

    The first option opens the Power Query editor and may be a bit overwhelming if you haven't used it before. The second option opens a straight forward wizard that guides you through an import process. In step three it's important that you correctly set the data type for each column.

Resources