CSV to JSON: vendor list converter

Paste your vendor spreadsheet as CSV, click Convert, and get the JSON array that replaces VENDOR_DATA in vendor-chatbot.html. Everything happens on this page.

Expected format

First row is the header. Columns, in this order:

name,category,rating,reviews,quote,keywords

Rules: category must match one of your chatbot's category ids (for example catering, av, venues, registration). rating is a number from 1 to 5. reviews is a whole number. keywords are separated by semicolons. Wrap any field containing a comma in double quotes.

Example row:

Harvest Table Collective,catering,4.8,32,"The staff treated our gala dinner like it was their own wedding.",gala;banquet;dinner;wedding;plated;buffet