Can't get AI to accurately analyze a spreadsheet – help needed

I work in marketing. Analyzing spreadsheets of data and drawing conclusions is a regular part of the job. I have pro accounts with both GPT and Perplexity. Neither one of them seems to be able to accurately analyze spreadsheets. They either miss portions of the data or draw wrong conclusions. I need help! Any thoughts or recommendations for other tools?