Manually entering FORM 26AS data from PDFs or Notepad into Excel can be time-consuming and prone to errors. To simplify this process, we have developed the FORM 26AS Upload in Excel Utility V.1—a powerful tool designed to help professionals seamlessly upload FORM 26AS data from the Indian Income Tax website into an Excel file with accuracy and efficiency.
What Makes FORM 26AS Upload Utility Essential?
1. Saves Time: Eliminates the need for manual data entry.
2. Error-Free Data Upload: Reduces the risk of mistakes while transferring data.
3. Easy to Use: Simple steps to extract and organize your FORM 26AS data.
4. Automated Processing: Quickly loads the entire data set from FORM 26AS into Excel.
How to Use the Utility?
1. Open the Excel file and go to the“Form26AS”sheet.
2. Click the “Upload” button.
3. Select the Text (.txt) file downloaded from the Income Tax Portal (https://eportal.incometax.gov.in/iec/foservices/#/login)
4. Click “Open” to load the data.
5. The extracted data will be placed in the sheet named “FORM26AS”, starting from cell A4.
Utility Download Link is given below.
If you have any feedback, suggestions are welcome..
Thanks Mr. Madhan. Please also provide such utility for AIS