What can open a large csv file?

Question

csv

Hello. Prompt a normal program (or online service) to open a large file (about 7 GB) csv. I want to open not the first 100 lines, but the whole file

Answer 1

1) LibreOffice + increase the swap partition (file).
2) There is a program for perverts - GSplit
3) Linux console utilities.
4) Drive csv into the database.
PS: Just keep in mind that an adequate person does not need to open (read) the entire file. There are billions of lines!

Answer 2

The fastest are console utilities, from the world of linux, awk, cut, grep, ... you can parse your file even on a calculator (you can install it separately or take a ready-made one using Microsoft's wsl or cygwin).
Any other solution will be much slower and require more resources.
example, if you need lines (csv - text format, one line per entry) that contain the substring you need, then use grep:

grep "искомая строка в кодировке файла" имя_файла.csv > новый_файл.csv

almost certainly a substring or a regular expression (key -e) will be enough for you
ps , then create indexes (I advise doing such operations on a ram disk), but then almost any filtering