Just naming a text file to .csv does not make it a CSV file. The text needs to be formatted in a very specific way. You can read about CSV files
here.
If you have a properly formatted CSV file, it can be imported directly into the Address Book app. It sounds like your CSV file is not formatted correctly.