Help

  1. On the web page click the link to the data table.
  2. Depending on how your browser is set up, one of two things is going to happen. The browser may recognize the file type and will launch Excel (if it is not open already) and load the transferred file into Excel and you are basically done. The alternative is that the browser will ask you to save the file, because it cannot recognize the file type.
  3. Save the file in the sub-directory that you have created for this class.
  4. Launch Excel and open the file. If you do not see the file in the Excel Open dialogue, change the Type of File at the bottom of the Open window to All Files. Highlight the file name and hit the Open button.
  5. The Text Import Wizard will open. Typically your data files will be delimeted by tabs (.tsv files) or commas (.csv files). Select the delimited option and hit the Finish button.
  6. If the above results in a weird looking spreadsheet with improper alligned columns etc. open the file again and instead of hitting the Finish button, use the Next button that will guide you through several options how to interpret the file.
  7. Make sure that you save the file as a Microsoft Workbook. In order to do this go to the File menu, select Save as, pick an appropriate file name that describes the content of the file and select Microsoft Workbook under the option Save as type. If you do not change the type to workbook, any formulas you may have entered or any charts you may have created will be lost, because the file will be saved in its original format, which is typically text.