excel 2007-> txt problem

braatendi · 05-26-2008, 03:13 PM

I am working with a big spreadsheet in MS excel 2007 that I need to convert into a txt file or something else friendly enough to be recognizable to most statistics programs (particularly JMP, SPSS).

I tried "save as" but there appears to be no txt option. The file is too big to be recognized in excel 2003 or most other spreadsheet software so I can't convert to one of those and to text from there. Any help would be appreciated.

**peterhuang913** · 05-26-2008, 03:43 PM

Go to the Microsoft circle on the top left. Click on it>Save As>Other Formats
Select txt as the type.

Try that.

braatendi · 05-26-2008, 04:01 PM

Thank you.

**peterhuang913** · 05-26-2008, 04:52 PM

No problem.

caravanguard · 10-14-2008, 08:31 AM

Hi there

I have the same problem in that I need to export an excel file to a .txt document, however, when I go to 'save as' and other formats, there is no text option in the drop down type box, just different excel formats and xml formats. Any ideas?

Thanks in advance

**gistek** · 10-14-2008, 01:00 PM

They should be there. Try doing a repair install from your MS Office disk.

This work-around might also help. Select the cells you want to export and copy / paste them into Word. There will be an icon at the end of the section. click it and select the text only option. Then save the file as text. This will give you a tab delimited file.

If Word doesn't have a saveas text option, try notepad or wordpad.

05-26-2008, 03:13 PM	#1 (permalink)
braatendi Registered User Join Date: May 2008 Posts: 2 OS: xp	excel 2007-> txt problem I am working with a big spreadsheet in MS excel 2007 that I need to convert into a txt file or something else friendly enough to be recognizable to most statistics programs (particularly JMP, SPSS). I tried "save as" but there appears to be no txt option. The file is too big to be recognized in excel 2003 or most other spreadsheet software so I can't convert to one of those and to text from there. Any help would be appreciated.

05-26-2008, 03:43 PM	#2 (permalink)
peterhuang913 TSF Enthusiast Join Date: May 2008 Posts: 946 OS: XP Home SP2	Re: excel 2007-> txt problem Go to the Microsoft circle on the top left. Click on it>Save As>Other Formats Select txt as the type. Try that.

05-26-2008, 04:01 PM	#3 (permalink)
braatendi Registered User Join Date: May 2008 Posts: 2 OS: xp	Re: excel 2007-> txt problem Thank you. Last edited by braatendi; 05-26-2008 at 04:03 PM.

05-26-2008, 04:52 PM	#4 (permalink)
peterhuang913 TSF Enthusiast Join Date: May 2008 Posts: 946 OS: XP Home SP2	Re: excel 2007-> txt problem No problem.

10-14-2008, 08:31 AM	#5 (permalink)
caravanguard Registered User Join Date: Oct 2008 Posts: 1 OS: xp sp2	Re: excel 2007-> txt problem Hi there I have the same problem in that I need to export an excel file to a .txt document, however, when I go to 'save as' and other formats, there is no text option in the drop down type box, just different excel formats and xml formats. Any ideas? Thanks in advance

10-14-2008, 01:00 PM	#6 (permalink)
gistek Folding Along Join Date: May 2007 Location: PA, USA Posts: 1,904 OS: Bobbi=xp, sp3 Muse=Vista Home Premium	Re: excel 2007-> txt problem They should be there. Try doing a repair install from your MS Office disk. This work-around might also help. Select the cells you want to export and copy / paste them into Word. There will be an icon at the end of the section. click it and select the text only option. Then save the file as text. This will give you a tab delimited file. If Word doesn't have a saveas text option, try notepad or wordpad. __________________ I am not a computer professional, My advice comes from personal experience and/or friends who are computer professionals. Learn By Doing Un-versity Interested in Search and Rescue? Check out the Civil Air Patrol. Come Fold with us. TSF Folding@Home Team