Archive

Archive for the ‘Excel’ Category

Properly import CSV files into Excel

March 1, 2010 Leave a comment

Some users have been having trouble importing CSV files into Excel.  If you are experiencing any difficulties importing info Excel (such as all data in one column), this may help you.  Although this was written to support those using Excel 2007, it applies to all versions (of course, the steps might be slightly different). 

  1. In Excel go to the “Data” tab and click “From Text”
  2. Select the .CSV file that was emailed to you
  3. Check the “Delimited” radio button, and click Next
  4. Check the “Comma” delimiter, and click Finish
  5. Excel will then ask you what cell to start adding the records, so just select the cell you would like to use.
Advertisements
Categories: Excel, Export