How do I convert a CSV file to a pipe delimited in Windows 10?

Question

How to Convert Excel to a Pipe Delimited Text File In the Control Panel of your computer, adjust the view to View by Large Icons, and then select Region. Select Additional Settings. Change the List separator to a pipe character. The pipe character is found above the ENTER key on the keyboard (SHIFT + BACKSLASH).

How do I change from separator to pipe in Windows 10?

To change regional settings,1go to Start > Control Panel > Regional and Language Options | Windows 10 (Start >type Control Panel and press enter > Region)2Click Additional Settings.3For Decimal Symbol, enter a dot: .4For List Separator, enter a comma: ,Changing Regional Setting in Windows (CSV imports) - ResRequest

How do I make a csv file a pipe delimited?

Browse to the folder where you want to save the new file in the “Save As” window. Enter a name for the new pipe-delimited format file in the “File Name” field. Click the “Save as Type” drop-down list and select the “CSV (Comma Delimited)” option. Click the “Save” button.

How do you change a CSV file from comma delimited to pipe delimited?

The key, here, is to type “ ” (without the quotes) in the “Find What” field. “ ” is the placeholder symbol for a tab. Then just type a pipe in the “Replace with” field. Also, be sure to click the radio button next to the “Extended” option.

Can a csv file be pipe delimited?

Unfortunately all CSV files are not created or formatted in the same way, so you can run into situations where a CSV file is not compatible with what you are attempting to do. One way this can occur is if you have a CSV comma delimited file, but you need a pipe, or |, delimited file.

Expert · Answer