Joke Collection Website - Public benefit messages - How to convert XML data to CSV?

How to convert XML data to CSV?

It’s actually quite troublesome. The easiest thing is to give me the CSV file and I will convert it for you.

The specific process must be done in Excel.

1. First create an XML file as the mapping source. The XML file is as follows:

< p>

< p>Save this XML file to disk.

2. Open the CSV file in Excel. On the menu or tab, in the Developer Tools, XML group, click Source.

3. Click "XML Mapping", click "Add" in the dialog box that appears, and select the newly generated XML file above.

4. Then click "OK", and the XML hierarchy will be displayed on the right.

5. Select temp in the structure, and then drag it directly to the first row of data in the CSV table. Notice that the entire table is now selected.

6. Click "Development Tools", "XML", "Export" on the menu or tab.

Then save it just like a file.