Automate CSV Row Organization with File Name Integration

Hi everyone, is it somehow possible to organise rows given on the import file (name)? I am importing from dozens of files and having to do add a column manually is a lot of work - ideally I would like the file name of the respective csv to be saved into one column. Is there any way to achieve this in a (semi-)automated fashion?