Parse XML list into separate rows in excel

Questions & Answers
1

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!

3

Hi @Jentuck70,

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

1 Like
4

XML looks like this

<?xml version="1.0" encoding="UTF-8"?> string
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”: [
“RM0020”,
“RM0021”,
“RM0028”,
“RM0030”,
“RM0040”,
“RM0050”,
“RM0051”,
“RM0060”,
“RM0153”,
“RM0154”,
“RM0155”,
“RM0165”,
“RM0166”,
“RM0170”,
“RM0171”,
“RM0172”,
“RM0180”,
“RM0181”,
“RM0182”,
“RM0183”,
“RM1672”,
“RM1673”,
“RM1674”,
“RM1676”,
“RM1681”,
“RM1691”,
“RM1693”,
“RM1811”,
“RM1822”,
“RM1824”,
“RM1856”,
“RM1857”,
“RM1865”,
“RM1882”,
“RM1891”,
“RM2900”,
“RM3700”,
“RM3703”,
“RM3704”,
“RM3705”,
“RM3706”,
“RM3707”,
“RM3708”,
“RM4352”,
“RM4354”,
“RM4355”,
“RM4360”,
“RM4366”,
“RM4369”,
“RM4370”,
“RM4371”,
“RM4374”,
“RM4375”,
“RM4376”,
“RM4377”,
“RM4378”,
“RM4379”,
“RM4380”,
“RM4382”,
“RM4385”,
“RM4386”,
“RM4401”,
“RM4402”,
“RM4412”,
“RM4413”,
“RM4414”,
“RM4417”,
“RM4436”,
“RM4438”,
“RM4439”,
“RM4455”,
“RM4456”,
“RM4459”,
“RM4460”,
“RM4461”,
“RM4462”,
“RM4466”,
“RM4468”,

5 
<?xml version="1.0" encoding="UTF-8"?>
<ProductCodeResponse>
  <responseStatus type="OK"/>
  <errors/>
  <codes>
    <code>RM0020</code>
    <code>RM0021</code>
    <code>RM0028</code>
    <code>RM0030</code>
    <code>RM0040</code>
    <code>RM0050</code>
    <code>RM0051</code>
    <code>RM0060</code>
    <code>RM0153</code>
    <code>RM0154</code>
    <code>RM0155</code>
    <code>RM0165</code>
    <code>RM0166</code>
    <code>RM0170</code>
    <code>RM0171</code>
    <code>RM0172</code>
    <code>RM0180</code>
    <code>RM0181</code>
    <code>RM0182</code>
    <code>RM0183</code>
    <code>RM1672</code>
    <code>RM1673</code>
    <code>RM1674</code>
    <code>RM1676</code>
    <code>RM1681</code>
    <code>RM1691</code></codes>
	
</ProductCodeResponse>
6

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

7

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: