Very often, our data source is stored in excel format and in a human-readable way. For example, each year has its own column and there are…