Menu Close

How to make a psv file

… and other custom-char delimited files.

Presented below is a screenshot-based tutorial on how to change the character used to separate data pieces within what’s called a List.

STEP ONE and TWO — Open Settings, Organize by Category — then click Clock and Region.
STEP THREE – Click the “Change date, time, or number formats” text.
STEP FOUR — Click the Additional Settings button.
STEP FIVE — Change the List separator character from a comma to something useful like a pipe character — and STEP SIX — Apply the settings for this to take effect.

As soon as you are finished, you can SAVE your CSV file and it will follow this system setting and save the file using the character you’re using. If you chose a pipe character (it looks like this: | ), your csv file data will be separated by a pipe and this is great for data that is comma-inclusive.

If you’re separating by pipe, you can rename the file to carry the extension “.psv” which is used by CVSer to locate pipe-delimited files. It is absolutely necessary step until custom characters are accepted into CSVer.

Source: https://www.ozgrid.com/forum/forum/tip-tricks-code/83703-change-delimiter-for-csv-export-tip?t=134498

Here’s the text from the source in case the page ever goes down:


If you need Export Excel data to a CSV file but the data have commas in it, you can in Windows change the delimiter used in the export from outside of Excel — specifally via the Control Panel.

Go to the Control Panel –> Regional and Language Options (or Date, Time and Regional Options –> Regional and Language Option on some machines) –> click the Customize button. In the dialog box that opens you will see and option for “List separator” in which you can change the comma to a different character –> click Apply then Ok and then Apply again. Now when you go into Excel and choose Export as CSV the new character will be used as the delimiter.

– username thomach on the ozgrid,com forum supplied this helpful tip!

If you liked this article, or have feedback, your thoughts and feedback are welcome – comment below, use the Contact page, or connect via Twitter.

###

Leave a Reply

Your email address will not be published. Required fields are marked *