Extract name and email address from Text Message autoresponses using Excel

  • Why not share:
  • Social sharing button for Facebook
  • Social sharing button for Linkedin
  • Social sharing button for Twitter
  • Social sharing button for Googleplus
  • Social sharing button for Pinterest

When using a text message response mechanic it is often good to ask for a name and an email address in the response as well. As the data of the incoming message all comes in in one field it is often a time consuming process to extract the name and email address.

We have built a nifty little Excel worksheet which takes care of this. Download the file here.

INSTRUCTIONS:

When promoting your campaign, it is important to ask people to text in in a specific way which is:
[KEYWORD] space [FIRSTNAMEONLY] space [EMAILADDRESS]

Then, once all the autoresponses are in simply copy and paste them into the yellow part of column A of the Excel sheet. It will remove the keyword and split out the name and email address into separate columns for easier importing into other applications.

Paste your autoresponse data into the yellow section to strip out the name and email address. Handles up to 10,000 records at a time.

Paste your autoresponse data into the yellow section to strip out the name and email address. Handles up to 10,000 records at a time.


Related articles

  1. How to create an Email to SMS Gateway
    This document explains how you can use postfix to call a script, with the result that you can then interface...