How to change the delimiter in a CSV file

Written by leigh thompson
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to change the delimiter in a CSV file
(Jupiterimages/ Images)

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.

Skill level:


  1. 1

    Open the "Start" menu. Select the "Control Panel" from the menu.

  2. 2

    Choose "Clock, Language, and Region" from the list of options.

  3. 3

    Select the link "Change the date, time, or number format."

  4. 4

    Click the "Additional Settings..." button.

  5. 5

    Click the "List separator:" box. Replace the comma with the symbol you want set as the default delimiter.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.