Converting Excel file into txt

Question

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

sergeibaklan · Answer

Hi Manon,&nbsp;You may try to save as space-delimited (.prn) filehttps://support.office.com/en-us/article/File-formats-that-are-supported-in-Excel-0943ff2c-6014-4e8d-aaea-b83d51d46247&nbsp;but it has some limitshttps://support.microsoft.com/en-us/help/249885/formatted-text--prn-is-limited-to-240-characters-per-line-in-excel&nbsp;

manon lelandais · Answer

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

haytham amairah · Answer

Hi Manon,&nbsp;Try to copy your data, and paste it in a text file as follows:&nbsp;&nbsp;Another way:Press F12, and save your workbook as Text (Tab delimited) (*.txt) type.&nbsp;In both cases, your data is supposed to&nbsp;remain organized and separated by tab character,&nbsp;unless there is a problem!

manon lelandais · Answer

Hi Haytham,Thanks for your suggestions. I unfortunately tried both and the data gets mixed up everytime :&nbsp;

johndre · Answer

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/highlight/true#M1417 for Doc Converter

Forum Discussion

Converting Excel file into txt

5 Replies

Resources