Skip to Questions

Guide FAQ - Your LibGuides v1 Questions. Answered!


Can data from an excel spreadsheet be imported into a LibGuide page?

Last Updated: Oct 03, 2012  |  1374 Views
Topics: How To...

Was this helpful? 2   0


The answer here is yes, with some caveats. Microsoft Excel is rather notorious for adding extraneous "junk" code to HTML, but there are steps you can take to mitigate those problems. However, these steps will also strip most of the formatting from your table, so you need to plan to rebuild any specific font styles (bolding, font size/style, etc.) after you pull in the actual table content. To paste in excel content:

  1. Create a new Rich Text box
  2. Be mindful of the column width - if your table has many columns, it's best to format your table (in Excel) to comprise a total width that's smaller than the column width on your guide
  3. In your Excel document, highlight all of the cells you'd like to copy over; then select "Copy"
  4. Head over to your Rich Text box, and click "edit text"
  5. Paste in your content
  6. Click the "Remove Formatting" icon Remove Formatting Icon (VERY important!!!). This will cause all of the fonts on the page to revert to system defaults
  7. Click "Save and Close"

Once you've followed these steps to import your Excel content, you can then use the style elements in the Rich Text Editor to change your document's look-and-feel options.

*Keep in mind, pasting content from Excel into any HTML document is rarely an uneventful experience, so if you need more specific help, please let us know!*

You can also use Google Docs to help you paste an Excel Spreadsheet into a LibGuide.

This outline assumes you're starting with an existing Excel file.

  1. Go to & login (or create an account)
  2. Select "Upload..." (top-left of the screen) and upload your Excel doc
  3. Manipulate the layout however you'd like
  4. When you've got it looking the way you want, select "File" --> "Download As" --> "HTML"
  5. In the new screen that appears, right-click on the screen and select "View Page Source"
  6. Copy everything that appears in the "View Page Source" window
  7. Head back to your LibGuides page, & in your Rich Text box select "edit text"
  8. Select the Plain Text Editor (very important!)
  9. Paste in what you found in step 6 & save changes.

Keep in mind, if your spreadsheet contains many columns, you'll probably need to adjust the column widths of your LibGuides page in order to avoid a table that spills over the sides of your box.

Answered by Sarah PawlekBookmark and Share

Other Answers / Comments (0)

    Need Help?

    This site contains FAQs for LibGuides v1 only.

    LibGuides v2 Documentation
    (You must have a LibApps account to access that site.)

    Or click HELP in the orange command bar of your v2 system.


    Follow LibGuidesFAQ on Twitter Follow us on Twitter!
     Your questions, answered!

    Browse by Popular Topics

    Accounts  –  Admin Area  –  API / Widgets  –  Boxes  –  Catalog / Database Integration  –  CSS  –  Customization  –  E-Reserves  –  Embedding Objects  –  General System Questions  –  Group Management  –  Guides  –  Holiday Closures  –  How To...  –  Images  –  LibGuides CMS  –  Links  –  Mobile  –  Pages / Tabs  –  Profiles  –  RSS  –  Search  –  Security  –  Statistics  –  Subject Categories  –  Survey/Form Tool  –  System Administrators  –  Tags  –  Webinar  
    View All Topics

    Related content from Springshare v1 Help