OK, you've got several csv  files.
do you know the names? or are they variable?
variable number of files?
You said:
text1.csv -to-> text2.xls
did you mean:
text1.csv -to-> text1.xls
text2.csv -to-> text2.xls

??
You said that the .xls files are "templates"
and you want to "import" the contents of the csv file.

Can you describe, step by step EXACTLY what you would
do if you were doing this manually?

As in:
Open test1.xls
select sheet  "data"
Open test1.csv
select all cells
return to test1.xls
paste-special values into sheet "data"
save .xls file
close .xls file
close .csv file

rinse
repeat

Or is the "template" something more than just formatting?

It's a simple matter to have the excel  macro find all the .csv
files in a folder and open them along with a corresponding .xls file.
but I can't help  you do what you want unless you can tell me what that is...