If you have a large CSV that was uniformly formatted and clearly had the Zip Code for each vendor, it could probably work.
When you add a CSV file to the Knowledge base, we actually built a custom, specialized system just for processing them that handles CSVs differently than other types of documents.
Here’s how it works.
EXAMPLE CSV
Let’s take the example of this spreadsheet of Taco Bell franchise owners.
HOW IT GETS CHUNKED
The very top row (with headers) is turned into properties. Then each subsequent row is turned into an individual chunk with the headers as properties. For example, row 4 would be turned into:
{
Owner name: "Charlie Puck",
Location: "Billings, MT",
Annual Revenue: "$72,000",
Top-selling Item: "Doritos Locos Taco"
}
So this CSV would be turned into 3 separate chunks, and then entered into the Knowledge Base. Here’s what it looks like after you add this CSV to the Knowledge Base.
HOW IT GETS PULLED UP
Then when people ask questions, it can pull up the relevant chunks. For example, when we ask the question everyone wants to know “Who sells the most Doritos Locos Tacos” it’s able to pull the relevant row of the CSV.
