Drupal 6 has reached the end of its life (EOL), leaving many Drupal 6 site owners wondering what to do with their sites. "Upgrade to Drupal 8" is the most obvious choice, but upgrading from Drupal 6 to Drupal 8 can still be a bit tricky.
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.