How to Change the Delimiter in a CSV File
A comma separated value (CSV) file is a text file presented in a spreadsheet format. Each data set or cell is separated by a delimiter. The easiest way to create a CSV file is by using spreadsheet software. Spreadsheet software automatically inserts delimiters to separate cell data. CSV files can also be created in text editors such as Notepad. The default delimiter for CSV files is a comma; however, this can be changed.
Other People Are Reading
Instructions
-
-
1
Open the "Start" menu. Select the "Control Panel" from the menu.
-
2
Choose "Clock, Language, and Region" from the list of options.
-
-
3
Select the link "Change the date, time, or number format."
-
4
Click the "Additional Settings..." button.
-
5
Click the "List separator:" box. Replace the comma with the symbol you want set as the default delimiter.
-
1
References
- Photo Credit Jupiterimages/Photos.com/Getty Images
