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:
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.
- Related articles
- Mom, I want to say thank you for writing an 800-word letter.
- Is Liaoshen Bank worth going to?
- 202 1 Shenzhen Futian Digital RMB Red Packet Usage Rules-Application Conditions
- What if my first girlfriend ignores me?
- How to set the dialogue window for Red Rice 2 SMS?
- How to delete group chats on iPhone 13 that are more than an hour old
- I just deleted your WeChat. What should I do to receive your message?
- There is interesting information there.
- Sending an activation short message to the gateway
- Why does Ryan like Spongebob?