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

I’m trying to get names and e-mail address into an Excel Sheet that people import into my computer using Automator. Example.
People show up to a meeting and go up to the computer to sign in with their name and e-mail address. How do I get that text into an Excel Sheet?
Jim Estrella

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

    11/27/12 @ 10:46 am

    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.

      11/27/12 @ 11:51 am

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

        11/27/12 @ 12:59 pm

        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?

    Joseph M Landwermeyer
    11/28/12 @ 1:36 am

    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
      12/4/12 @ 1:01 pm

      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

Comments Closed.