What are the programs for dividing a large CSV file into small ones?

Question

Software and Internet Services

What are the programs for dividing a large CSV file into small ones?
There is a csv file with 2 million entries. You need to split it into small ones. Downloaded on the Internet. but there appear shifts in some, Cyrillic does not work in some.
What can you advise?
Amendment!!! I need exactly the application, this program will be used by the humanities)

Answer 1

split -l 1000 file_name
Will split the file into 2000 files of 1000 lines.
Ah, well then Excel.

Answer 2

split by 100000 lines
awk 'NR%100000==1{x="F"++i;}{print > x}' file

Answer 3

head | tail is our entire
example of writing lines 20-40 to a separate file:
head -n40 res.csv | tail -n20 > res20_40.csv