Importing Nodes to D7 with all custom fields
The Feeds module (sucessor to the FeedAPI module) has that functionality built in.

For your needs specifically it offers:


Import or aggregate CSV files
Create nodes, users, taxonomy terms or simple database records from import
Granular mapping of input elements to Drupal content elements