Question: how to convert pipe delimited csv file to excel?
Answer: Step 1: This is where we start – copy and paste the file into Excel, you can do this by opening the file in Notepad and just copying the whole thing.
Step 2: Highlight column A – this is where all the data is.
Step 3: From the Data Menu – choose “Text to Columns”
Step 4: In the box that comes up, choose “Delimited”