Import 30 txt files into excel at different sheet?

Question

I have a lot of txt files which i want to import into an excel file, in different sheet. Are there any software has this function? Are there any method can do this?

I don't want to import it one by one lei/ . \. I want to import all txt files in one time.

and the data inside is separated with ","

Answer 1

Bite the bullet and import each text file manually to it's own sheet.

TIP: Save after each import, and repeat until finished.

You might also be able to record a Macro, but it's a little geeky.