How To Use This Online Tool
It never fails that every time I’m working to move data from one system to another using a text area field, I have my data formatted incorrectly. Some systems want all of the values in a comma-separated value (CSV) like this:
value1, value2, value3
And other applications want a list with each item on its own row like this:
value1 value2 value3
So, here’s another cool little Martech Zone app for you that does just that! Just paste your data in the Source Data text area and click the option you’d like to convert the data into the Destination Data text area. If you’re viewing this article anywhere but on my site, be sure to click through to the Convert Rows To CSV app.
The conversion app also:
- Removes duplicate entries
- Orders the results in alphanumeric order
- Trims each of the values so that the result is clean of leading or trailing spaces.
Keep in mind that this is just a browser-based tool so inserting millions of rows may not be possible since it’s your local browser and resources that are doing the work.
There are always some common lists we use in marketing, so I’m going to include some here:
- States (including DC) – Alabama, Alaska, Arizona, Arkansas, California, Colorado, Connecticut, Delaware, District of Columbia, Florida, Georgia, Hawaii, Idaho, Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maine, Maryland, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York, North Carolina, North Dakota, Ohio, Oklahoma, Oregon, Pennsylvania, Rhode Island, South Carolina, South Dakota, Tennessee, Texas, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin, Wyoming
Any other features, lists, or feedback you’d like to see with this conversion tool? Feel free to let me know in the comments.