Skip to end of metadata
Go to start of metadata

How can I use D2L grades in conjunction with Excel?

D2L's grades tool is strict about the structure and format of the data it will accept for re-import. In order round trip data from D2L to Excel and back please pay careful attention to the procedure below.

  1. Within all the D2L grades tool, create all your grade items, even those you'll be filling in using Excel.
  2. Export grades from D2L. In this export, do not include any calculated items.
  3. Open the exported grades in Excel.
  4. Use Excel to fill in grade values.
    • Do not add any columns or rows.
    • Do not sort or re-order the columns or rows.
  5. Save the file from Excel to a CSV (Comma Separated Values) file.
  6. Return to grades in D2L and import the CSV file.
    • Do not select the check box for additional fields.
  7. Follow the prompts through the import process.

Help Desk

Help Desk Contact Info

Location: Boyer Building

Phone: 717-871-7777


Classroom Hotline: 717-871-7820

Call Center

  • Fall/Spring Semesters:
    • M-Th 7:00am - 7:00pm EST
    • F 7:00am - 5:00pm EST
  • Summer Sessions:
    • M-F 7:00am - 5:00pm EST

Walk-in TAC

Technical Assistance Center - access via W. Frederick Street side of building

  • Fall/Spring Semesters:
    • M-Th 8:00 am - 7:00pm, F 8:00am - 5:00pm EST
  • Winter/Summer Sessions:
    • M-F 8:00am - 5:00pm EST

After Hours D2L Help

Email and Live Chat

Search D2L Resources