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:
Other People Are Reading
Things you need
- Drupal 6 or above
- WYSIWYG module
- CSV file-transfer module
Go to your modules list from your dashboard and click on WYSIWYG module. Your browser will take you to a WYSIWYG preferences page.
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.
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.
Create a new page on Drupal and choose the "Edit" button to display the WYSIWYG editor for your content.
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.
Save your XLS Excel file as a CSV file through the "Save As" function under "File" in Microsoft Excel.
Close the XLS file and open the CSV file.
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.
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.
Choose the "Save" button at the bottom of the page. Navigate to the front-end of the page to review the new Excel content.
CSV File Transfer
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for