Drupal: CSV Import

Installation

Install modules Chaos Tool suite and Feeds.

Create new importer

Go to admin/build/feeds and create a new importer:

  • Basic Settings: set Minimum refresh period to Never
  • Fetcher: File upload
  • Processor: Node processor
  • Processor > Node processor > Settings: choose content type
  • Processor > Node processor > Mapping: define CSV fields and corresponding Drupal fields

Import CSV file

Go to /import and select importer.

Notes

  • one content type per importer
  • can delete last imported nodes from upload page
  • line breaks are possible (Ctrl-Enter in Excel and OpenOffice)

Reference

Feedback