HeyJake! Here are some tips.
Does the Knowledge Base recognize spreadsheet columns?
The KB handles spreadsheets in a very special way. It turns each row into a json object with the column headers as properties. Here is a forum post that explains in more detail how the KB handles csvs. And here is a youtube video that walks through making a chatbot on top of a spreadsheet.
Best Practices
As far as best practices, it depends on the use case and how you want to draw from the knowledge base. Here is a video that explains best practices for building an FAQ bot on top of a company knowledge base for example.