Data backup in excel

can anybody tell me how to backup my transaction data and open in excel

You cannot back up Manager in Excel. For backup, see the Guide at http://guides.manager.io/businesses. Only individual Manager screens (such as an account register) can be exported as TSV files, which can be imported into Excel.