Import your CSV data into Microsoft Excel
From Sohowiki
(Difference between revisions)
Line 1: | Line 1: | ||
− | + | 1. Open Excel to a blank worksheet | |
− | + | ||
− | Select the name of the CSV file you downloaded from the system. (Note: You may have to set windows to look for CSV files) | + | 2. Select DATA -> GET EXTERNAL DATA -> IMPORT TEXT FILE... |
− | 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. | + | 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. |
Revision as of 08:23, 12 August 2008
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.