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.
