Import your CSV data into Microsoft Excel

From Sohowiki
Revision as of 08:23, 12 August 2008 by Joe Lain (Talk | contribs)
Jump to: navigation, search

1. Open Excel to a blank worksheet

2. Select DATA -> GET EXTERNAL DATA -> IMPORT TEXT FILE...

3. Select the name of the CSV file you downloaded from the system. (Note: You may have to set windows to look for CSV files)

4. Follow the on-screen wizard and set your "delimiter" to a "Semi-Colon" (;)

5. Once import is complete, you can save your data as an XLS file or some other format for your use.

Personal tools