Site icon Best Excel Tutorial

Save Excel as Pipe Delimited

To save an Excel spreadsheet as a pipe delimited file, follow these steps:

  1. Open the Excel file that you want to save as a pipe delimited file.
  2. Select the range of cells that you want to save as a pipe delimited file. If you want to save the entire worksheet, click the cell at the intersection of row 1 and column A to select the entire worksheet.
  3. Copy the selected range by pressing Ctrl + C (Windows) or Command + C (Mac).
  4. Open a text editor or a plain text document where you want to save the data as a pipe delimited file. You can use software like Notepad (Windows) or TextEdit (Mac).
  5. Paste the copied data into the text editor by pressing Ctrl + V (Windows) or Command + V (Mac).
  6. In the text editor, replace the tab characters with pipe characters (“|”). To do this, press Ctrl + H (Windows) or Command + Option + F (Mac) to open the Find and Replace dialog.
  7. In the “Find what” field, enter a tab character. To type a tab character, press Ctrl + I (Windows) or Command + I (Mac).
  8. In the “Replace with” field, enter a pipe character (“|”).
  9. Click the “Replace All” button or equivalent in your text editor. This will replace all tab characters with pipe characters.
  10. Save the document with a .txt file extension. For example, you can save it as “data.txt”.

Your Excel data is now saved as a pipe delimited file. You can use this file for data exchange with other applications or systems that recognize the pipe “|” as a delimiter.

For completeness, it’s worth noting that Excel allows saving files in various formats directly, including CSV, but does not directly support pipe-delimited files. Users typically change list separator settings in their system settings or use a macro/VBA script to automate the conversion to pipe-delimited format without using an external text editor. This approach, however, involves changing system-wide settings that affect how applications interpret list separators, which might not be desirable.

Exit mobile version