convert excel to pipe delimited text file

If there is more than one sheet with data, you will be asked which sheets to import - choose the sheet you wish to convert.

Drag the Excel spreadsheet onto Easy Data Transform.

Make sure the Auto Run button is pressed in. There is a fully functional free trial and you don’t have to give us your email or sign up to anything.

Install Easy Data Transform on your PC or Mac, if you haven’t done so already.

However it is very easy to convert an Excel file to pipe delimited in Easy Data Transform:

Which means “Smith, John” has become “Smith| John”, which is almost certainly not what you want. If you replace all the commas with pipes, you will get: 'Name'|'Country' For example a name value in a CSV file might include a comma: 'Name','Country' in a text editor) is not advisable, because you might covert a delimiter character inside a value. Trying to convert the delimiter of a CSV file using simple find and replace (e.g.

However some programs expect a pipe (|) delimiter.

Excel typically saves CSV files with using comma (,) or semi-colon ( ) as the delimiter.

Convert excel to pipe delimited text file