Many times it is needed to save excel sheet as Comma Separated Value (CSV) text file to import in the MySql database. Usually when you save file as CSV file the fields are separated by “,”; but sometimes this causes problems in field separation if the content also contains comma.
To define a unique field for your CSV file field separator in your Windows Vista/XP systems, follow the following steps:
- Open control panel.
- Open “Regional and Language Options”.
- In “Formats” tab click “Customize This format”.
- Then in the list separator text box enter the desired field separator and click “ok”.
- Click “Ok”.
Now when you save your excel file as CSV, the new field separators will be used.