what model is good for inspecting and extracting data from large set of spreadsheets
Posted by bonesoftheancients@reddit | LocalLLaMA | View on Reddit | 2 comments
as per title - i need to extract some data from a set of spreadsheets and wondering what would be the best method locally? I think I can utilise gemini-cli for that but can a local model work better?
synw_@reddit
Nemotron 30b a3b has been doing a good job for me with this kind of tasks. But I would recommend to ask a coding model to write a script to extract the data if it is possible for your use case: it's more safe and prevents hallucinating numbers.
Jonathan_Rivera@reddit
Yes, have something whip up a python script or use an extension to setup pivot tables for you. Nothing worse than having an LLM do something for you and you have go thorough and recheck the whole thing.