I am using Drupal 6 and created a custom content type. I have an excel sheet that has more than 2 lacs entry. It is not easy to enter manually.

Is there is any way to this, either programmatically or from the UI?

  • there is no taxomony field in content type Oct 21 '13 at 0:51
  • "lakhs"? I have tried to fix your question as best as I could but it was really hard, it was so full of typos. Please pay a little attention -- it was visible not the lack of English knowledge :/
    – user49
    Oct 21 '13 at 0:53

You need the Feeds module.

  1. Export your excel sheet as CSV with column headings quoting every cell.
  2. Download and install the Feeds module (and optionally Feeds Tamper).
  3. Create a new Feeds importer to consume the CSV. http://example.com/admin/structure/feeds/create Set Fetcher (change) to file upload, Parser (change) to CSV parser and Processor to Node processor.
  4. Map (exactly) your column headings in Node processor mapping.

I've used this with great success in Drupal 7 and once in Drupal 6. PS: Upgrade to D7.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.