Import your CSV data into Microsoft Excel

From Sohowiki
Revision as of 08:22, 12 August 2008 by Joe Lain (Talk | contribs)
(diff) ←Older revision | view current revision (diff) | Newer revision→ (diff)
Jump to: navigation, search

-Open Excel to a blank worksheet -Select DATA -> GET EXTERNAL DATA -> IMPORT TEXT FILE... Select the name of the CSV file you downloaded from the system. (Note: You may have to set windows to look for CSV files) Follow the on-screen wizard and set your "delimiter" to a "Semi-Colon" (;) Once import is complete, you can save your data as an XLS file or some other format for your use.

Personal tools