Cleveland Heights - University Heights City School District
Assessment Resources
Untitled Document

Using web page tables in Excel. (This includes your class lists from Webtools)

  1. Copy the table from web page. To select the entire table, click at the start of the first cell of the table, hold down the shift key and click on the last cell. Then choose copy from the edit menu (or ctrl-C).
  2. Paste the table into the first cell of a new spreadsheet.
  3. Select the columns of the table you want to use from this table and choose Copy from the edit menu.
  4. Go to a new worksheet (or spreadsheet) and click on the first cell. Choose Paste Special from the edit menu and then choose Values Only to paste.
  5. To import into a program such as Grade Machine that accepts text files, you can save the worksheet/spreadsheet and a tab delimited file.