Windows Vista

How to open a CSV file that uses Pipe Delimiters in Microsoft Excel

Written by Ian Carnaghan · 31 sec read >

CSV stands for comma separated file, sometimes we don’t want to use comma’s in a CSV file and decide to rather use a Pipe Delimiter | especially in cases where one of the columns contains a paragraph with comma’s in. Open Office provides us with a option to choose the Delimiter when opening CSV files, but MS Excel does not. But luckily theres a way around this.

NOTE: This how-to has been based on Windows Vista, but will work on other Windows versions as well.

 

  • Microsoft Excel uses the current list separator in the locale settings of Windows
  • Go to Control Panel

    Control Panel

  • Open Regional and Language Options

    Regional and Language Options

  • Click on Customize this format…

    Customize this format...

  • The Customize Regional Options window will appear

    Customize Regional Options

  • Change the List separator from , (COMMA DELIMITER) to | (PIPE DELIMITER)

    List separator

  • Open the CSV file with Pipe Delimiters again in MS Excel and it will open as expected.

Last Updated On March 24, 2018
Written by Ian Carnaghan
I am a software developer and online educator who likes to keep up with all the latest in technology. I also manage cloud infrastructure, continuous monitoring, DevOps processes, security, and continuous integration and deployment. In my spare time I teach undergraduate classes in web development. Profile

Leave a Reply

avatar
  Subscribe  
Notify of