Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,696 questions
How to combine multiple .xml files of type spreadsheets into a single .xml file or single excel file using cmd or dos?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 38%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Shiva Sun
0
Reputation points
Hi,
How to combine multiple .xml files of type spreadsheets into a single .xml file or single excel file using cmd or dos?
For example if there are 10 .xml files having some 20 rows and 5 coulmns in each file, how do we combine all files into a single .xml file or a single .csv or a excel sheet ?
Thanks in advance.
Office
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,950 questions
Microsoft Configuration Manager Application
Microsoft Configuration Manager Application
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Application: A computer program designed to carry out a specific task other than one relating to the operation of the computer itself, typically to be used by end users.
490 questions
{count} votes
-
Jeff McCashland 476 Reputation points Microsoft Employee2024-04-09T02:50:55.91+00:00 Open Specifications tags are dedicated to supporting issues related to open specifications. You can find open specifications here https://docs.microsoft.com/en-us/openspecs/. Since your question does not pertain to one of these specifications, I've removed the openspecs tag.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jiajing Hua-MFST 10,560 Reputation points Microsoft Vendor2024-04-09T07:09:30.99+00:00 Hi @Shiva Sun
From the perspective of Excel, to merge multiple files, you can use Power Query: https://support.microsoft.com/en-us/office/import-data-from-a-folder-with-multiple-files-power-query-94b8023c-2e66-4f6b-8c78-6a00041c90e4
Sign in to comment
Sign in to answer