[masedan]

Here are some command you can use on Linux to search in your CSV:

head -10 /path/to/file.csv

 
Allows your to check the first 10 lines of your CSV, you can check to more or less lines depending on your needs

grep -iFE "keyword" /path/to/file.csv

 
Search for specific keyword in a file, it will show you the lines containing your keyword and highlight it

grep -iFER "keyword" /path/to/directory/

 
Same as previously but to do it in a directory containing multiple files

These commands will help you to search for specific things quickly (may take few minutes if you have 10s of millions of entries), and wont use as much resource as if you open the full file.

[redmonkeytechie]

You can use moderncsv or Emeditor . Both performs well in handling huge csv files

[boomered]

you can import a csv file with "\copy" easily into a postgre db

[liliteam]

is emeditor available for linux?

[ahmadwaqar]

I personally use emeditor, its good amd it works nicely. Though it will still take its time in opening a large file like the one you mentioned.

[forrro]

ultralEdit is a good software, u can try

[Xanthos]

Use LargeFileViewer, its a good option

[moon_80]

split -l 1000 large.csv small_csv_

[BSEA]

Less UX but python associated with a Jupyter Notebook is great (Anaconda environment). Use Pandas Library

[johnuqwer11]

You need to use Linux command line tools, easiest way. Windows doesn't offer much in the way of that.