How to export the drill files correctly?

Please select EXCELLON instead of Gerber_RS274X when choosing the Device for Drill Data, this will help you eliminate the size problem.

If you use Altium, .TXT & .DRL are both acceptable.