Convert Numbers Table to .txt file

.txt is just a file extension. The text and data within it could be any of many different formats.

What do you need the .txt file for? Are you going to be using it to import into another program?

If so, a common format is csv (character separated values). Have you tried File > Export to > CSV... ?

SG

Have you tried exporting to CSV... and then in Finder changing the extension to .txt and trying to import that file into the other program?

It's important to know what the other program is expecting. .txt could contain just about anything.

SG

I'm curious what is wrong with copy, then paste to a text, file, then save?

CSV (Comma , or Character, Seprated Values) and TSV (Tab Sepatated Values) are both text files. the extension is .csv or .tsv but they are, in fact, text files.

Glad my suggestion of changing the file extension helps. I don't understand your use of underscores. Could you post a screenshot showing specifics of what you are doing and hoping to do?

Shift-command-4 will capture a screenshot of part of the display. Then use the 'mountains' icon in the editor here to insert it into your post.

SG

You can use a script like the one below to export comma-separated data in a file with a .txt extension, stripping any leading underscores.

This requires you to click a table you want to export before running.

Note that it will overwrite any existing file you have of that name.

It is of course possible to have the script export more than one table at a time but that would requires specifics on how your document is set up.

The first time make sure Script Editor and Numbers are listed and checked at System Preferences > Security & Privacy > Privacy > Accessibility.

SG

tell application "Numbers"
	tell front document's active sheet
		tell (first table whose selection range's class is range)
			set vv to rows's (cells whose value is not missing value)'s value
		end tell
	end tell
end tell

-- convert to comma-separated values
set commafiedTxt to ""
set text item delimiters to {","}
repeat with r in vv's items
	-- strip any leading underscores
	repeat with i from 1 to r's length
		set iTxt to r's item i's contents
		if iTxt starts with "_" then set r's item i to iTxt's text 2 thru -1
	end repeat
	set commafiedTxt to commafiedTxt & r & return
end repeat

set the clipboard to commafiedTxt

-- save to file wherever convenient
set fName to (choose file name with prompt "Save as File" default name "My Text File") as string
if fName does not end with ".txt" then set fName to fName & ".txt"
set f to open for access file fName with write permission
set eof f to 0 # overwrite existing contents from beginning
write commafiedTxt to f
close access f