We have been exploring different ways to import CSV data into Drupal and found a nice workflow with the Migrate and Table Wizard module. There are still a few tricky parts to the process — documentation is often unclear or conflicting – and following is a description of our steps to import a CSV file into Drupal as nodes with CCK fields.
Migrating a CSV file into a Drupal content type
- Prune your CSV file so that it plays nice with Table Wizard. There are some tips in the README.txt for the Migrate module and I recommend you read this, especially if you would like to import taxonomy.
- Import the CSV file into a database table using 'Upload delimited files' at Administer > Content management > Table Wizard. You will likely get a message telling you that you need to define a primary key for the table:
