Batch imports

Hi, I would like to import batch journals for monthly depreciation for example, so I don’t have to laboriously go into each asset and set it up every month. Does anyone here know how to do this please, and also whether it is possible to set up a journal template to batch import from Excel? Thanks for your help.