Uploading CSV files on Macbook?

Hello, I’d like to import bank transactions to LibreOffice to help with budgeting, and then keep the CSV extension to export to YNAB budget software. I tried downloading a CSV file from my bank on my Macbook and it downloaded successfully, but it opened automatically in Numbers, and I couldn’t find a way to open it in LibreOffice. I tried searching for the document, tried clicking on “Open”… all the standard stuff. Nothing worked. Any advice?

From Calc … →Rightclick on Sheettab→→Insert Sheet … [x]from File …
(please set carefully possible Import-Options especially about the DataTypes in Columns-Preview)