App: Convert Rows To CSV or CSV to Rows

It never fails that every time I’m working to move data from one system to another using a text area field, my data is formatted incorrectly. Some systems want all of the values in a comma-separated value (CSV) like this:

value1, value2, value3
value4, value5, value6

And other applications want a list with each item on its row like this:

value1, value4
value2, value5
value3, value6

So, here’s another cool little Martech Zone app 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. The tool will transform rows to CSV, and CSV to rows for you.

Click to Open Tool (Not Translated)

I have found and corrected a few bugs with this over time, in case you’ve tried it before and not gotten the results you were looking for! If you get an incorrect result, please contact me with some data to test.

This is just a browser-based tool, so inserting millions of rows may not be possible since your local browser and resources are doing the work.

Common Lists

There are always some common lists we use in marketing, so I’m going to include some here:

1. Countries

United States, Canada, Mexico, United Kingdom, Germany, France, Italy, Spain, Australia, Japan, China, India, Brazil

2. States (for the U.S.)

Alabama, Alaska, Arizona, Arkansas, California, Colorado, Connecticut, Delaware, 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

3. Job Titles

Software Engineer, Data Scientist, Marketing Manager, Sales Associate, Customer Service Representative, Graphic Designer, Human Resources Manager, Project Manager, Business Analyst, Financial Analyst, Product Manager, Operations Manager, Web Developer

4. Payment Methods

Credit Card, Debit Card, PayPal, Bank Transfer, Check, Bitcoin, Apple Pay, Google Pay

5. Event Types

Conference, Webinar, Workshop, Seminar, Networking Event, Trade Show, Product Launch, Panel Discussion, Meetup, Training Session, Retreat

6. Product Categories

Electronics, Apparel, Home Goods, Beauty Products, Books, Toys, Sports Equipment, Furniture, Automotive, Health & Wellness, Food & Beverage

7. Survey Question Options

Strongly Agree, Agree, Neutral, Disagree, Strongly Disagree

8. Feedback Ratings

Excellent, Good, Average, Poor, Very Poor

9. Department Names

Sales, Marketing, Human Resources, Finance, IT, Customer Service, Operations, Legal, Product Development, Research & Development

10. Education Levels

High School, Associate Degree, Bachelor’s Degree, Master’s Degree, Doctorate

These lists can be very useful for forms, surveys, and data collection tools, providing users with a standardized set of options.