Import the file to the app.
Use the StringFromFile form the community commons module see https://docs.mendix.com/appstore/modules/community-commons-function-library#4-function-list
Now you have the data as a string and can parse the data with find and substring functions searching for what you need from the string and create records for this.
Alertnatively build the parser in java and provide the file as input to the parser.