Importing Caste or Income Details Using Google Sheets 'IMPORTHTML' Function

Copy

Highlights:

For Caste Certificate, the formula imports Caste, Name, Relation, Father/Husband, Village/Ward, Hobli, Taluk, District & Pin Code respectively.

For Income Certificate, the formula imports Annual Income only if Income Certificate is not expired. Else, this formula displays Expired details.

Explanation:

     If you are a Google Sheets user and deal with scrutinize of Caste & Income Certificates frequently, this formula uses Google Sheets "IMPORTDATA" function to import data from a website. It fetches the tsv data from the URL "http://lidkar.esy.es/caste_income/nkcv.php?rdNumber=" concatenated with the value in cell "A1" and continuing with tsv output &"&data.tsv . The formula imports Highlighted details.

     Please make sure to add RD number in cell "A1" or replace "A1" with the appropriate cell reference if you intend to use it with a different cell.

     Kindly note: Currently Microsoft Excel doesn't support the "IMPORTHTML" function. Alternatively, you can use VBA (Visual Basic for Applications) macros in Excel to achieve the same.

     For any support, please feel free to drop me an email.