Parse XML list into separate rows in excel

I am using the parse xml module connected to excel to create a new excel row with the parsed data. The data is a comma delimited list. The row created in excel is the entire list. I would like to create one row per list item. How would I do this? I am looking into the map tool but I’m not quite sure how to use it.
Thank you!

Hi @Jentuck70,

Can you share how your XML looks like and also what is the current output of Parse XML module is.

1 Like

XML looks like this

<?xml version="1.0" encoding="UTF-8"?> string
string string string string string

It’s an extremely long list, like over 30,000 items so the bundle is very large and keeps freezing on the screen when I try to download it.
Here is some of it:

“ProductCodeResponse”: {
“responseStatus”: [
“_attributes”: {
“type”: “OK”
“errors”: [
“codes”: [
“code”: [

<?xml version="1.0" encoding="UTF-8"?>
  <responseStatus type="OK"/>

I added an iterator and it seemed to work. I think it’s going to take forever though! Hopefully it doesn’t time out!

Heya @Jentuck70 happy Friday :wave:

I just wanted to say a quick thanks for sharing what worked for you. It’s great to hear that the iterator is doing its job!

Just FYI: I’ve marked your last reply as a solution so that we keep the forum structured and tidy :white_check_mark: :broom: