Programs
      Back to home
      1. Via TRM Knowledge Base
      2. Programs

      How do I embed an approved course list in a program brochure?

      Hi there! 👋 Please note that an embed link is different than copying and pasting a URL! An embed link will allow you to 'show' the spreadsheet you've created in a original source. When changes are needed, editing the original spreadsheet document  will also be reflected in Via. 

      Read on for more info on how to generate the embed link

      Administrators with permission can embed a course list by linking from a standard web-based spreadsheet application like Google Sheets or Microsoft Excel. The embed Course List feature allows admins to share a list of approved courses and make them visible to travelers within a  program brochure. If an administrator updates the embedded list, Via will display the most up to date information in the program brochure. The goal is to facilitate transparency of this  information and make it available to travelers when browsing for programs. 

      During our extensive user research we found that admins want to share important course information early while helping travelers make a more informed decision when applying to a program that are best suited for their academic aspirations. 

       

      Please note that while we are spreadsheet lovers, we do not consider ourselves spreadsheet gurus. The information below is provided to assist you in working with whatever spreadsheet/s you use in your office. For the best customer support regarding your spreadsheets, our support team is happy to give it a go to assist, but we ultimately suggest that you contact support at the organization that created your spreadsheet software. 

       

      Click for assistance with the following software products:

      Google Sheets

      Microsoft Excel Business

      Microsoft Excel Personal

      Paste the Link You've Copied to your Program Brochure

       

      Google Sheets

      Google Sheets Support link:

      To embed a Course List URL within a Program Brochure...

      1. Open spreadsheet in Google Sheets
      2. Click File > Share > Publish to Web
      3. Click Link
      4. Either keep the Entire Document selected or select the single Worksheet (tab) you want to display (make sure Web Page is selected)
      5. Copy the link provided
      6. Embed the link into your Via Program Brochure

       

       

      Microsoft Excel Business (OneDrive or SharePoint)

      Microsoft Excel OneDrive or SharePoint for Business Support Link:

      How to copy an embed link from the business version of Microsoft Excel on OneDrive or SharePoint...

      1. Open spreadsheet in Excel in OneDrive or SharePoint
      2. Click the Share and then select Share
      3. Click Anyone with the link can edit
      4. Update Can Edit or Can View as desired
      5. Block Download if desired by toggle Block Download to On
      6. Click Apply
      7. Click Copy
      8. Copy link
      9. IMPORTANT: Paste the link in a word document or somewhere where you can view the entire link.
      10. Add the following EXACTLY to the end of your link: &action=embedview&wdbipreview=true
      11. So your link will go FROM a TO b:
        1. https://sternfive-my.sharepoint.com/:x:/p/lisa/EYUujW-rVOxGjnaWuLmDsAQBjrin7LyF882Ps5ccGyx0sg?e=GTnVX2 
        2. https://sternfive-my.sharepoint.com/:x:/p/lisa/EYUujW-rVOxGjnaWuLmDsAQBjrin7LyF882Ps5ccGyx0sg?e=GTnVX2&action=embedview&wdbipreview=true 
      12. Embed the link into your Via Program Brochure

       

       

      Microsoft Excel OneDrive Personal

      Microsoft Excel OneDrive Personal Support Link:

      • https://support.microsoft.com/en-us/office/share-it-embed-an-excel-workbook-on-your-web-page-or-blog-from-onedrive-804e1845-5662-487e-9b38-f96307144081

      How to copy an embed link from the personal version of Microsoft Excel on OneDrive or SharePoint...

      1. Open OneDrive for personal use
      2. Open your desired file
      3. Click File > Share > Embed
      4. Customize your options
      5. Copy the embed code and paste it into a notes app or document app so that you can edit it
      6. Remove everything in bold and italicized in the example below. Your data will be different but essentially you can to remove what precedes https (including the quotation mark) and everything from the last quotation mark to the end of the link
        1. Example embed code from Excel
          1. From this: <iframe width="292" height="346" frameborder="0" scrolling="no" src="https://onedrive.live.com/embed?resid=F09FE5D78FFFC72%21132&authkey=%21AJ_E2aFSumu6v7E&em=2&waccluster=PUS10"></iframe> 
          2. Only use this: https://onedrive.live.com/embed?resid=F09FE5D78FFFC72%21132&authkey=%21AJ_E2aFSumu6v7E&em=2&waccluster=PUS10
      7. Embed the link into your Via Program Brochure

       

       

      How to Paste the Link You've Copied to your Program Brochure

      To paste the embed link in your Program Brochure...

      1. Click Programs 
      2. Click the Program Name Hyperlink 
      3. Click Edit Program 
      4. Scroll down to the Academics Section 
      5. In the Embed Course List URL section, paste the public link from your original document
        1. To confirm the document will be visible to travelers, click Preview
      6. Click Save