Create A CSV File Using Microsoft Excel:
To create a CSV file using Microsoft Excel, launch Excel and then open the file you want to save in CSV format.
For example, below is the data contained in our sample Excel worksheet:
Item Name |
Cost-Rs |
Quantity |
Profit |
Keyboard |
480 |
12 |
1152 |
|
5200 |
10 |
10400 |
|
200 |
50 |
2000 |
|
|
Total Prof |
13552 |
Item Name, Cost-Rs, Quantity, Profit
Keyboard,480, 12,1152 ,
Monitor, 5200, 10, 10400
Mouse,200,50,2000
Total Profit = 13552