You need to follow the quite clear on-screen menus of node import - here is a summary from a life example:
- http://www.example.com/en/admin/content/node_import/add - Next
- http://www.example.com/en/admin/content/node_import/add - Step 1 of 8 - choose the Content Type
- same url - Step 2 of 8 - upload your CSV file (or similar) - or choose your file from previous uploads
- same url - Step 3 of 8 - "Set file options" "Enter the file format options for the file." then check the sample data output further down the page
- same url - Step 4 of 8 - "Map file columns" "For each content type field, select the columns in the file that contain the data for this field." - the better your headings in the csv files match the field names used in Drupal the better - and remember Node Import does not import data for all modules yet, a bit frustrating - but you might just be the person to contribute a missing link here.
- same url - Step 5 of 8 - "Set import options" - may not apply to the data you want to import.
- same url - Step 6 of 8 - "Set default values" - may not apply to the data you want to import. The defaults may be fine. If you have CCK fields set as "required" you must provide a default here - whether or not your CSV file contains actual data - you could write here for example "to be added", etc. If you use lists in CCK to choose from you need to use one of the options from that list - as far as I remember. You will get a red warning if something is wrong.
- same url - Step 7 of 8 - "Preview import" - here you can see if your data is read correctly form the csv file. If you can see a problem in the sample data (such as special characters) you can correct the csv file locally on your machine and then just reload the corrected csv file using FTP to the right place on the server (../import) - this saves you going through the whole process again. Then just press "Realod" and check the sample data again. - You may ant to increase the number of sample data records extracted - just press "Relaod" again.
- same url - Step 8 of 8 - "Start import" - final chance to see you sample data further down - if all is clear hit "Start Import" - wait - well the process will run till it is finished. You can watch it like grass grwoing or do something else. The process will run indepently from you being logged on
If there are problems you can at the end of the import download a csv / excel file / open the problem data in Excel and check what is wrong.
You can then just correct these lines, create a new csv file - like "repaired ...csv" and just add these lines of data now.
That's it - I suggest you run a few tests with a sample / test content type and a test csv file with some 10-50 rows of content. Takes a little while to get it going - take notes along the way for your memory as creating the csv file via Excel and other helpers will involve quite a few steps.
I have attached a reduced sample filet UTF-8 with the following headers:
Name of Mall
State / County
..... more not included
Title,Name of Mall,Country,Location name,City,State / County,Street location,Additional,Postal code,Latitude,Longitude
Loop 5,Loop 5,Germany,,Weiterstadt,Hessen,,,64331,49.90778,8.59528
Kaufpark,Kaufpark,Germany,,Dresden,Sachsen,Dohnaer Straße 246,,1239,,
Einkaufscenter Marler Stern,Einkaufscenter Marler Stern,Germany,,Marl,Baden-Württemberg,,,74172,,
Einkaufszentrum Hamburger Straße,Einkaufszentrum Hamburger Straße,Germany,,Hamburg,Hamburg,,,22000,,
Ostsee Park,Ostsee Park,Germany,,Rostock-Sievershagen,Mecklenburg-Vorpommern,Ostsee-Park-Straße 3,,18069,,
Nordwest Zentrum,Nordwest Zentrum,Germany,,Frankfurt/Main,Hessen,Limescorso 8,,60439,,
Südring Center,Südring Center,Germany,,Groß-Machnow,Brandenburg,,,15806,,
Lausitz Park,Lausitz Park,Germany,,Cottbus,Brandenburg,Madlower Chaussee 4,,3058,,
Hürth Park,Hürth Park,Germany,,Hürth,Nordrhein-Westfalen,Theresienhöhe,,50354,,
Please note: the sample above contains special characters and to import these and other special characters into Drupal you need to make sure your source (import) file is converted to UTF-8. I produce these lists in Excel and save them as csv. Then I use a text editor like Node Tab Pro to save the file in UTF-8.
This is only necessary for files containing special characters. If you produce lists just in plain English you do not need to convert the csv file.