- Download FORM26AS from incometax site or bank site in txt format.
- Use this command to get entries: grep ^[0-9] AXXXX848XX-2024.txt >a.txt
- 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.