Excel - How to open a csv file with a different delimiter
1. Open csv file using a text editor (Notepad, Notepad++)
2. Add the following line at the beginning of the file
sep=;
Note : this example used ; as delimiter. This like will instruct excel to use ; as a delimiter for this particular file instead of globally defined delimiter
3. Save file and double click on it to open the file in excel.
1. Open csv file using a text editor (Notepad, Notepad++)
2. Add the following line at the beginning of the file
sep=;
Note : this example used ; as delimiter. This like will instruct excel to use ; as a delimiter for this particular file instead of globally defined delimiter
3. Save file and double click on it to open the file in excel.
