Edit CSV with Excel
It is very difficult to edit csv file using simple text editor because of data is simple text format without headings .Microsoft Excel is very easy to use edit or create a new csv file . To Edit it using excel open microsoft excel .
Import CSV Using Text Data
Click on the data of top pane . After that click on From Text tab to import csv in excel .
Text import wizard is open . Select “Delimited” and click next . After that select any value from “Delimiters” ..
If values are separated by commas in csv file then select comma in Delimiters , to import values in excel rows and columns .And click on Next button .
If values are separated by tab in file the select “Tab” in Delimiters . As same if value are separated with semicolon then select Semicolon.
Import values and Edit
Select the cell in which you want to add the values of csv and click ok .
Now csv values are imported in excel rows and columns. You can easily edit these values . After edit values click on save as tab in file menu .
Select file type is csv file (comma separated ) and save.