Forum Discussion

Gabriel Aguilar Stassano's avatar
Gabriel Aguilar Stassano
Copper Contributor
Mar 22, 2018
Solved

Convert txt to excel

Hello,   I´m trying to convert a txt file which has numbers to an excel file so I can review the information easily. I'm using excel 2016 so I go to data, get data, from txt file and the informat...
BI & Data Analytics
Need Help
  • SergeiBaklan's avatar
    SergeiBaklan
    Mar 22, 2018

    Hi Gabriel,

     

    Excel has 15 digit limit in representing the numbers, your ID:s are 19 character long. The workaround not to convert such values to numbers but keep them as text.

    Importing your file don't directly load it into Excel, select Transform data first

    In opened query editor at right pane remove Changed Type step 

    result will be like this

    After that close the editor with loading table to Excel sheet. Please see attached

     

     

     

     

     

     

johndre's avatar
johndre
Copper Contributor
Feb 27, 2019
Try converting the txt file to excel using 3rd party converters and it will keep its original formatting of numbers. You can try Doc Converter for this: https://www.coolutils.com/TotalDocConverter

Resources