Home

Converting Excel file into txt

Manon Lelandais
New Contributor

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

5 Replies

Hi Sergei,

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

Hi Manon,

 

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

 

Convert to txt file.png

 

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!

Hi Haytham,

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

 

Sans titre.png

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
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies