...
Sets that are all being loaded into the same collection can be combined. Multiple My Library files can be combined by copying everything from the first <record> tag to the last </record> tag, and pasting it into another My Library file after the <records> tag. They can also all be combined by loading them all into Zotero and then exporting them. Note that sets can also be combined in Excel later by adding the contents of one spreadsheet to another.
Find and replaced all instances of </author> with ||</author>
Find and replaced all instances of </keyword> with ||</keyword>
Use EditX to transform the xml using this XSLT file:
Download the current version of the xslt to your computer if you don’t already have it.
Open EditX
Go to file and open document
Use the drop down next to file type to select xslt 2.0 documents
Select the current version of the xslt:
View file name zotload2.0.xslt Go to XSLT/Xquery and select Transform using XSLT
The top box should have the name of the XSLT file already filled in. If not, find and select it.
In the middle box, find and fill in the file that you need to transform.
In the last box, select where you want the file to go to, and type in a file name that ends in .xml.
Click Ok
Open the resulting file in Notepad do the following
Find all instances of 
 and replace with nothing
Find all instances of   and replace with nothing
Find all instances of &amp; and replace with &
Find all instances of &nbsp; and replace with (1 blank space)
Find all instances of ||< and replace with <
Open a blank Excel spreadsheet. If you don’t see the developer tab, go to file, options, customize ribbon, and under main tabs, select the developer tab. Go to Developer, import, and select your XML file. Click ok. Ensure the next box say $A$A, then click ok.
Add the headers:
View file name Headers1.2.xlsx Check for any missing URLs in the dc.description.uri column and fill in any that are missing with publisher’s URL. If unpublished, give the URL where the work is available..
...