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”