Which will be a good editor to open a csv of 2.5 gb. Notepad++ is not

you can use CSVExplorer https://www.csvexplorer.com/

or you can create a schema in SQL server and then copy the CSV to that, as SQL server database can hold millions of records.

1. CREATE DATABASE CSVDataBase
2. Object Explorer -> [Database] -> Tasks and click the “Import Flat File