How Do I Get “Ask for Text” Text Into an Excel Sheet Using Automator?

Comments: 5 Responses to “How Do I Get “Ask for Text” Text Into an Excel Sheet Using Automator?”

Gary Rosenzweig

11 years ago

Hard to say without knowing how the data is saved now. Are you saving it to a text file? If so, then you can just open that text file in Excel or whatever.

Jim

11 years ago

Could you guide me on how to save it to a text file?
Thanks
Gary.
P.S. Your videos are the best on youtube. Have learned soooo much.
Thanks
Jim

Gary Rosenzweig

11 years ago

Ah, I thought you were doing that already. So right now you just ask for the text and then do nothing with it?
Using Automator to add to a text document isn't easy. It is stretching what Automator can do. You can use AppleScript inside of Automator to do it, but it depends on your programming skill.
If you look in Automator under Text actions there are a few you might be able to piece together if you are clever: New TextEdit Document, Get Contents of TextEdit Document, Set Contents of TextEdit document, etc. Though it might be impossible without at least a little AppleScript.
Perhaps you are simply using the wrong tool for this task. Is the Mac connected to the Internet? Then why no use a Google form? http://macmost.com/using-google-forms-to-create-questionnaires.html

Joseph M Landwermeyer

11 years ago

Why not just use a data form in excel to get the information into it?

Make the following columns: Frst Name, Last Name, Email Address (optional - Newsletter, if you want to find out if they would like to receive newsletters) Then use Data>Form.

Jim Estrella

11 years ago

Joe
Could you explain in more detail. I'm trying to use automator were a person walks up to a computer before a meeting and signs in. Then his data is sent into an excel or word file to save later. Thanks for the help
Jim