How to use gsplit to split large files into smaller parts to allow to read it.
Find GSplit application here https://www.gdgsoft.com/
I used GSplit to split large CSV files (like ~4GB in size) into smaller parts to let Excel read it with no errors.
Final product was small CSV files from large CSV split into parts respecting rows, meaning the split happen only at end of row so we do not lose a single row.
Zip includes PDF on how to use, a batch split file and 2 profiles used inside GSplit application.