Explanation
CSV files are commonly used to exchange data between different applications.
Example CSV data:
OrderID,Customer,City,Product,Sales
O101,Amit,Sirsa,Keyboard,4000
O102,Neha,Hisar,Mouse,5000
O103,Rahul,Sirsa,Monitor,25500
Import Process
Go to:
Data → Get Data → From File → From Text/CSV
Excel displays a preview before loading the data.
Important Options
During import, check:
- File origin
- Delimiter
- Data type detection
- Previewed columns
For comma-separated data, the delimiter is generally:
Comma (,)
Example Result
|
OrderID |
Customer |
City |
Product |
Sales |
|
O101 |
Amit |
Sirsa |
Keyboard |
4000 |
|
O102 |
Neha |
Hisar |
Mouse |
5000 |
|
O103 |
Rahul |
Sirsa |
Monitor |
25500 |
Practice
Import a CSV sales file and load the data into a new worksheet.