Feed import many fields into single content type
You are in the correct path, the Feeds module will allow you to import into the a content type data from a CSV file. You should install the feeds module first, create the content type after and last map the columns of data on your CSV file to the content type fields.

If you want to manipulate the data first before creating the node the Feeds Tamper module will help you do that.

Note: On the feed module page that are a couple of links to help you with the setup. Also Mustard Seed Media released a new podcast about the feed module as well.