Question

how to fetch data from excel which has some 100 data or csv file and use that bulk data in smart contract and validate

Comments

There's a similar post here: https://www.edureka.co/community/43825/can-import-excel-files-into-contract-record-the-transaction

Answer 1

You can use the Oracle functionality for this. Oracle is a new feature that allows you to connect your Blockchain to the outside world.

Answer 2

You can not directly import an excel/csv file in your smart contracts but you have a few workarounds:

Convert the data in the csv file into JSON file and use the JSON format in Smart Contracts. (Refer: https://www.blockchain.com/de/api/blockchain_api)

Process the data in the csv file using client-side script like Javascript and then send this processed data to smart contract.
Use Oraclize