# Read 200 dataset and each one have txt file .

**URL:** <https://forum.knime.com/t/read-200-dataset-and-each-one-have-txt-file/87687>\
**Category:** KNIME Analytics Platform\
**Created:** [April 19, 2025, 12:28pm UTC](https://forum.knime.com/t/read-200-dataset-and-each-one-have-txt-file/87687 "2025-04-19T12:28:08Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aboodkun10](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/a/a8b319/32.png) [@Aboodkun10](https://forum.knime.com/u/Aboodkun10)\
**Post date:** [April 19, 2025, 12:28pm UTC](https://forum.knime.com/t/read-200-dataset-and-each-one-have-txt-file/87687/1 "2025-04-19T12:28:08Z")

</div>

hello everyone I have a project , the Professor give us a 200 excel sheets each sheet has a text file , we need to read all the sheets and make interactive dashboard with visualization , thank you all I hope anyone can help me .

---

<div class="post-metadata">

**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\
**Post date:** [April 19, 2025, 1:39pm UTC](https://forum.knime.com/t/read-200-dataset-and-each-one-have-txt-file/87687/2 "2025-04-19T13:39:59Z")

</div>

@Aboodkun10 welcome to the KNIME forum. You can take a look at these articles. First one about reading and handling Excel files.

> **[KNIME and Excel — An Overview of What You Can Do](https://medium.com/low-code-for-advanced-data-science/knime-and-excel-an-overview-of-what-you-can-do-c6d400319745)**
>
> Leverage you spreadsheets to the fullest with low-code automation

This one about Dashboards.

> **[Create an Interactive Dashboard with KNIME Components and Python](https://medium.com/low-code-for-advanced-data-science/create-an-interactive-dashboard-with-knime-components-and-python-41ef794b1467)**
>
> TL;DR: KNIME can be used to easily create dashboards which also let you download the results as individual PNG and Excel files

---

<div class="post-metadata">

**Author:** ![rfeigel](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/r/7ea924/32.png) [@rfeigel](https://forum.knime.com/u/rfeigel)\
**Post date:** [April 19, 2025, 3:05pm UTC](https://forum.knime.com/t/read-200-dataset-and-each-one-have-txt-file/87687/3 "2025-04-19T15:05:28Z")

</div>

@mlauber71 gave you some helpful general starting points. If you could provide more detail about your project you’d be more likely to get some specific help.

- Are the sheets all in one workbook?
- How do you plan to process the text files?
- What kind of visualization do you plan to do?

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [July 18, 2025, 3:06pm UTC](https://forum.knime.com/t/read-200-dataset-and-each-one-have-txt-file/87687/4 "2025-07-18T15:06:15Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
