How to import Stock items in Tally from Excel

How to import Stock items in Tally from Excel

Are you seeking an efficient method to import stock items into Tally from Excel? Our solution simplifies this process by generating Tally XML files directly from Excel data. With our online portal utility, you can effortlessly convert Excel data into Tally XML format, facilitating the importation of master stock items and other data types into Tally.


Step-by-step guide to import Stock items in Tally from Excel:

    1. Visit Our Website: Begin by visiting our website at
    2. Download Masters Stock Item Template: Download the Masters Stock Item template provided on our website. This template is specifically designed to capture stock item data for importation into Tally.
    3. Fill in the Data: Populate the Masters Stock Item template with the relevant stock item data in the Excel format. Ensure all required fields are filled accurately before proceeding.
    4. Upload to Our Portal: Once data entry is complete, upload the Excel file to our online portal. Our utility will automatically convert the Excel data into Tally XML format.
    5. Generate XML File: Click the “Generate XML” button on our portal to initiate the conversion process. Our tool will swiftly generate the Tally XML file containing your stock item data.
    6. Download XML File: After the XML file is generated, download it to your device. This file is ready for importation into Tally.
    7. Import into Tally: Open Tally and navigate to the appropriate module for stock item entry. Select the option to import XML files and choose the downloaded XML file containing your stock item data.
    8. Completion: Congratulations! Your stock item data is now successfully imported into Tally, ensuring accurate and efficient management of your inventory.


Our Excel to Tally XML converter migration tool offers a seamless solution for businesses looking to streamline their stock item importation process. Experience the convenience and efficiency of our tool today by following these simple steps. Simplify your inventory management tasks and optimize your workflow with ease!

Leave a Reply

Your email address will not be published. Required fields are marked *