Reformatting grades in a csv file for Canvas import

The first step is to open your csv file containing scores in a spreadsheet editor, such as LibreOffice Calc or Microsoft Excel.

A csv file containing several
assignments. — A csv file containing several assignments.

We must combine the "Last name" and "First name" fields as follows:
1. Select a cell in the "Last name" column.
2. In LibreOffice Calc, select Sheet > Insert Columns > Columns Left.
  In Microsoft Excel, select Home > Insert > Insert Sheet Columns.
  
  Empty column inserted.
3. In cell C8, enter the formula =CONCATENATE(D8,", ",E8).
  
  The name in row 8 has been combined.
4. Select cell C8 and all the cells below it, all the way down to the last student row.
  
  Cells in column C are selected.
5. In LibreOffice Calc, select Data > Fill Cells > Down.
  In Microsoft Excel, select Home > Fill > Down.
  
  All names have been combined.
Next we must save our combined names as text, not formulas.
1. Select all the combined names.
  
  All combined names are selected.
2. In LibreOffice Calc, select Edit > Cut.
  In Microsoft Excel, select Home > Cut.
  
  Combined names have been cut to the clipboard.
3. In LibreOffice Calc, select Edit > Paste Special. Then uncheck "Paste all" and check only "Text".
  
  The "paste special" window.
  
  In Microsoft Excel, select Home > Paste > Paste Values. Then select "Values".
4. Next we must delete all the extraneous rows and columns.
  1. Keep the rows that contain scores themselves, the row with the name of the assignments, and the row with the number of points possible in each assignment. Delete all other rows.
    - To delete a row in LibreOffice Calc:
      1. Click on the row number.
      2. Select Sheet > Delete Rows.
    - To delete a row in Microsoft Excel:
      1. Click on the row number.
      2. Select Home > Insert > Delete Sheet Rows.
    Extraneous rows removed.
  2. Keep the columns that contain scores themselves, and the column with the combined names. Delete all other columns. Deleting columns is similar to deleting rows.
    
    Extraneous columns removed.
5. Next, insert two empty columns between the name column and the score columns.
  
  Two empty columns inserted.
6. Now put column headings in the first row:
  - In cell A1, enter "Student".
  - In cell B1, enter "ID".
  - In cell C1, enter "Section".
  - In cell A2, enter "Points Possible".
  Ready to upload!
Now save your file as a csv. Import it into the Canvas gradebook and follow the directions onscreen.