Can I convert a xls file to a txt file

July 6, 2009 at 16:29:06
Specs: Windows Vista
I have info in a xls spreadsheet that I need to provide to someone as a txt file. Is there a way to convert the data into a txt file. It has fixed lengths and it is not formatting correctly when I copy and paste the fields in notepad.

See More: Can I convert a xls file to a txt file

Report •


#1
July 6, 2009 at 16:41:17
Do a "Save As" then change the filetype to txt. Keep in mind, the formatting will not stay the same.

Does it absolutely have to be in txt format?

LIR


Report •

#2
July 6, 2009 at 16:42:24
Long way around:

Open another instance of Excel,
Copy/Paste your info to the new instance of Excel
Save As CSV (Comma Separated Values)

MIKE

http://www.skeptic.com/


Report •

#3
July 6, 2009 at 18:58:24
The text does not have to be the same but spaces need to be between the second and last header. The txt file should have fixed lengths as well. I actually received the file as a txt, converted it to a xls so that I can import it into access. Afterwards I exported it as a xls and wanted use the results and turn it back into a txt file. Is there a better way?

Report •

Related Solutions

#4
July 6, 2009 at 19:30:29
Why don't you just export it from Access as a fixed width field text file?

Are you making changes to the data while it is in xls format?

If copying to notepad does not retain the formats, have you tried Wordpad and/or Word?

In both programs
Select Paste Special
and select Unformatted Text

MIKE

http://www.skeptic.com/


Report •

#5
July 7, 2009 at 18:32:12
I did not think I could export the file out of access as a txt file. Thanks, that just saved me a lot of time. I was trying to export the file as a xls and then convert it back to a txt file.

Report •

#6
July 7, 2009 at 19:46:01
This is for Access 2007 but it should give you a start:

http://office.microsoft.com/en-us/a...

MIKE

http://www.skeptic.com/


Report •


Ask Question