SHARE

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

From Text In Data Tab
From Text In Data Tab

Click on the data of top pane . After that click on From Text tab to import csv in excel .

Text import wizard for csv file
Text import wizard for csv file

Text Wizard

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.

select delimiters
select delimiters

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.