Follow

HOW TO EXPORT AN EXCEL FILE TO PIPE DELIMITED FILE

During my course of converting an excel to a (|) "pipe" delimited file, I was able to do something like ‘save as’ and select the file type ‘CSV (Comma delimited)(*.csv)’ and then re-open as text file and replace all (,) to a (|). By doing so I notice that the commas in the addresses were also change to (|).

After a little head scratching with harry and a quick google, I found I had to make a global setting change in control panel (Yes, that’s right).

So in Windows 7, I found you must do the following to change the delimiter and I hope this helps us all.

  1. Make sure Excel is closed
  2. Navigate to control panel
  3. Select ‘Region and Language’
  4. Click the ‘Additional Settings’ button
  5. Find the List separator and change it from a comma to your preferred delimiter such as a pipe (|).
  6. Click OK
  7. Click OK
  8. Exit Control panel
  9. Open the Excel file you want to export to a pipe delimited file
  10. Select File, Save As
  11. Change the ‘Save as type’ to ‘CSV (Comma delimited)(*.csv)’
  12. Change the name and file extension if you want, by default stays as csv even though a different delimiter
  13. Click Save
  14. Click OK
  15. Click Yes

Odunayo!

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk