4. Press CTRL-C (for copy to clipboard). 5. Open anew worksheet in Excel. 6. From the Excel menu bar, select Data > Get External Data > Import Text. 7. When the dialog box appears asking for the file, click in the Filename field, and press CTRL-V (for paste from clipboard). The URL should now appear in the Filename field. 8. Click the Import button. You maybe prompted again for your station username and password again. If so, enter these (sign on again) and click the Import button once more. 9. Excel’s Text Import Wizard starts next. You may accept all defaults, but be sure to select Comma for Delimiters on the second screen of the wizard (as shown below). 10. When finished with the wizard, the log data should appear in your worksheet.
Share with your friends: |