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/Photos.com/Getty 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:
Easy

Other People Are Reading

Instructions

  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

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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