How often do you have to take a spreadsheet data and covert to a character separated value? Tabular data, be it a number or a text are all stored in a plain text form by CSV (Comma Separated Values) files. A CSV file can compile a number of records with separate fields, which are uniquely identified by a standardized literal comma, tab, any character or string. This type of file format has been widely supported and used in many fields. All types of spreadsheets and database management systems basically support these CSV files.

Technological advancement has led to abbreviate everything online. So, here is an online tool that will make your task a little bit easier. It is a helpful online tool that will take your spreadsheet of data and convert to a comma-delimited list. A comma-delimited list is a type of data format in which each piece of data is separated by comma as mentioned above. is an website that will take a list of zip codes or names to make an SQL query, or to take data from CSV and paste into an array in a easier, faster and better way. Adam Diehm, intending to covert SQL Queries, Programming values, produced this tool or one’s use cases into a delimited sequence of values.

Lets see how it works, the website basically comprises a column non-delimited data box on the left side of the screen for input and the delimited data are accordingly displayed on the right hand side of the screen after to click the hit button.

How about an example showcasing how this thing really works? Lets see an exemplar for this,

1. Visit the site.
2. Lets us take a list of ZIP codes in North Caroline and try converting it.


Delimited Data

It’s amazing to see how these ZIP codes are converted into delimited data in no time.

3. User’s can choose characters that they want to separate the data with.

Characters in Delim

Delim Characters

4. They can also visit the converter settings for changing any kind of configuration.
You can play with the data using different combinations i.e. in whichever format you want to represent the data.

Data Representation Change Data Format
This is a sort of custom website or web application that allows you to ease your work. This can be a helpful tool for those who struggle with finding an easy and fast way to delimitate data.

I am personally in love with this we application and strongly recommend you to try using it. It saves a lot of your time and effort as well.

What do you really think of it? Comment below to let us know more.


About Author: Nikita Gautam is currently doing her undergrad (BSc CSIT) at Deerwalk Institute of Technology. She blogs on AxisTechBlog.