Create FAQ page from CSV upload?

[Alun]

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

[TechSprout · Accepted solution]

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.

[Alun]

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!

[TechSprout]

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:

<div>

    <h2>How long will I receive my item?</h2>

    <p>Orders take x days to be...</p>

</div>

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

[Alun]

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

[Alun]

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:

<div>

    <h3><b>Is Snowdon a difficult walk?<b/></h3>

    <p>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.</p>

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.

[TechSprout]

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