Excel Export – Specify Delimiter for Excel 2007 Export

exportmicrosoft excel

I'm trying to save an Excel 2007 file as a pipe-delimited text file but in the Save As list, I see only tab-delimited and csv options. How do I go about specifying the delimiter, which as I recall was possible in earlier Excel versions via a wizard?

Best Answer

From this page:

  • Bring up your default options window by clicking Start -> Settings -> Control Panel -> Regional Settings.
  • Click the "Customize" button.
  • Click the “Number” tab and in the “List Separator” field, replace the current default separator with the one you want to use (in your case, the pipe symbol).
  • Click “OK” to save the change and close the window.

Now exporting as CSV in Excel will produce pipe-delimited files.

Related Question