This guide explains how to bulk upload existing question-and-answer content into the Q&A Store using structured files. This is the fastest way to migrate legacy content, shared repositories, or exports from other systems into BidScript.
What the Q&A Store Accepts
The Q&A Store is designed for structured content, not free‑form documents. For this reason, only the following file types are supported:
Excel (.xlsx)
CSV (.csv)
These formats allow BidScript to reliably map questions to answers and convert them into AI‑ready knowledge.
Best practice: One row = one complete question-and-answer pair.
Preparing Your File
For the cleanest import:
Use a simple column layout
Avoid merged cells
Ensure questions and answers are complete sentences
Recommended structure:
Column A: Question
Column B: Answer
Additional columns (e.g. Theme, Sector, Notes) are allowed, but only the selected Question and Answer columns will be ingested, the remainder of the columns will be included as metadata.
Step‑by‑Step: Uploading a File
Open the Q&A Store
Click Upload QA
Select your Excel or CSV file
Click Next
When prompted, select:
The column containing Questions
The column containing Answers
Confirm and upload
Once uploaded, BidScript will begin processing and vectorisation automatically.
Processing & Vectorisation
After upload, your file enters the processing pipeline:
Content is analysed
Q&A pairs are converted into AI‑searchable vectors
Entries are added to the Q&A Store table
You can continue working while this happens. No action is required.
Tip: Large uploads may take longer, but processing happens in the background.
Handling Edge Cases
Multiple Sheets
BidScript will assume the same column layout for each sheet.
Formatting Issues
If questions or answers appear truncated:
Check for line breaks or merged cells
Re‑upload with simplified formatting
Duplicate Content
BidScript will ingest duplicates if present.
Best practice: Periodically review usage indicators and remove outdated or duplicated answers manually.
Permissions & Access
Only Core Members and Admins can upload Q&A pairs
Admins can restrict Core Member access
Sales, SMEs, Reviewers, and Guests do not have access to the Q&A Store