how to load data from data source and store it in servicenow custom table

[Are Kaveri]

I have below requirement.

we have manual data coming for a table .

every year we receive data in form of excel data source .

after 2 continuous years  we need to validate the points obtained for student.

how to validate points from past two years on the table and load data on the table as year and points are different for each student.

the data is as follows

excel1

name	Title	Points Obtained	year
Test	IT	3	2022
Test1	Software	4	2022
Test2	Hardware	3	2022

excel2

name	Title	Points Obtained	year
Test	IT	5	2023
Test1	Software	3	2023
Test2	Hardware	4	2023

[Are Kaveri]

@AshishKM  I know how to load data from excel to target table.

Here what issue i am facing is"

So we are receiving data for Student No: 101 

The Data we are receiving is past 3 years data 

In this past 3 years data we want only the latest two year data for reviewing the Rating.

Example:

I want to know as i mentioned below post that 2021 and 2022 data

Here I want average rating for 2021 and 2022 

How to calculate the average of recent 2 years?

and how to validate whether the data is recent 2 year?

[AshishKM]

For Average 

For each row , apply the addition and divide by 2 , result will be the average which you need.

For Two year data validation

You can check the "Year" column value for year check

[Are Kaveri]

@AshishKM  

How to check most recent 2 years data ?