I press "View" tab, then press the arrow below icon "Macros" on the band and chose "Record Macros." 

I fill the first field with the name of the Macros to use it later for other files. The second field is reserved for the hot key to run this Macros inside of Excel. I put the cursor to the box and press Shift+G. This assigns the hot key to the combination Ctrl+Shift+G. You should check if this combination is used in your Excel or not. I leave "Personal Macros Workbook" to be able to run this macros from Excel opened by clicking any csv file. The fourth field is used to describe what this macros was designed for. To start the recording just press "Ok" button.

I press the "Ok" button to confirm the operation of moving all rows one position up. In the list obtained first rows are occupied by teachers. It is not reasonable to delete these rows now. We can always delete them later when the xlsx file will be composed.

We edit the squares in the uploading window to get the Check mark in front of "Comma" and nothing in other squares. I press "Next".

To see the contents of all cells we use the "Auto Column Width" option in Excel.  I select the first column, press the "Home" tab, press the "Format" icon and press the arrow below the above icon:

I repeat this for columns B and C:

I select the whole column B up to cell B:150, press the right button of the mouse and press "Copy". Then I paste all the data of column B to column D

I press "Next".

The control window in black shows that the part of the e-mail will move to column B. We correct this in the field of destination and replace B with A as shown above. After that I press the button "Finish".

The following uploading window appears:

In the field indicated by the red arrow I add six zeros to obtain 12 zeros. It is exactly the number of digits used in the e-mail address at "@". I press "Ok". 

I fix the width of A the same way as I did before. Now, I select cells C2:C150, press "Data" and then "Text to Columns":

I put the Check mark at "Space", remove it at "Others" and remove the symbol "@".

I replace C with B as shown above and press "Finish".

 I change the headers of the columns. Traditionally, one should select the header and edit it in the field "f_x" as shown above.

I select the cells from E2 to T150. Click with the right button of the mouse on the selected area and chose "More Number Formats".

I insert an Excel Formula at Q2. It is useful to have formulas at Q2, R2, T2. The reason is that when a table is transferred into Microsoft Lists the formulas remain in the xlsx table. In Microsoft Lists there are their own formulas. They will be in the columns ATT1, ATT2 and GT. One can save final grades in this very file. Then the formulas which I inset now will calculate the results. I copy the formula by placing mouse at Q2 with the right mouse click, then highlite the cells Q2:Q150  and insert the formula copied in Q2 to the column at any place. The formulas will appear at all 149 rows of column Q, I repeat this for every three columns indicated above.

 I obtained the required table. I save it with the .xlsx extension.

Now I can stop recording.

I close the file.

Converting xlsx files into Microsoft Lists

In the created tab "Lists," I click the icon "Create the list."

Converting xlsx files into Microsoft Lists

I press the button "Send a file" (from this device).

Converting xlsx files into Microsoft Lists

I give the name and description to this new list. I choose the icon for this list in the last row and press "OK."

Converting xlsx files into Microsoft Lists

To reformat the look of the list, I press the check mark at the right top of the window and choose "Format the current view."

Converting xlsx files into Microsoft Lists

I click on "Change the style of rows."

Converting xlsx files into Microsoft Lists

I change the font size and make it bold.

Converting xlsx files into Microsoft Lists

I press "Save" for odd and even rows.

Converting xlsx files into Microsoft Lists

I open the list in the SharePoint corresponding to the Team.

Converting xlsx files into Microsoft Lists

I press the check mark to the right of the column name. In this example it is "Email."

Converting xlsx files into Microsoft Lists

In this window I can hide or show columns and move them up and down with the mouse.

Converting xlsx files into Microsoft Lists

I mark "Calculated" line.

Converting xlsx files into Microsoft Lists

I mark "Number" and change "Automatic" to 2 decimal places.

Converting xlsx files into Microsoft Lists

To complete the configuration, I press "Ok."

Converting xlsx files into Microsoft Lists

Step 4. We change students permissions to allow read but forbid write. All operations should be made in SharePoint List! By default, students can edit any list in the SharePoint. To correct this, I press the "Settings" icon above.

Converting xlsx files into Microsoft Lists

I press "Advanced settings."

Converting xlsx files into Microsoft Lists

The list can be exported back to Excel as shown above.

.

How to Create Grade Books so that students can see only their own grades?

I created a grading list in the Grade Book SharePoint, which in my case is Algebra 1 [копия].

I move mouse to the very left part of the line of the student I added and put Check mark in the circle (see the picture below).

It is important first press the first line to remove the editing permission.

The e-mail address of each student is present in the list. I start typing it in the first line and chose the required student from the drop-down menu. Then I press "Send". The student receives the link to this very row to the mailbox. I repeat these actions for every student. However, it is unrealistic to expect that students will use this very link to check their grades. 

Do I press "Save" and the required Grade Book in the main class is ready for students. The following slides show what any individual student will see if she/he opens the "Grade Book" tab in the main class: