Steps to load csv data with new line characters in Excel
- Open Excel and go to Data tab.
- You can find “From Text/CSV” option to import csv data file as below. Please click on this option.
- Select the csv file to load and import.
- In the import wizard, specify file origin, delimiter and data type detection parameters. Note: Delimiter should be comma
- Then hit on “Edit” button.
- In Query Editor wizard, click on “Use First Row as Headers” option.
- You need to hit on “Close & Load” button to load the data.
