# how to convert xml to table

**URL:** <https://forum.knime.com/t/how-to-convert-xml-to-table/11743>\
**Category:** KNIME Analytics Platform\
**Created:** [August 2, 2018, 10:40am UTC](https://forum.knime.com/t/how-to-convert-xml-to-table/11743 "2018-08-02T10:40:58Z")\
**Posts on this page:** 1\
**Showing post:** 9

<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:** [August 3, 2018, 7:00am UTC](https://forum.knime.com/t/how-to-convert-xml-to-table/11743/9 "2018-08-03T07:00:05Z")

</div>

Could you try converting it to JSON before extracting it? Could be worth a try.

> [@Problems with parsing a XML-like file](https://forum.knime.com/t/problems-with-parsing-a-xml-like-file/11463/4):
>
> I attach a workflow that extracts your values. I converted the XML file to JSON and then used the JSON path editor to define a path. The tricky thing is to find the path. That took some time. I exported the JSON file and used an editor (Atom on MacOS) to find the right row. Then you would have to click on an item you want and hopefully it would select and mark blue the values you want. I am not a JSON expert so I would have to click around until it fits. Then the workflow would ungroup the valu…

---

_[View the full topic](https://forum.knime.com/t/how-to-convert-xml-to-table/11743)._