If you create a CSV file in Microsoft Excel 2010, the file will look different if you open it in a text editor, like Notepad, than it does when you view it in Excel. Each cell of the CSV file is separated by a comma, and the structure that you see in Excel is handled differently when you are viewing the plain text document. Those commas represent the delimiters, which is the character that is splitting each of your fields. Comma delimiters are a common choice in CSV files, but they are not the only option and, occasionally, they might not work for the task that you are performing. We have previously discussed one way that you can change your delimiter in a CSV file, but this will not always be the solution for people that need to modify a CSV file. There is also a way to change the Windows 7 list separator, which means that any CSV file you create in Excel on your Windows 7 computer will utilize a delimiter of your choosing, instead of a comma.
Change the Delimiter Used By Excel on a Windows 7 Computer
It is important to note that when you make this adjustment on your computer, you are changing the way that Excel creates CSV files. If you need to start using comma delimiters again, you will need to repeat the steps in this article to restore the comma as the Windows 7 list separator. Continue reading to learn the procedure that you will need to use to make this Windows 7 list separator change.
Step 1: Click the Start button at the bottom-left corner of the window, then click Control Panel.
Step 2: Click the Change display language link in the Clock, Language and Region section of the window.
Step 3: Click the Formats tab at the top of the window, then click the Additional Settings button at the bottom of the window.
Step 4: Click inside the List Separator field, then replace the value with whatever character you want to use instead. In the image below, for example, I have replaced the comma with a pipe.
Step 5: Click the Apply button, then click the OK button.
If oyu want to test out your new settings, open Excel 2010, and create a sample CSV file. Save the file, close it, then open the CSV file in Notepad. You will see that the delimiters that were previously commas have now been replaced with whatever character you chose as your new Windows 7 list separator.