Qvidian for Microsoft Office

With this integration, users can access the power of their Qvidian library directly within Word documents, Excel spreadsheets, and PowerPoint slides. Using simple, streamlined controls, users can search for and add answers to RFPs and questionnaires and automatically insert the best answers to blocks of questions in bulk. Via Office for the Web, users can also work collaboratively in real-time. This integration is designed to complement (not replace) existing Qvidian functionality and was created with RFP writers in mind.

Note: Qvidian for Microsoft Office only supports Microsoft 365 and Microsoft Word, PowerPoint, and Excel versions 2019 and up.

Caution: You may continue to use Qvidian’s legacy (Office) add-ins. For now, the legacy add-ins and Qvidian for Office will both exist in parallel and will not impact each other. If you no longer need Qvidian's legacy add-ins, but still have them installed, please consider removing the add-ins to help improve Office performance.

Installing Qvidian for Office

There are several methods for installing Qvidian for Microsoft Office: 

  1. If one of the following scenarios applies to you, please install the Qvidian for Microsoft Office (US) application:
    • You are located in the US.
    • You are located in the EU, but your Qvidian instance is located on a US server.
  2. If one of the following scenarios applies to you, please install the Qvidian for Microsoft Office (EU) application:
    • You are located in the EU.
    • You are NOT located in the EU, but your Qvidian instance is located on an EU server.
  3. If you are unable to access the Microsoft AppSource, please contact your Microsoft 365 Administrator.
  4. Note: Your Microsoft 365 Administrator will need to install either the Qvidian for Microsoft Office US or EU application depending on where your company's Qvidian instance is located. Once installed, your administrator will need to use centralized loading to deploy Qvidian for Microsoft Office to all client machines. For more information on centralized deployment, please see Publish Office Add-ins using Centralized Deployment via the Microsoft 365 admin center and/or contact Qvidian support.

Accessing Qvidian for Office

  1. After installation, click the Show Qvidian button on the Home menu. The "Upland Qvidian Welcome" sidebar will appear.
  2. Upland Qvidian Welcome panel

  3. Click Log in on the "Upland Qvidian Welcome" sidebar. The "Upland Qvidian Log In" dialog appears.
  4. Enter your Upland Qvidian User Name and Password and click Log In.

Note: The following application permissions must be enabled for Qvidian for Office to work: "Allow user to log into Qvidian for Microsoft Office” and "Allow user to load unsliced RFP files to a project”.

Assignment Workflows in Qvidian for Office

Permissioned users can create assignment workflows when working in Qvidian for Office. Assignment workflows are only available for documents that are part of a Project. The option to create assignments only displays when working in a project's RFP file and is hidden when working with a file that is not part of a project. Interacting with workflows here is similar to interacting with workflows in Qvidian’s Projects workspace. Workflows created in the Projects workspace will also appear when users work on the response in Qvidian for Office.

Searching in Qvidian for Office

Searching in Qvidian for Office is similar to performing a Library search, but not quite as robust:

  • It only allows searching on the following most relevant fields: Title, Keywords, Learned Terms, Content Text. This excludes Content ID, Contact Info, Comments, and Alert Text.
  • It does not allow “match all” searching.
  • It does not use Boolean operators (AND, OR, NOT).
  • It does not provide all of the filter options available in the Library.
  • It does allow you to download searched content.

Note: Performing a search or FirstPass within Qvidian for Office will provide you with the same results as the Library when you do a “match any” on the same fields, folder, and filters, when limited to Word content. For example, if a user performs a search on a question in Qvidian for Office, the top response presented in the panel is the answer that would be automatically inserted if they were to run FirstPass on the same question with the same folders selected. FirstPass is not yet available in PowerPoint.

Inserting Content

After completing a search, the top content results appear in the Qvidian side panel, sorted by relevance. When searched content is inserted into the RFP, Qvidian for Office will remember the search terms that were entered.

Word doc before inserting content Excel doc before inserting content PPT slide before inserting content

Qvidian for Office Results tab before inserting content in Word (left) and in Excel (right) Qvidian for Office Results tab before inserting content in Word (left), in Excel (middle), and in PowerPoint (right)

  1. Once you've completed a search, top content results will appear in the Results tab.
  2. Hover over the results to display the Insert icon.
    • Word: Click Insert Below to insert the desired content into a paragraph cell.
    • Excel or Word table: Click Insert to insert desired content into Excel or a Word table cell. By default, the answer is inserted one cell to the right of the active cell. If you wish to update where the answer is inserted, click the dropdown arrow within the Insert icon; the "Insert Answer" dialog will appear and allow you to select the cell where the answer will be inserted.
    • Insert dropdown

      Caution: If you add a content record that contains images to a cell in Excel, only the text will be inserted. Due to Excel’s limitations, the image will not be added to the cell.

    • PowerPoint: Click Insert Below to insert slides directly into the presentation.
    • Note: The "QvidianForPowerpointSlideInsertMethod" global setting allows you to control whether the inserted PowerPoint slides will use the destination or source formatting. "Destination Formatting" is the best option for organizations that want to start with a consistently themed presentation. Select the "Source Formatting" option to make the inserted PowerPoint slides resemble those found in the library, which will result in a larger file size due to the source master slides included in the build.

  3. Click the More More menu icon on a search result to display the following menu options: 
    • Preview: Click to open a dialog that displays an HTML preview of the content record. You can also select and copy text from the preview window, which Qvidian will record as content usage.
    • Preview dialog

      Note: Microsoft Office default fonts are supported when previewing a piece of content.

      Caution: If you attempt to preview (and copy), insert, or run FirstPass using a piece of Library content with an alert enabled, the alert message dialog will appear prior to your action. If any issues occur, they may be due to the browser version that Microsoft Office is using (which can be different from the version used by your Qvidian instance).

    • Details: Click to open a dialog that displays the content record's metadata (e.g. Content ID, Date Created, Date Last Modified, Times Used, etc.). You can also select and copy and/or drag and drop text from Details.
    • View Details dialog

    • Feedback: Add feedback on content records and reply to existing feedback. This allows you to direct questions and concerns about content records directly to their associated content owners. This is not for providing feedback related to specific responses or Projects. Feedback submitted here is tied to the content record itself, without any greater context.
      • Search: To search through existing feedback, enter text into the Search Feedback field and click the Search Search icon icon or Enter.
      • Filter: Click the Filter Filter icon icon and choose whether to filter by All Feedback or My Feedback.
      • View: To view all replies for a particular feedback thread, click the Show all replies (X) link, where X indicates the number of replies in that feedback thread.
      • Reply: To reply to a piece of feedback, click the Reply button, enter your feedback and click Send. If you do not wish to receive notification emails for this feedback thread, select the Do not send me a notification email checkbox.
      • Add: To add new feedback, click +. The "Send Feedback" dialog will appear. Select the feedback Type (Comment, Problem, Question, Suggestion) from the Type drop-down menu. Once a feedback thread is created, the type cannot be changed. Enter the feedback Title and Comments and click Send. If you do not wish to receive notification emails for this feedback thread, select the Do not send me a notification email checkbox.
      • Note: To add attachments to your content feedback, navigate to the Library and upload the attachments there. For more information, see Feedback.

        Note: The "Use Product Feedback" User / Role permission allows users that are content consumers to submit Feedback on library content.

    • Download: All file types can be downloaded containing their Library References and Default Value Merge Codes. Word files can be downloaded or inserted directly into the Project.

Using FirstPass

FirstPass helps users create a first draft response faster by automatically inserting the most relevant answer to a block of selected questions at the same time. This allows you to spend more time customizing answers and crafting responses to more complex questions. Search terms are not accumulated in FirstPass, but search history is recorded. FirstPass is not yet available in PowerPoint.

Note: To turn off FirstPass, disable the "AllowFirstPassInQvidianForMicrosoftOffice" Global settings

Before running FirstPass During the running of FirstPass Completed FirstPass run

Qvidian for Office screens before running FirstPass (left), during the running of FirstPass (middle), and after the completion of running FirstPass (right)

  1. Click the Menu Menu icon icon and select Library.
  2. Highlight one or more questions or question cells.
  3. Click the FirstPass FirstPass icon icon to automatically insert the most relevant answer(s) to the selected question(s).
  4. If applicable, tell Qvidian where to insert the answers using the Insert Answers screen.
  5. Click Run FirstPass.
  6. Caution: If you attempt to preview (and copy), insert, or run FirstPass using a piece of Library content with an alert enabled, the alert message dialog will appear prior to your action. If any issues occur, they may be due to the browser version that Microsoft Office is using (which can be different from the version used by your Qvidian instance).

Downloading Previous Versions of Questionnaires

While teams work on responses, Qvidian will retain a defined number of past questionnaire versions automatically, to simplify referencing and restoring to previous versions as needed. Office for the Web will automatically create “Incremental Saves” periodically in addition to every time you click the “save” button. A “Committed Save” is captured every time you end an editing session by closing the Office for the Web file in your browser or checking the Microsoft Office 2021 questionnaire response back into Qvidian.

Note: Previous versions of questionnaires can only be downloaded when the questionnaires are part of a Qvidian Project.

  1. To download previous versions of questionnaires, access your Project RFP in your Qvidian instance.
  2. Right-click on your questionnaire.
  3. Select View Details. The "Versions" tab will appear in the left panel.
  4. Download Previous Versions

  5. Click Download on the desired previous version of the questionnaire.
  6. Note: In Global settings, Qvidian admins can adjust the number of incremental changes Qvidian will save (RFPIncrementals_KeepForAtLeastNDays), as well as the number of revisions Qvidian will save (RFPRevisions_KeepAtLeastNRevisions) and how many days Qvidian will retain those saved past versions (RFPRevisions_KeepForAtLeastNDays).

Updating Qvidian for Office Settings

  1. Click the Menu Menu icon icon.
  2. Select Settings from the dropdown menu.
  3. Specify your Subscriber GUID if you are using SSO. For users who install Qvidian for Office through their corporate portal (i.e., organizations using a centralized deployment of Qvidian for Office), admins can define a default subscriber ID for all users. Your Subscriber ID, which is entered into your Subscriber GUID field, can be found in the "About" area within the header of the Qvidian interface.
  4. Select the Turn on debugging mode checkbox to enable the debugging window. This setting is only used when you need to provide customer support with more information regarding an issue that you are experiencing.
  5. Select the Disable SSO authentication checkbox to turn off SSO and use an explicit login.
  6. Note: Qvidian will still remember your Subscriber ID even if you disable SSO functionality. This allows you to re-enable SSO at a later time without looking up and re-entering your Subscriber ID.

  7. Click Save.

Logging out of Qvidian for Office

  1. Click the Menu Menu icon icon.
  2. Select Logout from the dropdown menu.