This article aims to explain how to separate Excel files with delimiters in CSV files. It provides a fast detection of a character separated text file, and returns it ready to use in a CSV parser. This may be useful to the vulnerable -and often ignored- population of programmers who need to process automatically CSV files from different sources.

The default set of candidates contains the following characters: “,” “.” “tab” “space”

The only required parameter is the CSV file path. Optionally, the user can specify characters to be excluded or included in the list of candidates.


How to get Excel files to interpret the separator in CSV files?

Fortunately, I have found the XLS2csv, which aims to convert XLS/XLSX files to CSV format, you can choose the any separator as you want.


Step 1: Import your Excel file or a batch of files into this converter by clicking.



Step 2: Set your output directory to put your output in the right file.



Step 3: If you want to preview the convert effects, you can see it clearly



Step 4: In the Preview interface, there are “Sheet” and “Others” options for you, here is the sheet select setting:



Step 5: Clicking “Separator”, you can easily find the separator, then you can feel free to choose here.



Step 6: The final step is to click the convert button, you can choose to convert one file at once or convert all files at one go.



Hopefully the above has given you an insight into the wonderful world of XLS2csv. Now download it and give it a try.



Also read
Mac batch convert XLS to CSV
How to convert a .xlsx file to .csv on Mac?
How to create border radius CSS code on Mac?
Convert XLS to CSV on Mac without Excel installed
Can I batch convert XLS/XLSX to CSV in Mac?