CRM and Data PlatformsMartech Zone Apps

Convert Rows To CSV or CSV to Rows

Convert Rows To CSV Convert CSV To Rows Copy Results

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.

Common Lists

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.

Douglas Karr

Douglas Karr is the founder of the Martech Zone and a recognized expert on digital transformation. Douglas has helped start several successful MarTech startups, has assisted in the due diligence of over $5 bil in Martech acquisitions and investments, and continues to launch his own platforms and services. He's a co-founder of Highbridge, a digital transformation consulting firm. Douglas is also a published author of a Dummie's guide and a business leadership book.

Related Articles

What do you think?

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Close

Adblock Detected

Martech Zone is able to provide you this content at no cost because we monetize our site through ad revenue, affiliate links, and sponsorships. We would appreciate if you would remove your ad blocker as you view our site.