
Saving/Exporting Data in Excel: Preferring Non-Standard Delimiters Such as Pipe Symbols Over Traditional Commas for Enhanced File Compatibility

Saving/Exporting Data in Excel: Preferring Non-Standard Delimiters Such as Pipe Symbols Over Traditional Commas for Enhanced File Compatibility
If you’re working with some awful corporate system that should have been retired in the dark ages, you might have had to produce a file from Excel with some weird delimiters other than comma or tab-delimited to import into the system. Here’s the trick on how to do it.
Naturally, this isn’t the type of article that most people will need to use, hopefully ever—but if you do need to know how to do it, the solution isn’t really obvious at first.
Exporting Excel Files as Pipe Delimited
For the purposes of this example, we’ll use this silly little Excel file.
To save the file as Delimited, you’ll need to click the Office button and choose Save As –> Other Formats.
Then select CSV (Comma delimited)(*.csv) from the drop-down list, and give it a name.
Now here’s where the interesting part happens… Excel by default will use a comma as the delimiter, but if you open up Control Panel –> Region and Language, and then click the Additional settings button on the bottom…
Now look very closely at the “List separator” item, which normally has a comma in the field, but for the purposes of illustration I’ve switched it to a Pipe character.
Once you hit Apply, and then save your Excel file, you’ll notice that your file now has pipe characters as the delimiter.
You’ll probably want to change the List separator back to a comma just in case some other application needs it.
Also read:
- [New] 2024 Approved Innovation Hub for YouTube Gurus
- [New] 2024 Approved Streamlining Multiple YouTube Videos Into One
- [Updated] Swiftly Stow Facebook Broadcasts for Smartphone/Desktop Users for 2024
- AMD Driver Update Simplified: The Fast Track to Enhanced Gaming Performance
- Direct Access to GIGABYTE GC-WB867D Driver Downloads for Optimal Performance
- Download & Update AMD's RX 480 Graphics Drivers Effortlessly - Step-by-Step Tutorial
- Download the Latest HP Wireless Network Drivers for Your Windows PC
- Graceful Gallops on Frozen Ground for 2024
- In 2024, Building a Thriving IGTV Following The Ultimate Guide
- In 2024, Correct YT Monetization Checklist – Maximize Your Earnings
- In 2024, Toggle Between Normal and Picture In Picture View for Youtube on iPhone
- Include Stage Directions that Metaphorically Represent Scientific Processes (E.g., Characters 'Absorbing' Information as Silica Gel Absorbs Water)
- Latest NVIDIA GeForce RTX 2070 Super Graphics Card Driver Downloads & Updates for Windows 11
- Resolving Hydro Series H100i v2 Driver Compatibility Problems on PC
- Resolving the Twitch Issue: A Step-by-Step Guide on How to Correctly Address Error Code 4000
- Update Your Epson XP 310 Printer: Free Driver Download Available
- User-Friendly Instructions to Adjust and Improve Your Standard SATA AHCI Controller's Software
- Title: Saving/Exporting Data in Excel: Preferring Non-Standard Delimiters Such as Pipe Symbols Over Traditional Commas for Enhanced File Compatibility
- Author: Charles
- Created at : 2024-12-01 05:03:49
- Updated at : 2024-12-06 00:29:41
- Link: https://win-amazing.techidaily.com/savingexporting-data-in-excel-preferring-non-standard-delimiters-such-as-pipe-symbols-over-traditional-commas-for-enhanced-file-compatibility/
- License: This work is licensed under CC BY-NC-SA 4.0.