Is your feature request related to a problem? Please describe.
This is related to this issue #8783 to make it easier to work with csv style documents in Haystack.

We've been working with more clients who have large and sometimes complicated excel and csv files that often contain multiple tables within one spread sheet.

We've found that keeping the document size manageable to be necessary in RAG use cases so we would ideally be able to split these spreadsheets into their separate tables. Otherwise we find the single massive table is too large to be effectively retrieved and often takes up too much space in the LLM context window.

Describe the solution you'd like
Therefore, it would be great to have a component that could split these single massive tables into the multiple smaller tables. I think it would make the most sense to create a separate CSV Document splitter to handle to this rather than expand our existing DocumentSplitter, but I'm open to discussion.

Additional context
Here is an example csv I created that has two tables combined into a single large table.

two-tables-in-one.csv