How can the data in Excel sheets to be transformed or used for a software or database which we are going to develop?

depending on the tool you are using to develop there are easy techniques and functions to import your data from excel to your new database.