How to Create Pages From an Excel File in Drupal

Written by nicolette calhoun
  • Share
  • Tweet
  • Share
  • Email

Creating pages in Drupal based on Microsoft items is common. Although this usually involves text content copied and pasted from Microsoft Word, you can also use Excel and Drupal pages if you want to display a table of content. Excel is harder to move than Microsoft Word, because when transferring Excel into HTML, formatting can sometimes become distorted or lost altogether. There are two methods of creating pages from Excel into Drupal. The first is copy-and-paste, which requires use of the WYSIWYG module. The second is CSV import, which requires the use of the CSV 4.5 module.

Skill level:
Moderate

Other People Are Reading

Things you need

  • Drupal 6 or above
  • WYSIWYG module
  • CSV file-transfer module

Show MoreHide

Instructions

    Copy-and-Paste

  1. 1

    Go to your modules list from your dashboard and click on WYSIWYG module. Your browser will take you to a WYSIWYG preferences page.

  2. 2

    Choose "No Editor" for Filtered HTML, "TinyMCE 3.2.6" for your Full HTML, and "No Editor" for PHP code at the Input Format box.

  3. 3

    Follow through the sets to set up WYSIWYG preferences further. Make sure to check the "Paste from Word" radio box when it appears. This will allow the WYSIWYG module to extract all Microsoft files properly.

  4. 4

    Create a new page on Drupal and choose the "Edit" button to display the WYSIWYG editor for your content.

  5. 5

    Copy-and-paste the Excel spreadsheet into the WYSIWYG editor. Click the "Save" button at the bottom of the page. Navigate to the new page and review it.

    CSV File Transfer

  1. 1

    Save your XLS Excel file as a CSV file through the "Save As" function under "File" in Microsoft Excel.

  2. 2

    Close the XLS file and open the CSV file.

  3. 3

    On your Drupal site, go to your modules list and choose "CSV filter." Review the preferences to make sure that the module is enabled, but do not modify the core settings.

  4. 4

    Create a new page in Drupal and choose "Edit" to add content. Copy-and-paste from the CSV file into the content box on the page editor.

  5. 5

    Choose the "Save" button at the bottom of the page. Navigate to the front-end of the page to review the new Excel content.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.