We write this article to help those who are looking for a way to convert Excel spreadsheets to tab delimited CSV files.
How can I save an Excel spreadsheet as a tab delimited CSV file?
“Hi there, I would like to save an Excel spreadsheet as a tab delimited CSV file on my Mac. Unfortunatly, I could’t figure out a way to do that. Is there a way I can get a tab delimited CSV file? I would really appreciate any help. Thanks in advance.”
With Gmagon XLS2csv installed, it won’t be a problem to create tab delimited CSV files from Excel spreadsheets. This Mac app allows you to customize delimiters in CSV as comma, semicolon, space, tab, etc. Check a guide on how to do this in detail.
Follow these steps:
Step 1: Install and run Gmagon XLS2csv on your Mac, and click “Import File” to load Excel (.xls/.xlsx) files that you want to convert. This Mac Excel to CSV converter supports batch conversion, so you can load multiple XLS/XLSX files to do conversion at a time.
Step 2: Go to Export Configuration Window
By default, this app generates CSV files with comma delimiters. If you’d like to specify Tab as delimiter, simply go to Export Configuration Window to do this.
Step 3: Set output path for exported CSV files
Step 4: Click “Convert all” button to start. Once the conversion is complete, you can get the exported .csv files in output folder.
Hope this article helps those who are in search of a way to convert Excel spreadsheets to tab delimited CSV on a Mac.