How to Import Multiple XML Files into Excel

Need to combine multiple XML files into one Excel sheet?

[{"selector":"#anim-a9fd4a74-9ec2-4e44-be19-ed6595cb81f2","keyframes":{"transform":["translate3d(114.51104%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2b1c9218-9631-4986-b81d-615bf5616e73","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c77b7d92-d64b-488e-962d-367070599509","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-0497962d-cb30-4ac9-be0a-7d07e26506d0","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e4ac9f3b-a77d-445f-b7bf-7f99dc5f18c0","keyframes":{"transform":["translate3d(-112.72727%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2c3fdbb0-40a6-45ff-91ca-fc4492a70157","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-033ea96f-e6f9-40bf-9e14-7678e9c349f0","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-a20cd1d9-cc33-4ee5-83ec-c2b4af82b9fd [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(-1.0302869668521453e-13%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Here’s the easiest way to do it!

Gather Your XML Files

[{"selector":"#anim-23a8663e-643f-4835-b4e4-e7bd75bd3b06","keyframes":{"transform":["translate3d(115.55555%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1df1dc2e-5be9-4c38-b279-1dc68c831522","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3db5cca3-2954-4239-bb4d-fe4f2e650766","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-d140e881-0eec-4b71-a915-44bd96b4965c","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-cc0cb01e-29cd-41d5-962e-e59db747b5c8","keyframes":{"transform":["translate3d(-121.3793%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-72871f35-4839-4e6c-9c45-ce1a9164e486","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-92096754-b5ca-4a09-bef1-f80c5ccb8d0e","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-c730cda5-0ba6-4cff-9733-48fd408fe892 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(-1.0302869668521453e-13%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Keep all XML files you want to import in one folder.

Open Excel

[{"selector":"#anim-baa4f05b-3fae-49ad-a382-bddebacfd6dc","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2ade2482-b3f4-43a7-889b-cfb1703a83f9","keyframes":{"transform":["translate3d(112.93375%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f4290173-a30c-4010-9af0-7d0ab933fb3f","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f751ab4b-6d97-4da7-93f4-79417e375bfd","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-a55b29c4-f5b5-4e8b-8327-35eb465a6eed","keyframes":{"transform":["translate3d(-115.14196%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3132ec9f-e1cb-4b08-b9e0-f07c78d519ef","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-594e6abd-8cc6-41ae-9786-89b4067c304f","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-3286e9ba-490f-4e06-a6d4-9b045642f39d [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(-1.0302869668521453e-13%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Go to Data tab > Click Get Data > From File > From Folder .

Select the Folder

[{"selector":"#anim-b5da61df-29c3-42e4-98ea-0ce3960d6d29","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6086d8da-cf7f-4842-9f2d-3f1c1728e97f","keyframes":{"transform":["translate3d(115.28663%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7622ff51-eb82-4c5b-ae50-1e2cd1425947","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-08335458-6132-40d1-b467-1b5c15d14310","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-5deea3af-4883-474c-8912-2fe79de310c7","keyframes":{"transform":["translate3d(-117.82179%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4f78cdc1-51e5-4f52-a03c-bbfef1479ab6","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f67d3081-afac-42e3-9c3e-40bbbca266ac","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-b84ff9eb-0215-4547-9bbf-a3b064cb323a [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(-1.0302869668521453e-13%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Choose the folder where your XML files are stored, then click Open .

Combine and Transform

[{"selector":"#anim-e0c72b0b-602d-4341-b2be-9ca97813afb5","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-90317ab6-3bce-4796-9af0-1f2c366c698f","keyframes":{"transform":["translate3d(114.96816%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1d3080a7-90bd-4007-af04-b57f8cf2c449","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0484deda-0288-4283-9037-c6de51979ba8","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-615ad0a5-983e-43c6-a8e8-117ab87b4e56","keyframes":{"transform":["translate3d(-118.81188%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-cddf8fc9-1c69-4253-9ea4-b26957ada624","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1e065a95-442a-4b07-9892-d8af84578ff7","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-f7df16c7-171e-4a45-b0e9-00cb85438a56 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(-1.0302869668521453e-13%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Excel will list all files. Click Combine & Transform Data to load them together.

Clean & Format Data

[{"selector":"#anim-b4cebec4-c702-4e48-82f2-6c025f8a22d1","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c24e5352-df68-4ee0-8d9c-56bce53f7457","keyframes":{"transform":["translate3d(114.96816%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0934f69d-d448-4c00-b2fb-fa58f5bcc4a4","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b71e23a9-cc5b-4fb5-85ed-7fbff915b730","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-59190551-bcf4-4bf8-b9d9-20443da63cf3","keyframes":{"transform":["translate3d(-118.48184%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ae2c0663-36e9-49de-913c-a331206eee68","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-04feb969-01a2-44b5-b261-6dc553c8ecd3","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-a8c61d8d-a62f-4b65-9d06-f207fcdcf864 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(-1.0302869668521453e-13%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Use the Power Query Editor to arrange or filter your XML data before loading it.

Load to Worksheet

[{"selector":"#anim-3b96b63a-6825-4415-bd18-e3383f7ad551","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-cc4148be-1e15-4e2c-ba0d-0a6589540818","keyframes":{"transform":["translate3d(116.87898%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5e0ce966-9a02-4b80-b726-5a24d4fccb87","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ec0b0018-3f21-45d3-9fad-d3b1a9a05823","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-8a946195-663f-4929-b338-9266fa998158","keyframes":{"transform":["translate3d(-118.48184%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c3587642-c7e4-4e5c-9307-393034f96ea6","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-fb78b71b-a95a-41af-8647-2a361ad8aab7","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-c2bccadf-0ed8-473f-8d56-880750be1e38 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(-1.0302869668521453e-13%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Click Close & Load — your combined XML data will appear in Excel!

Mac Tricks You’ll Wish You Knew Earlier

[{"selector":"#anim-ca4a8cf4-45fe-4744-856e-f57828b38326","keyframes":{"transform":["translate3d(126.39405%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-71fa6c36-42b9-49c2-8ff2-ecb8d32fc29e","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-24ce78f4-fc36-410d-a26c-e997b608ab06","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-90cb6bb9-7ed8-4295-a5ff-b42eac58b8f1","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6b164212-174c-43a3-a6c4-a3424fcb8914","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0b3116d7-db2d-4bb0-90f4-bc8059d31b5e","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d6a93882-fc50-4790-84d2-b558636b3b63","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] Read More Web Stories Check More Stories

SHOP NOW

[{"selector":"#anim-c302067b-08ea-4e64-829b-611e71cce6c6","keyframes":{"transform":["scale(1)","scale(1.5)","scale(0.95)","scale(1)"],"offset":[0,0.33,0.66,1]},"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-ddc3209a-08e1-43ff-881b-adcd6ad7476f","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-cb8cbf27-6208-4033-9af5-be0dc1010cbb","keyframes":{"transform":["translate3d(0px, -990.68126%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Indigo Software Company: Your Gateway to Affordable Microsoft Solutions Learn more