How do I import and populate a sheet with CSV in Excel?

Answer by  Kantar (20)

Start Excel 2007. Choose Data tab and click "From Text" icon. In "Import" window locate csv file and press "Import". That will starts the wizard. Choose "Delimited" and press "Next". Choose correct delimiter (comma or semicolon) and press "Next". Finally, choose correct format of each column and press "Finish".

Answer by  faithfulservant (37)

Simply click on the "Open" button and browse to the .csv file. Excel will either open the file directly, using the commas as delimiters to separate the data into columns or it will start the the "Text to columns" wizard. If you get the wizard, select the option which allows you to use a comma as a delimiter.

Answer by  sc1234 (1319)

Select the CSV file on your computer and right click on it. A menu will open up and select "Open With" and select Excel. This should do it.

Answer by  abans (43)

First, save the file with the extension. csv on your hard drive or other storage. Then open the file by clicking the Office button, or using the CTRL-O combination. This will open a dialog box where you can select the file to import. For existing sheet, click "data", then in the "External data" section, click "From Text" to import.

Answer by  gigo (1706)

Go to format | data in columns. Then choose a separator character, that defines which character in the csv should depart the columns. Click on finish.

Answer by  aanderson (42)

In Excel select File from the menu at the top of the window. Next select Open. In the Open dialog window select the drop down box at the bottom labeled Files of Type and select Text Files. Finally select and open your file.

Answer by  gigo (1706)

Double click on the csv file. Excel loads the data into a single column. Go to data | text in columns and choose the comma as separator.