How to Separate Comma Separated Values in Excel?

Today we are going to learn a very interesting feature in excel. Sometimes there are text components that we write separated by a comma.

For instance, let’s imagine a scenario. Suppose a teacher is responsible for buying the sports equipment for the Picnic. So, he gets an email from the event manager with the list.

The list is a ball, bat, stick, balloon, candy. He will have to make columns for each piece of equipment and allocate numbers according to the student list.

and He can type the equipment one by one but there is another easy way.

He can copy the list from the email and can separate values by delimiters in excel. In this case, the delimiter is a comma.

How to Separate Comma Separated Values in Excel?

So, let’s see how to separate comma-separated values in excel.


You can see the pieces of equipment are separated by a comma in a cell. Now the task is to separate the values and place them in their own columns.


First, select the cell you want to separate. Then go to Data.



go to Text to Columns.



Make sure the Delimited option is ticked.


Then press Next.



Now, select Comma from the delimiters list.

Note: You will notice that there are different delimiters. You can separate values if they are separated by space, semicolon, tab, etc.

select Comma from the delimiters list-1

Then press Next.



Select your preferred data format. The general format is used generally.



Finally, press Finish getting the separated values.


You will see that the values have been placed in their own columns.



Excel’s features are very interesting. There are many processes that can be made easy by excel. It saves time and is sometimes very fun to use.

As now you know how to separate comma-separated values in excel, you can use this feature to separate values that are separated by other delimiters as well.

Leave a Comment