saving .txt with Numbers

Snorkle · Snorkle #1 (**permalink**)

07-06-2010, 02:13 PM

Does anyone know how to save a file as .txt with numbers?

It won't let me save .txt w/o adding .numbers, so that it looks like filename.txt.numbers

I can convert to a filename.xls, but then can't convert that to filename.txt and be able to open it with a text editor.

chscag · chscag #2 (**permalink**)

07-06-2010, 03:45 PM

I don't understand why you need or would want to save a spreadsheet file as text? You would lose all formatting if you did and any kind of graphing would likewise be lost.

If there are parts of the Numbers or Excel file you want to export to text, you can always do that with copy and paste. But again, you would have to consider the formatting.

Regards.

Snorkle · Snorkle #3 (**permalink**)

07-06-2010, 08:25 PM

I am working with a large data set and want to delete two entries from every line. If i load it into a spreadsheet I can easily delete the two columns then save it as a text file and open it with the program that i am using to manipulate the data.

technologist · technologist #4 (**permalink**)

07-07-2010, 12:55 AM

Numbers can export tables as CSV files, which are text-based.

It's hard to translate a table of values, with rows and columns, into a plain old .txt file.

chas_m · chas_m #5 (**permalink**)

07-07-2010, 11:24 AM

File -> Export

Snorkle · Snorkle #6 (**permalink**)

07-07-2010, 12:26 PM

thanks for the replies, not working though.

I was trying to avoid DLing and installing excel, but alas that's what I had to resort to. It's just silly that numbers doesn't have this basic function that excel has been doing for ages.

Aptmunich · Aptmunich #7 (**permalink**)

07-07-2010, 01:50 PM

Copy and the section you want, open Textedit, select "format > make plain text" and paste.

Save to create a .txt.

chscag #2 (permalink)
Member Since: Jan 23, 2008 Location: Fort Worth, Texas Posts: 31,978 Mac Specs: 21.5" iMac 2.5 GHz i5, iPad 3rd Gen., 3 iPods	07-06-2010, 03:45 PM I don't understand why you need or would want to save a spreadsheet file as text? You would lose all formatting if you did and any kind of graphing would likewise be lost. If there are parts of the Numbers or Excel file you want to export to text, you can always do that with copy and paste. But again, you would have to consider the formatting. Regards. Community Guidelines
	QUOTE Thanks

chas_m #5 (permalink)
Member Since: Jan 22, 2010 Location: Victoria, BC Posts: 13,696 Mac Specs: 2009 MacBook Pro, Black speakers, Black Benq second monitor, black iPhone 4, Black 2012 iPad, etc.	07-07-2010, 11:24 AM File -> Export Cheers, chas_m -- My essay for switchers and newbies
	QUOTE Thanks

Aptmunich #7 (permalink)
Member Since: Mar 09, 2004 Location: Munich Posts: 9,075 Mac Specs: Aluminium Macbook 2.4 Ghz 4GB RAM, SSD 24" Samsung Display, iPhone 4, iPad 2	07-07-2010, 01:50 PM Copy and the section you want, open Textedit, select "format > make plain text" and paste. Save to create a .txt. Mac-Forums Twitter \| Mac-Forums Blog My Twitter \| Jetplane Journal
	QUOTE Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Issue saving .xls in numbers 09	Xanthian	OS X - Apps and Games	0	03-28-2010 09:06 AM
Phone numbers disappear in Address Book	Juba22	OS X - Apps and Games	0	12-14-2009 08:48 AM
iTunes Track numbers with audible files	charliexedd	OS X - Apps and Games	1	11-07-2009 02:28 PM
Copying data from email into numbers on iMac	Andy and Shell	Apple Desktops	0	03-08-2009 05:22 PM
Cutting and Pasting from emails into Numbers	Andy and Shell	Switcher Hangout	0	03-08-2009 05:20 PM

saving .txt with Numbers

Internet Services

Web Development

Digital Marketing

Consumer Tech

Snorkle #1 (permalink)
Member Since: Jul 06, 2010 Posts: 3	07-06-2010, 02:13 PM Does anyone know how to save a file as .txt with numbers? It won't let me save .txt w/o adding .numbers, so that it looks like filename.txt.numbers I can convert to a filename.xls, but then can't convert that to filename.txt and be able to open it with a text editor.
	QUOTE Thanks

technologist #4 (permalink)
Member Since: Mar 30, 2004 Location: USA Posts: 4,744 Mac Specs: 12" Apple PowerBook G4 (1.5GHz)	07-07-2010, 12:55 AM Numbers can export tables as CSV files, which are text-based. It's hard to translate a table of values, with rows and columns, into a plain old .txt file.
	QUOTE Thanks

Snorkle #6 (permalink)
Member Since: Jul 06, 2010 Posts: 3	07-07-2010, 12:26 PM thanks for the replies, not working though. I was trying to avoid DLing and installing excel, but alas that's what I had to resort to. It's just silly that numbers doesn't have this basic function that excel has been doing for ages.
	QUOTE Thanks

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)