Create FAQ page from CSV upload?

Store Design
,

Topic summary

Goal: Generate an FAQ page from a CSV file for a store, ideally via an automated method.

Key approach proposed:

  • Use a GPT-style AI (e.g., Google Gemini) to convert CSV rows into the store’s existing FAQ HTML markup.
  • Provide the AI with a small example of the current FAQ structure and explicit instructions: first column = question (heading), second column = answer (paragraph), each row wrapped in a div.

Implementation details:

  • Instead of asking for a script, request the AI to output the final HTML markup directly.
  • A working prompt included an HTML example (div container; question as h3 with bold; answer as p) and an instruction to process rows until encountering the value “END,” then stop.

Outcome and limitations:

  • The user successfully produced the desired HTML and could copy-paste it into the webpage.
  • Direct file handling did not work; success came only by pasting CSV data into the AI prompt.

Status:

  • Practical workaround achieved; no specific app was identified.
  • Open point: handling CSV via direct file upload remains unresolved.
Summarized with AI on December 14. AI used: gpt-5.
1

I want to create an FAQ page by uploading the Q&A’s from a CSV file.

Is this possible? If it is, is there an app that people could recommend or could you point me in the direction of how I can do this please?

Thanks in advance

Alun

2

Hi @Alun , I recommend you use a GPT AI of your choice, give it the CSV file and ask it to convert into the FAQ section code of your store by giving it the example markup that’s currently being used to render the FAQ points.

3

Thanks for taking the time to answer my question @TechSprout , that’s very helpful. I’ve been spending the last couple of days trying to come up with a GPT (actually using Google Gemini Advanced) trying to craft a script that will format in HTML something that puts the question as a H2 in bold type followed by a new paragraph with the answer - no success so far!

4

no worries @Alun , I would ask Gemini to directly give you the markup instead of a script, for example I would tell it:

based on my current FAQ markup:

How long will I receive my item?

Orders take x days to be...

Convert the following csv file into the same HTML format of the given example above. assume the first column of the csv file is the heading, the second one is the paragraph, each row is a div.

That should do

5

That sounds like it should work!! Thanks again @TechSprout , I’ll give that a try later and come back. Alun

1 Like
6

This script worked a treat for my application:

This is a new request of you.
Here is an example of how I want the comma-separated data formatted in HTML from the data:

Is Snowdon a difficult walk?

Routes and paths up Yr Wyddfa (Snowdon) They are all classed as 'hard, strenuous walks' and you should allow at least 6 - 8 hours to get there and back, even if you're pretty fit.

Complete for every row in the CSV until you come across the value “END” at which point you’ve completed the task and can close the div

Produce the HTML here so that I can copy&paste this into my webpage

Unfortunately, I couldn’t get it to work directly with the file, only when I pasted the CSV data into Gemini too.

7

Hey @Alun , glad it worked after you pasted the file in your prompt. All the best!