# Fingerprints export to csv file

**URL:** <https://forum.knime.com/t/fingerprints-export-to-csv-file/40893>\
**Category:** Cheminformatics\
**Created:** [March 20, 2022, 11:44am UTC](https://forum.knime.com/t/fingerprints-export-to-csv-file/40893 "2022-03-20T11:44:25Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Razanknime\_123](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/r/839c29/32.png) [@Razanknime\_123](https://forum.knime.com/u/Razanknime_123)\
**Post date:** [March 20, 2022, 11:44am UTC](https://forum.knime.com/t/fingerprints-export-to-csv-file/40893/1 "2022-03-20T11:44:25Z")

</div>

Hello!  
I have calculated fingerprints using RDKIT fingerprints but when using excel writer to export them i cant because theyre bit-vectors. Is there any way to export the fingerprints columns calculated into an excel sheet?

Thank you in advance

---

<div class="post-metadata">

**Author:** ![aworker](https://forum-cdn.knime.com/user_avatar/forum.knime.com/aworker/32/36421_2.png) [@aworker](https://forum.knime.com/u/aworker)\
**Post date:** [March 20, 2022, 12:18pm UTC](https://forum.knime.com/t/fingerprints-export-to-csv-file/40893/2 "2022-03-20T12:18:18Z")

</div>

Hi @Razanknime_123

Sorry I do not have access to the computer to send you a workflow example right now. You would just need to convert the bit vector column into string format before sending it to the -CSV writer- node. Only double check after conversion that the generated strings are of same length as your bit vector, i.e same number of bits. You could do the conversion using the rename column node and chosing string as new type.

Hope it helps.

Best  
Ael

---

<div class="post-metadata">

**Author:** ![Razanknime\_123](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/r/839c29/32.png) [@Razanknime\_123](https://forum.knime.com/u/Razanknime_123)\
**Post date:** [March 20, 2022, 1:52pm UTC](https://forum.knime.com/t/fingerprints-export-to-csv-file/40893/3 "2022-03-20T13:52:28Z")

</div>

It worked! Thank you

---

<div class="post-metadata">

**Author:** ![aworker](https://forum-cdn.knime.com/user_avatar/forum.knime.com/aworker/32/36421_2.png) [@aworker](https://forum.knime.com/u/aworker)\
**Post date:** [March 20, 2022, 3:09pm UTC](https://forum.knime.com/t/fingerprints-export-to-csv-file/40893/4 "2022-03-20T15:09:04Z")

</div>

My pleasure to help.

Best  
Ael

---

<div class="post-metadata">

**Author:** ![Vernalis](https://forum-cdn.knime.com/user_avatar/forum.knime.com/vernalis/32/356_2.png) [@Vernalis](https://forum.knime.com/u/Vernalis)\
**Post date:** [March 21, 2022, 8:52am UTC](https://forum.knime.com/t/fingerprints-export-to-csv-file/40893/5 "2022-03-21T08:52:55Z")

</div>

There are various fingerprint convertor nodes in the Vernalis community plugin which should be able to convert the fingerprints into a form which can be written in Excel.

Steve