How to get Dividend, interest income from Form26AS

1. Download FORM26AS from incometax site or bank site in txt format.
2. Use this command to get entries: grep ^[0-9] AXXXX848XX-2024.txt  >a.txt 
3. Use this command to get csv file: 

         awk -F"^" '/^[0-9]/ {printf("%d, \"%s\", %s, %0.2f, %0.2f, %0.2f\n", $1, $2, $3, $8, $9, $10) } ' a.txt

 

    4. You may need to delete some irrelevant rows.