Every organisation that sells to larger companies answers the same security questionnaire many times a year: a customer's vendor assessment, the cyber insurer's renewal form, an auditor's request list, each worded differently, each asking about the same thirty or forty controls. Questionnaires (under Third-Party Risk) turns that into one job: upload the file as it arrived, let the platform draft the answers from your control library and from answers you have approved before, review them, and send the spreadsheet back.
What you need
- The Basic plan or above. The Free plan includes the questionnaires you send to vendors, not the ones you receive.
- The Inbound Questionnaires permissions: View to open the list, read a questionnaire and export it, and Edit to upload, draft, write, approve and change the status. By default administrators and editors have both, and viewers have View only. Choosing a control for an answer also needs the View permission for GRC.
- The file as the requester sent it, in one of these types: Excel (.xlsx or .xlsm), CSV (.csv), Word (.docx) or plain text (.txt or .md), up to 5 MB and 1,000 questions. Older Excel (.xls) and Word (.doc) files and PDFs are not accepted: save the file as .xlsx or .docx first, or ask the requester for an editable copy.
- Optionally, your organisation's own AI provider saved under Settings, AI (Claude, ChatGPT or DeepSeek, with your own key), which is available from the Professional plan. Without one, drafting still fills in the answers your answer library holds and the rest are written by hand.
Uploading a questionnaire
Choose New questionnaire, pick the file and say who sent it (Customer, Insurer, Auditor, Regulator or Other). Excel and CSV files are read row by row: the column whose cells read like questions becomes the question list and any short cell before it on the same row is kept as the section or reference. Word and text documents are read line by line: lines that end with a question mark or start with a number become questions, short lines above them become sections. Files up to 5 MB and 1,000 questions are accepted; a file with more questions is refused whole, not cut off.
The upload form
| Field | What to enter |
|---|---|
| Questionnaire file | Required. One file per questionnaire; Create stays disabled until a file is chosen. |
| Title | Optional. Left empty, the file name without its extension is used. |
| Requesting organisation | Optional. The organisation that is asking. |
| Sent by | Customer (the default), Insurer, Auditor, Regulator or Other. |
| Contact name, Contact email | Optional. The person at the requester. |
| Due date | Optional. Shown for information only: no task, reminder or calendar entry is created. |
| Notes | Optional. |
The list and the questionnaire page show the title, the requesting organisation and contact name, who sent it and the due date. None of the fields can be changed once the questionnaire is created, so check them before you choose Create.
How Excel and CSV files are read
- Only one worksheet of a workbook is read: the first one that contains anything. If the questions sit behind a cover or instructions sheet, move the questions sheet to the front, or save it as a workbook of its own, before you upload.
- A cell reads like a question when it ends with a question mark or is longer than 25 characters. The column with the most such cells becomes the question column, and each row whose cell in that column reads like a question becomes one question.
- If another column, such as guidance notes, has long text in more rows than the question column, it is read as the question column instead. Remove that column from a copy of the file before you upload.
- The nearest cell to the left of the question on the same row that holds 60 characters or fewer is kept as the section or reference, for example "Access control" or "A.5.1". A heading on a row of its own is not used as a section, and one longer than 25 characters in the question column is read as a question.
- Short items without a question mark, such as "MFA enforced", are skipped. Add a question mark or write the item out in full if it needs an answer.
- CSV files are read as UTF-8 text with commas or semicolons as separators. Prefer the Excel file to a CSV made from it: in a CSV, a line break inside a cell splits the question, and a semicolon inside a question can do the same.
How Word and text files are read
- Word (.docx), .txt and .md files are read line by line as plain text; in a Word table each cell is a line of its own. Bullets, hyphens and asterisks at the start of a line are ignored, and Markdown formatting is not interpreted.
- A line becomes a question when it ends with a question mark, or when it starts with a typed number such as "1.", "1)" or "2.3" followed by text. The number is left out of the question.
- Any other line of 60 characters or fewer that does not end with a full stop is read as a heading and becomes the section of the questions below it. All other lines are skipped.
- Numbers that Word adds through automatic list numbering are not part of the text, so an automatically numbered item is recognised only if it ends with a question mark.
What is not imported
- Answers, comments and every other column already in the file. Only the questions and their sections are taken, so a questionnaire that arrives partly filled in starts empty.
- A question that repeats an earlier one word for word, capital letters and extra spaces aside. It is kept once.
- Column headings such as "Question", "Requirement", "Ref" or "Answer".
- Formatting, dropdown lists and the layout of the original file.
- The file itself. It is read once and not kept: it cannot be downloaded from Venvera later and is not added to your evidence, so keep your own copy.
Checking the result
Create reads the file and creates the questionnaire in one step. There is no preview and no choice of worksheet or column; the confirmation, for example "Questionnaire created with 86 questions", gives the count, and the questionnaire opens with every recognised question marked Unanswered. Reading the file uses no AI: the questions are found by fixed rules and nothing leaves the platform.
When an upload is refused
Nothing is created when a file is refused. The message starts with "Could not create the questionnaire:" and ends with the reason.
| Reason shown | What to do |
|---|---|
| The file is empty or larger than 5 MB | Remove worksheets, images or pages that hold no questions, or split the file. |
| Unsupported file type; send .xlsx, .csv, .docx, .txt or .md | The file is of a type that is not accepted, such as .xls, .doc or PDF. Save it as .xlsx or .docx. |
| The file has more than 1000 questions | Split the file and upload each part as a questionnaire of its own. |
| No questions were recognised in the file | The usual causes: the questions are not on the first worksheet, the items are short statements without question marks, or a Word file relies on automatic numbering. Correct the file as described above and upload it again. |
| Any other reason | The file could not be opened, usually because it is password-protected or damaged. Remove the password, save the file again and upload it. |
Drafting answers
Draft answers works through the unanswered questions ten at a time. Each question is first looked up in the answer library, the answers you approved on earlier questionnaires; an exact match or a close paraphrase is filled in from record with the control it rests on. The rest go to your organisation's own AI provider, configured under Settings, AI, with one instruction: answer only from the control library, the requirements each control satisfies, its evidence and the approved policies, cite the control, and say "No information on record" rather than invent. Every drafted answer shows where it came from (From the answer library or Drafted by AI) and, for AI drafts, how well the context supported it, as a confidence percentage. Both are shown until the answer is approved or marked not applicable; from then on it is shown as Written by hand, so read the confidence figures before you approve.
The AI is always your organisation's own provider and key, saved under Settings, AI: Claude, ChatGPT or DeepSeek. Venvera does not supply an AI of its own for drafting. The provider receives a compact summary of your active controls (reference, name, status, the requirements each one satisfies, a short description and up to three recent evidence notes), the titles of your approved policies, and the questions with their sections. The requester's name and contact details, the questionnaire title and the uploaded file are not sent. The summary has a fixed size: in a large control library the controls that operate effectively come first and those that do not fit are left out, so questions about them may come back as "No information on record".
If drafting stops while questions are still Unanswered, the provider did not return a usable answer for them; an expired key, used-up credit or a time-out are the usual causes. Check the provider under Settings, AI and choose Draft answers again: it takes up only the questions that are still unanswered.
Reviewing and approving
Each question shows the draft, the control it is based on (change it from the picker, which lists every control in your risk control library, if the platform chose wrong) and the actions Approve and Not applicable. Edit the text in place; leaving the field saves it. With Save approved answers to the answer library ticked, approving an answer stores it under the question as it was asked, so the next questionnaire that asks the same thing, in the same words or close to them, is answered from record. The library grows with every questionnaire and the share of questions that need a human falls.
The answer library has no page of its own. It is filled only by approving answers while that box is ticked, which it is when the page opens, and it is read only by Draft answers. It stores the answer as it stands when you choose Approve, so finish editing first; approving an answer to a question the library already holds in the same words replaces the stored answer.
An answer is Unanswered until it is drafted or typed, then Draft, then Approved or Not applicable when you choose the action. The Answered count on the list includes drafts. The questionnaire itself moves from Draft to In review on its own as soon as one question has an answer, but approving every answer does not approve the questionnaire: set the status at the top of the page to Approved yourself when the answers are settled.
Exporting
Export (Excel) downloads a new workbook, named after the questionnaire title and ending in "-answers.xlsx", with one sheet called Answers and one row per question in the order the questions were read from the file.
| Column | Contents |
|---|---|
| # | The question number, counted from 1 in the order read |
| Section | The section or reference found with the question; empty if none was found |
| Question | The question as read from the file |
| Answer | The answer as it stands; empty for an unanswered question |
| Status | Unanswered, Draft, Approved or Not applicable |
| Control | The reference and name of the linked control; empty if none is linked |
| Evidence | Empty. Add evidence references by hand in the downloaded file if the requester asks for them |
The export can be taken at any time by anyone with the View permission, and it includes unanswered questions and unapproved drafts, so check the Status column before you send it. A questionnaire whose status is Approved is marked Exported on download; in any other status the export changes nothing.
The original file and its layout are not kept. The export is always this seven-column workbook, also when you uploaded a Word, CSV or text file; the answers are not written back into the requester's own form, and there is no PDF, Word or CSV export. Requesters who want their own template filled in get the Answer column to paste. Match each answer to its question as you paste: lines that were not recognised as questions and repeated questions are not in the export, so it can have fewer rows than the original.
Where it connects
- Controls (under Risk Management): the library is the source of every answer; a control with a clear description and current evidence produces a better draft than a bare title.
- TPRM questionnaires: the other direction, the questionnaires you send to your own vendors.
- Trust centre: publishing your certifications, policies and standard answers there deflects many questionnaires before they are sent.