Data Templates

Data Templates

Connect your data template to your slide

  • STEP 1: Download the data template from the:
    • Vibe Portal
      After you have created your new slide, select File Upload in the Content Source dropdown.
      Click the Download button to save a copy of the data template locally.
      DataTemplateDownload.gif

      OR,
    • Vibe Help Center
      Check out the Template Library articles to download data template examples or a blank copy that you can use to add your own data/messages/events.
  • Step 2: Choose your preferred content source
    With data templates, you can manually upload your latest file into the Vibe Portal or centrally manage all of your data templates in Google Sheets or SharePoint.
    • File Upload - Update the file locally and save your changes. Then, upload the file to your slide.
    • SharePoint /  Google Sheets
      • Existing data integration
        • Setup a folder in Google Drive or SharePoint
        • Copy the data template (XLSX) into your new folder
        • In the admin console, add the folder path to your API settings
          (read more Google Sheets or SharePoint)
        • In the Vibe portal
          • Select your data source in the Content Source dropdown
          • Select your data file in the 'Data' dropdown
      • New data integration
        Chat with your Vibe Coach or the Vibe.fyi team about upgrading your subscription to include a SharePoint or Google API data integration.

Common Data Entry formats

Tips and tricks when managing your data in a spreadsheet:

Data Column Supported Formatting
Title Free format (alpha, numeric, etc)
Summary Free format (alpha, numeric, etc)
TIP: Use ALT+ENTER to add a line break
Date DD/MM/YYYY or MM/DD/YYYY
Image

Both PNG & JPG formats are supported.

The way you reference an image file in this column will depend on the content source you have chosen:

  • File Upload: Enter "image:a_public_image_url" in the cell.
    e.g. image:https://vibe.fyi/images/logo.png

  • Google Sheets: Enter "=IMAGE(""a_public_image_url"")"
    e.g. =IMAGE(""https://vibe.fyi/images/logo.png"")

  • SharePoint: Copy your images into the parent folder where your data template is saved (or a direct sub folder), then reference the filename in your XLSX file, e.g.:
    • If your image is saved in the parent folder, the filename should be entered as '<imagefilename>.<fileformat>'.
    • If your image is saved in a direct sub folder, the filename should be entered as '<subfolder>/<imagefilename>.<fileformat>'.
      mceclip0.png
Time HH:MM AM or HH:MM PM

TIPS

Set the correct slide duration

If the slide Duration field does not show "seconds per item" and the slide shows only one spreadsheet row at a time, we need to set a duration value that covers all spreadsheet rows. The steps to find the correct duration value are as below:

  1. Find a spreadsheet row that will take the longest time to show on the slide
  2. When the slide starts showing the content of that row, monitor the clock to measure the time until the slide animation completes.
  3. Enter the counted seconds into the slide Duration field.

Slide not updating?

Check the name of your sheet and try renaming it to 'Sheet1'
mceclip0.png

Text Formatting

Make your content stand out using Bold and Underline formatting.

Vibe.fyi Data Template Groups

Vibe communication templates that share a common data structure can be managed using the following XLSX template:
VIBE-DATA-A.xslx
 VIBE-DATA-B.xslx VIBE-DATA-C.xslx VIBE-DATA-D.xslx VIBE-DATA-E.xslx
VIBE-DATA-F.xslx
VIBE-DATA-G.xslx
VIBE-DATA-H.xslx
VIBE-DATA-I.xslx
Carousel
Image Gallery
Message (Bubbles)
Poster
Values





Training(Panels)
Training(Bubbles)

The Vibe data templates (xlsx) files are available to download in your portal or using the links below.

    • Related Articles

    • Data (Plot)

      Display a clear comparative view by overlaying two data columns (bar and line graphs) and make it eas to track and understand your metrics onscreen. The design features prominent data at the forefront, with up to twelve columns viewable through ...

    • Data (Stats)

      Visualise your data with impactful statistics in a snackable and dynamic form. Perfect for displaying targets, figures, KPIs, and ensuring that your data is easily understood. Customise the messaging with various graphic chat bubbles and status ...

    • Data (Multi-bubble)

      Visualise and Share Critical Metrics with Ease! Elevate your data presentations with the Data Multi-Bubble template. This template enables you to display up to four dynamic data bubbles at a time, making it ideal for showcasing sales metrics, KPIs, ...

    • Data (3 Dials)

      Track Key Metrics with an Engaging 3-Dial Dashboard. Easily monitor performance with the Data 3-Dials template, a dynamic visual tool that updates in real-time to showcase Today’s, Weekly, and Monthly metrics. Originally designed for tracking Net ...

    • Data (Multi-Dial)

      Track KPIs and Financial Data with Clarity! The Data Multi-Dial template is designed to clearly display your key performance indicators (KPIs) and financial figures. Each dial showcases numbers, dollar amounts, or percentages, indicating whether ...