# Rasa data extraction from excel sheets

**URL:** <https://forum.rasa.com/t/rasa-data-extraction-from-excel-sheets/47142>\
**Category:** Getting Started with Rasa\
**Created:** [August 23, 2021, 6:45pm UTC](https://forum.rasa.com/t/rasa-data-extraction-from-excel-sheets/47142 "2021-08-23T18:45:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![SyedBilalHasan](https://avatars.discourse-cdn.com/v4/letter/s/b782af/32.png) [@SyedBilalHasan](https://forum.rasa.com/u/SyedBilalHasan)\
**Post date:** [August 23, 2021, 6:45pm UTC](https://forum.rasa.com/t/rasa-data-extraction-from-excel-sheets/47142/1 "2021-08-23T18:45:56Z")

</div>

Hello everyone , hope your doing great . I had devloped an action to extract data from an excel file using the openpyxl module and bring the data into rasa. But there is a problem which is that whenever i try to run this action it causes problems like the error mentioned here :

2021-08-23 22:33:59 INFO rasa\_sdk.endpoint - Starting action endpoint server… 2021-08-23 22:33:59 ERROR rasa\_sdk.executor - Failed to register package ‘actions’. Traceback (most recent call last): File “C:\Users\Syed Mohammed Bilal\anaconda3\envs\rasa\_install\_demo\lib\site-packages\rasa\_sdk\executor.py”, line 262, in register\_package self.\_import\_submodules(package) File “C:\Users\Syed Mohammed Bilal\anaconda3\envs\rasa\_install\_demo\lib\site-packages\rasa\_sdk\executor.py”, line 225, in \_import\_submodules self.\_import\_module(full\_name) File “C:\Users\Syed Mohammed Bilal\anaconda3\envs\rasa\_install\_demo\lib\site-packages\rasa\_sdk\executor.py”, line 239, in _import\_module module = importlib.import\_module(name) File "C:\Users\Syed Mohammed Bilal\anaconda3\envs\rasa\_install\_demo\lib\importlib\_init_.py", line 127, in import\_module return \_bootstrap.\_gcd\_import(name[level:], package, level) File “”, line 1014, in \_gcd\_import File “”, line 991, in \_find\_and\_load File “”, line 975, in \_find\_and\_load\_unlocked File “”, line 671, in \_load\_unlocked File “”, line 783, in exec\_module File “”, line 219, in \_call\_with\_frames\_removed File “C:\Users\Syed Mohammed Bilal\anaconda3\envs\rasa\_install\_demo\chatbot\actions\actions.py”, line 11, in from openpyxl import Workbook , load\_workbook ModuleNotFoundError: No module named ‘openpyxl’ This error appeared when i typed rasa run actions on a different anaconda prompt rather than on the one through which i was talking to my bot. Can someone help me solve this error? Thanks

---

<div class="post-metadata">

**Author:** ![ChrisRahme](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/chrisrahme/32/15572_2.png) [@ChrisRahme](https://forum.rasa.com/u/ChrisRahme)\
**Post date:** [August 23, 2021, 7:00pm UTC](https://forum.rasa.com/t/rasa-data-extraction-from-excel-sheets/47142/2 "2021-08-23T19:00:13Z")

</div>

Make sure you installed the module in the same virtual environment as Rasa

---

<div class="post-metadata">

**Author:** ![nik202](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/nik202/32/16098_2.png) [@nik202](https://forum.rasa.com/u/nik202)\
**Post date:** [August 23, 2021, 8:16pm UTC](https://forum.rasa.com/t/rasa-data-extraction-from-excel-sheets/47142/3 "2021-08-23T20:16:41Z")

</div>

@SyedBilalHasan install `pip install openpyxl` in your conda virtual environment for actions.py file.