Actually, what I did was follow what Irtetala noted, this is the exact thing I did to get it
Use Excel file and read formatting as “display value” (as the suggestion called for)
EXPORT this foundation file to csv
It produces a comma delimited so all i do after that is I read the previous csv file I created and then write it to the final file with the pipe delimited.