Hi,
I Myself Anulekha. I worked as an Trademark Lawyer for 1.8 years. I have worked and dealt mainly on registration of trademarks. I know how to check the status of the trademark applications.
To get the application status of a trademark you need to go to the government website of the IP India and put the application number and type the captcha and check the status of the application. In my previous firm, i used to do the same for sending the monthly stsus of the trademark application to the clients.
Also, I have gone through your google sheet. I ill go through the each application and will send you the status of each application thoroughly like - Application Name, date of application, filed on, used since, image of the mark, proprietor name, examination report, date of examination reply filed on, journal number, Opposition, evidence 45, 46, 47, Opposition hearing scheduled on, trademark certificate.
If you could contact me, i will send you a sample of a trademark application status for better understanding. Looking forward to hear from you.
Kind Regards,
Anulekha.