How to delimit data csv for data import?
If you want to delimit data in csv, open the csv file. It will look like this.
To delimit the data (separate into columns)
- Go to data
- Select the column you want to delimit the data for. (you can select only one column at a time)
- Select text to columns
- A new window will pop-up. Select the “Delimited” option and click on “Next”
- From the delimiters option select the appropriate one. For Uploading csv choose: comma (,) for English Microsoft office and semicolon (;) for French Microsoft office. In the data preview you will see how the data will look like when you select the respective delimiter. Select next.
- Column data format is general. Select finish.
Finally your CSV will look like this.