Splitting data into multiple Excel files

Help me) How can I split the data into 2 Xel files. For example, I have 5 million lines, I want 1 file to be uploaded with 2 million lines, and the other with 3 million lines. How to do it?