How to work with CSV file with 11KK lines?

Question

macOS

Greetings.
There is a CSV file with 11KK lines. I would like to work with it as in a spreadsheet editor, but oppenoffice and msoffice also have limits on the number of lines. I would like some alternative software for macOS, but I can’t find anything. I would be grateful for tips on cool software and recommendations.
So far, it only comes to mind to drive the whole thing into MySQL and work with the data through some kind of client.

Answer 1

the only thing that comes to mind is to drive the whole thing into MySQL and work with the data through some kind of client

the most sensible decision: there is no point in driving all the millions of records into the RAM at once.