How to load historic station data into Microsoft Excel
- Select all the data in the file (using the browser menu, Edit > Select All, then Edit > Copy)
- Open a new worksheet in Excel. Select cell A1, then Edit > Paste
The file has now been pasted into Excel, but the data from row 6 down now need to be placed into separate columns.
- Select the data in column A from row 6 (starting yyyy) to the last row.
- Data > Text to Columns.
This opens the 'Text to columns wizard'. Select Fixed width > Next
- Add break lines as required to separate *, #, and 'Provisional' text at the bottom of the data. Use the scroll bar as necessary to view the bottom of the data (see example below) > Next
- Leave the column data format as General for all columns > Finish
- The data are now separated into individual columns. Save the file as an Excel spreadsheet.
Last updated: Apr 15, 2016 10:52 AM