How do I save a Numbers spreadsheet in .txt format?

Melissa,

Use the Export option, in either the File menu or the Share menu. Export to CSV and then in the Finder change the file name extension from .CSV to .TXT and your online program should be happy.

Jerry

From my point of view, the easy clean way is to select the table

copy

Paste in Textedit

set format to text

Save.

An alternate scheme is this old script :

--{code}

--[SCRIPTclipboard2textFile]

(*

Enregistrer le script en tant que Scriptl :clipboard2textFile.scpt

déplacer le fichier créé dans le dossier

<VolumeDeDémarrage>:Users:<votreCompte>:Library:Scripts:

Copiez les données à exporter dans le Presse-papiers.

menu Scripts > clipboard2textFile

Le script créera un fichier texte.

--=====

L'aide du Finder explique:

L'Utilitaire AppleScript permet d'activer le Menu des scripts :

Ouvrez l'Utilitaire AppleScript situé dans le dossier Applications/AppleScript.

Cochez la case "Afficher le menu des scripts dans la barre de menus".

+++++++++

Save the script as a Script, an Application or an Application Bundle:clipboard2textFile.xxx

Move the newly created file into the folder:

<startup Volume>:Users:<yourAccount>:Library:Scripts:

Coopy the datas to export into the clipboard

menu Scripts > clipboard2textFile

The script will create a text file.

--=====

The Finder's Help explains:

To make the Script menu appear:

Open the AppleScript utility located in Applications/AppleScript.

Select the "Show Script Menu in menu bar" checkbox.

+++++++++

Yvan KOENIG (Vallauris FRANCE)

7 juillet 2009

*)

--=====

on run

try

set enTexte to the clipboardastext

set fName to (do shell script "date " & quote & "+_%Y%m%d-%H%M%S.txt" & quote)

set p2d to path to desktop

tell application "System Events" to make new file at end of p2d with properties {name:fName}

write enTexte to file ((p2d as text) & fName)

on error

if my parleAnglais() then

error "The clipboard doesn’t contain text data. Maybe you selected a Numbers sheet !"

else

error "Le presse-papiers ne contient pas de données texte. Vous avez peut-être copié une feuille de Numbers !"

end if

end try

end run

--=====

on parleAnglais()

local z

try

tell application "Numbers" to set z to localized string "Cancel"

on error

set z to "Cancel"

end try

return (z is not "Annuler")

end parleAnglais

--=====

--[/SCRIPT]

Yvan KOENIG (VALLAURIS, France) vendredi 7 octobre 2011 11:15:58

iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0

My iDisk is : <http://public.me.com/koenigyvan>

Please : Search for questions similar to your own before submitting them to the community

Melissa,

I'm sorry that you are having difficulty. Yours is a tough question to handle according to the guidelines of the forum. We are supposed to test and confirm our suggestions, and indeed would like to do that, but in this case there is no possibility to try our methods from where we sit.

It may be a typo, but in your initial problem statement, you say that you need a "text delimited" data format. This doesn't help us. If you could pass along a more detailed format description it would be good, or maybe you could post a sample of a successful file.

Have you tried exporting from Address Book?

Regards,

Jerry

Melissa,

After reading the requirements, I agree that you could type a short contact list faster! Those requirements sound the same as for Importing into Apple's AddressBook. I recently went through that exercise here and couldn't believe how tedious it was, and in the case of Apple's instructions, how much more difficult than the instructions made it sound at first. To boil down what I read in your post above: You need to begin with a table that has a header row with every possible contact list field in it. Then fill out a body row in the table with whatever information you have for each contact. You will have many blank columns in the body of the table.

It seems that AddressBook, and possibly your Online Contact Manager, requires that import files have a field for every field in the Contact database, whether you need it or not. In Numbers the easiest way to get such a starting table is to drag one contact from your AddressBook to a blank area of a Numbers Sheet (away from any existing table - Best to start by deleting any existing table on the Sheet). This will give you a table with every possible field, but all but the populated ones for that particular contact will be hidden. To see them all, hover over the column label, click the triangle and select Unhide all columns.

Now you will have a starting point for making a table that can be imported into your conatct manager.

Jerry

melissafromgilbert wrote:

Yvan - unfortunately, using the Textedit option did not work either. When I attempted to upload, it recognized every cell as an individual entry, thus maxing out the number of contacts that is allowed.

What with the script ?

Alt scheme

Select the table

copy

paste in Pages

select the pasted table

Format > Table > Convert table to text

Export as text

Yvan KOENIG (VALLAURIS, France) samedi 8 octobre 2011 09:21:37

iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0

My iDisk is : <http://public.me.com/koenigyvan>

Please : Search for questions similar to your own before submitting them to the community

can't you copy the information out of numbers and paste it into a text document (like Main, TextEdit, XCode, or what ever text editor you like), then copy from there to the we application?

Wayne,

As Yvan implies, the user must be careful to assure that the file is plain text and not RTF format.

After pasting into TextEdit, use Format > Make Plain Text

Regards,

Jerry

Good point. I have my mail defaulted as text so I rarely have probles with this kind of stuff...