JSON stands for JavaScript Object Notation. It stores data as plain text that JavaScript can read and use on a web page. For a course catalog, a JSON file holds the course details that visitors can search, filter, and sort. section 13.2.2 section 13.5
One course as JSON
A course can look like this: {"Course ID":"AI101","Title":"The Art of Chatting: Building Conversational AIs","Semester":1}. Each property name has double quotation marks, and a colon separates it from its value. Commas separate the pairs; braces hold the course together. Text values have double quotation marks, while the semester number does not. For multiple courses, put the objects in a comma-separated array surrounded by square brackets. section 13.2.2
When converting an Excel range, column headings become JSON property names and each row supplies the values for one object. Give every column a unique heading. You can edit JSON in a text editor, but you do not have to write it by hand: upload the spreadsheet to ChatGPT and ask it to create a downloadable .json file. section 13.2.2 section 13.9 section 13.2.4
In the uploaded Excel file, please convert the range in the worksheet named "My Data" to JSON format and output the result as a JSON file.
Use this prompt when the data is in a worksheet named “My Data.” Replace that name with your worksheet’s name. You can instead name a particular range or table when that better identifies the data. section 13.2.4
Open the downloaded file and check that it contains the intended rows. If it does not, try a more specific prompt identifying the range or worksheet. On the catalog page, JavaScript fetches the separate JSON file, displays its records, and responds to the search, filter, and sort controls. You can ask ChatGPT to generate that code; avoid casual edits to the JavaScript if you are new to it. section 13.2.4 section 13.5 section 13.6.3


































