Converting a Credentialset into CSV details for importing into a Database

Question

I have a lot of files containing credentials in the format of

email@email.com:password
email2@email.com:password2

my desired Outcome would be a CSV file so I am able to load the data into a Database

Email	Password	TopLevelDomain	SDL
Email@email.com	password	com	email
email2@email.com	password2	com	email

So the columns in that db are Email, Password, the top-level domain and the domain itself.

Using the MySQL Workbench import feature the data couldn't be imported in the current form, which is why im asking for help here. Thanks in advance :)