# Agent and MS Excel files - Read and Write

**URL:** <https://community.crewai.com/t/agent-and-ms-excel-files-read-and-write/6540>\
**Category:** CrewAI Community Support\
**Created:** [July 11, 2025, 7:56am UTC](https://community.crewai.com/t/agent-and-ms-excel-files-read-and-write/6540 "2025-07-11T07:56:21Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![yozart](https://sea1.discourse-cdn.com/flex025/user_avatar/community.crewai.com/yozart/32/4078_2.png) [@yozart](https://community.crewai.com/u/yozart)\
**Post date:** [July 30, 2025, 9:26am UTC](https://community.crewai.com/t/agent-and-ms-excel-files-read-and-write/6540/4 "2025-07-30T09:26:34Z")

</div>

I’m still experiencing issues with my agents when loading Excel data.

When I load the JSON file using the JSONSearchTool, it works correctly the first time. However, if I modify the data in the file afterward, the agent continues to provide the same response, even though the data has changed.

I discovered that the embeddings aren’t being reset each time. I tried using the command **`crewai reset-memories -kn`** , but I’m encountering the same problem described here, despite being on version 0.150.

> [@Crewai reset-memories -kn failes but -l works](https://community.crewai.com/t/crewai-reset-memories-kn-failes-but-l-works/2974):
>
> When running crewai reset-memories -kn i get the following error crewai reset-memories -kn An unexpected error occurred: No module named 'chromadb.utils.embedding\_functions.openai\_embedding\_function'; 'chromadb.utils.embedding\_functions' is not a package Anyone know how to fix this… as crewai reset-memories -l works.

Additionally, I’m concerned this might not solve my issue because, from what I understand, knowledge bases are shared across all users.

What’s the best way to load Excel content into the agent’s memory so it can query and retrieve the necessary data to perform its tasks? I feel like I might be missing a step.

Here’s what I’m trying to achieve:

1. Extract data from an Excel file, such as container number, expected arrival date, and planned date.

2. Iterate over each container to set a planned date.

Right now, I’m struggling to even get consistent data retrieval working.

Any advice would be appreciated!

---

_[View the full topic](https://community.crewai.com/t/agent-and-ms-excel-files-read-and-write/6540)._