# Bulk load of excel sheet with empty worksheet

**URL:** <https://forum.knime.com/t/bulk-load-of-excel-sheet-with-empty-worksheet/43934>\
**Category:** KNIME Analytics Platform\
**Tags:** excel\
**Created:** [June 8, 2022, 1:48pm UTC](https://forum.knime.com/t/bulk-load-of-excel-sheet-with-empty-worksheet/43934 "2022-06-08T13:48:46Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [June 8, 2022, 2:42pm UTC](https://forum.knime.com/t/bulk-load-of-excel-sheet-with-empty-worksheet/43934/2 "2022-06-08T14:42:05Z")

</div>

@MarekV if you take a look at this example with your files the empty entry is being skipped.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/3/2/323c7bb7794025ab771ac40a9e985296f5aac1c4.png)

You can configure what the reader would consider as a missing entry and skip it if you want.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/b/a/baa31879277b7cdf888c2ca3f2dbf41a1dc87b69.png)

> **[Bulk load Excel sheets and files - forum question (43934) – mlauber71](https://hub.knime.com/mlauber71/spaces/Forum/latest/2022/kn_forum_43934_excel_bulk_import~DKwPeQLkq6JTmssZ)**
>
> Bulk load Excel sheets and files - forum question (43934)

If you still have duplicates you can further elevate them with the [Duplicate Row Filter](https://kni.me/n/SQUECT-F0VhUjdbf) or [advanced techniques](https://forum.knime.com/t/school-of-duplicates-and-how-to-deal-with-them/24164).

[kn\_forum\_43934\_excel\_bulk\_import.knwf](https://forum.knime.com/uploads/short-url/bjNdmmGMH8SVfwTTopsduAATlA6.knwf) (51.2 KB)

---

_[View the full topic](https://forum.knime.com/t/bulk-load-of-excel-sheet-with-empty-worksheet/43934)._