Converting Excel file into txt

[Manon Lelandais]

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 simple organisation of the data ?
Many thanks

[#2]

Hi Manon,

You may try to save as space-delimited (.prn) file

https://support.office.com/en-us/article/File-formats-that-are-supported-in-Excel-0943ff2c-6014-4e8d...

but it has some limits

https://support.microsoft.com/en-us/help/249885/formatted-text--prn-is-limited-to-240-characters-per...

[#3]

Hi Sergei,

thank you for your suggestion, it worked. I'm going to try to work around the character limitation.

[#4]

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!

[#5]

Hi Haytham,

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

[#6]

Check this post where I suggested a similar situation https://techcommunity.microsoft.com/t5/BI-and-Data-Analysis/Convert-txt-to-excel/m-p/357360/highligh... for Doc Converter