Support > Import Questions from a Word Document

Import Questions from a Word Document

Any questions? Get in touch.

Last updated: 27th January 2023

Introduction

This article explains how to import questions into your project from a word document and classify the information for your questionnaires. Also see how to Import and Classify Questions from a Spreadsheet.

Import and Classify Questions from a Word Document

Import Questions from Word Documents

Add questions from the Welcome Screen

If you've just created a new project and still have the Welcome to your Project pop-up window open, you can click the Upload File button to get started uploading questions straight away. If you’ve already closed the welcome screen, or want to add questions later, follow the steps below.

To import questions into your project:

  1. Open the Manage Project menu in the top-right of the screen.
  2. Select Add Questions from the menu.
    The Question Sources screen displays and the Add File pop-up appers.
  3. Click the Choose file buttin.
  4. Navigate to your word document and click the Open button.
  5. Click the Upload button.
    Pearler processes the file and displays all uploaded files and the sheets they contain in the Files list on the Question Sources screen.

File Formatting

When you import questions from a word document Pearler changes the formatting. However, when the file is exported, all of the original formatting will be preserved and display correctly in the final document.

Classify Data from Imported Word Documents

To classify data from word documents:

  1. Click on a question in one of the tables in your document in Pearler and click the Mark as Question button that displays.
    Pearler attempts to automatically classify and pre-populate as much of the data in the document as possible. However, tables must be formatted similarly for this to work. If a table has a different format, it may not be filled in automatically.

Data Classification

Pearler highlights data according to one of four classifications.

  1. Answer (A) - Green
  2. Compliance (C) – Orange
  3. Reference (R) – Grey
  4. Information (Questions) (I) – Blue
  1. Select any of the data classification options that display in place of the Mark as Question button and click on the corresponding data, or the space where the data will be if the questionnaire has not yet been completed.
  2. Click the Save Changes button in the top-left of the screen.
  3. Click the x in the top-right of the screen to close the Question Sources window.
    The home page will show the number of questions that were imported in the Incomplete Questions box on the top-left of the screen.
You've now imported questions from your spreadsheet into your project.

Other Guides

Looking for more help using Pearler? No problem. Here are some other guides to help you get to know your way around all our great features.