Frequently Asked Questions

Main > Grades
 

How do I import grades from Microsoft® Excel and other spreadsheets into my Grades page?


Print
Save to list
E-mail
Subscribe
Created 2007-12-11
Modified 2009-10-05
Views 12527

Importing Grade Records from Microsoft® Excel and other Spreadsheets

  • Many teachers have Imported grades from Microsoft® Excel into their TeacherWeb® Grades page.

    To do this, simply Select and Copy the columns you want to post from the Excel spreadsheet and then Paste them into the Update Grades page's input box as described here. Just remember that the first column should be the Student Name (e.g., "Jones, Robert") and the 2nd column should be the Student ID, followed by the Grades/Info columns.

    Alternatively, you can save your grade data in the Tab-delimited (.txt) or Comma-separated values (.csv) format and then import the file to your Update Grades page as described here.

  • Also, you can optionally Copy and Paste a row of column header info with your information - just remember to place a check in the "First Row in File contains important header information" box after selecting "I want to manually enter my grades" and then "Copy & Paste" under "How would you like to load your Grades information".




Related Articles
How do I use the Grades page once I've added it? How do I enter grades into my Grades page? How do I import grades from my gradebook program?
Update Grades Instructions: If you are Importing Grades from other programs see below If you are creating your own grades info,...
How do I import grades from other gradebook programs not listed in the FAQ?
Importing Grades from other Gradebook programs not listed in the FAQ There are a lot of gradebook programs! TeacherWeb® will work with any...
How do I import grades from MicroGrade into my Grades page?
Importing Grade Records from MicroGrade Open your grades file and select "Export" > "General..." from the File Menu. ...