Frequently asked questions, or FAQs, are a great way to improve your customer's knowledge of the products. With our Awesome plan, you can enable the Q&A badge and widget on your product page. 

This article will show you how to import your questions and answers to show in this widget in 4 easy steps.


4 steps to import questions and answers via CSV

Step 1: Download the CSV template

You can download our sample CSV file for questions and answers using the link below.

Download CSV file

To edit the file, you can:

  1. Login to Google Sheet and create a new sheet.
  2. Click File > Import > Upload and select the file CSV you downloaded above.
  3. In Import location, choose Replace current sheet and check the box Convert text to numbers, dates, and formulas.
  4. Click Import data.

Step 2: Fill in the questions and answers

Here's what each of the columns in the CSV file means:

question_idoptionalthe unique code of each question
  • If provided, answers can be grouped together under one question
  • If you group several rows under one question_id, we'll take the question_content from the first row in that group.
question_content
requiredthe content of the question
curatedoptional
  • Write "ok" if you want the question to be published.
  • Write "spam" if you want the question to be hidden.

If left blank, the question will be published automatically upon import.

sourceoptionalthe source of the question
asker_emailoptionalthe email of the person who asked the question. If not provided, we will autogenerate a dummy email instead.
asker_nameoptionalthe name of the person who asked the question. If not provided, we will use "anonymous" instead.
product_id
product_handle
either is requiredYou just need to fill in either the product_id or produt_handle. Here's how to find these values:
question_dateoptional the date when the question is submitted (in dd/mm/yyyy format). If not provided, the current date will be used.
answer_idoptionalthe unique code of each answer
answer_contentoptionalthe content of the answer. If not provided, the question will be created without answers.
answerer_emailsemi-optionalthe email of the person who answered the question. Need to be provided together with the answerer_name. If not, the shop name and email will be used instead.
answerer_namesemi-optionalthe name of the person who answered the question. Need to be provided together with the answerer_email. If not, the shop name and email will be used instead.
answer_dateoptionalthe date when the answer is submitted (in dd/mm/yyyy format). If not provided, the current date will be used.

Step 4: Upload the file to Judge.me

  • When you're done editing the Google Sheet, you can download it as a CSV file by choosing File > Download > Comma Separated Value (.csv).

  • Then in Judge.me admin, click Import & Export.
  • Then choose Import/Export Q&A > Import Q&A.

  • Select Q&A Source as Direct.
  • Choose your CSV file then click Import Q&A.

Step 4: Review the results

After you upload the CSV file, you'll be automatically redirected to the Questions and Answers dashboard. We will process the file in the background and send a notification email with the details to all email addresses listed in Settings > Review request > Admin Notifications.

In this email, you can check how many questions and answers have been imported, how many have failed and the reason they failed to import.

You will see the successfully imported questions and answers in the dashboard after a few minutes.