In Tally ERP 9, the voucher can be imported from Excel by following these steps: Open the file in excel. Select all cells and copy them to clipboard. Switch to Tally and go to Menu > Data Entry > Import > Import From Excel File Choose file and paste data in the pop up window.