By default, when you save an excel file to .csv, it will be save as comma seperated file.
For example, you have data in excel that looks like:
|Fig 1: Original format of data|
Lets save this as .csv format:
|Fig 2: Save as Comma separated file|
After saving the file data will look like below:
|Fig 3: Data after converting into CSV |
However, you need to have pipe delimited instead of comma delimited, how do you do that? Please follow the below steps to save file as pipe delimited.
If you are using Windows 10, then you need to go to Settings and then you will find below:
|Fig 4: Settings in Windows 10|
Now please click "Time and Language" option then you will find below screen, where you need to click "Additional time & regional settings" button.
|Fig 5: Related Setting area|
Now you will find below option:
|Fig 6: More click|
If you click on "Change date, time and number formats" under Region section; will find below window (left) and then if you click "Additional settings" then right side window will pop up.
|Fig 7: Additional settings|
Finally you need to change, List separator from comma(,) delimited to pipe (|) delimited.
|Fig 8: List seperator|
And now, if you save the same excel as CSV then it will look like below:
So achieved your goal. However, please remember to change your settings back if you want to have your data as comma delimited.
Post a Comment