Forum Discussion

Manon Lelandais's avatar
Manon Lelandais
Copper Contributor
Oct 27, 2017

Converting Excel file into txt

Hi everyone, I'm trying to convert an Excel file with simple data ordered in columns into a txt file. The txt file mixes up the data and the columns are disorganised. Is there any way to keep the s...
excel
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Oct 27, 2017

Hi Manon,

 

Try to copy your data, and paste it in a text file as follows:

 

 

Another way:

Press F12, and save your workbook as Text (Tab delimited) (*.txt) type.

 

In both cases, your data is supposed to remain organized and separated by tab character, unless there is a problem!

  • Manon Lelandais's avatar
    Manon Lelandais
    Copper Contributor
    Oct 27, 2017

    Hi Haytham,

    Thanks for your suggestions. I unfortunately tried both and the data gets mixed up everytime :

     

Resources