Numbers has it's issues as well. I have to open .csv files dozens if not hundreds of times a day - always the same format. Numbers will not allow me to default to freezing the first/header column or _not_ show the formatting sidebar on open. I have to set the freeze header option and close the sidebar every time.
At this point, I've started using IDE extensions when I just need to view/filter
If you’re doing it often enough, you might benefit from using AppleScript to automate opening it in an app and changing setting . Not ideal, but it’ll make it a lot less annoying.
At this point, I've started using IDE extensions when I just need to view/filter