Exporting your Excel spreadsheet into structured data (XML)

    • Martyn Double |
    • 0 step |
    • 2 minutes
      Heads Up! XML export from Excel is limited to 65,536 rows. Check out this guide for other options - [https://support.microsoft.com/en-us/office/export-xml-data-0b21f51b-56d6-48f0-83d9-a89637cd4360](https://support.microsoft.com/en-us/office/export-xml-data-0b21f51b-56d6-48f0-83d9-a89637cd4360)
      Open Excel
      Create "Blank workbook"
      Click on the "Developer" tab
      Heads Up! If you do not see the "Developer" tab, follow this guide to add to your Excel ribbon - [https://support.microsoft.com/en-us/office/import-xml-data-6eca3906-d6c9-4f0d-b911-c736da817fa4](https://support.microsoft.com/en-us/office/import-xml-data-6eca3906-d6c9-4f0d-b911-c736da817fa4)
      Click "Source" under the "Developer" tab
      Create your Imagen XML schema - Check out this guide for more information on the Imagen record schema [https://knowledge.imagen.io/mapping-files-and-imagen-xml-schema](https://knowledge.imagen.io/mapping-files-and-imagen-xml-schema)
      Copy and paste the <ImagenRecord> element so there are at least two nodes. Save your XML schema file
      Heads Up! Excel will only export multiple rows into your XML file if there are at least two child nodes <ImagenRecord> under the root node <Records>
      Click "XML Maps"
      Click "Add" and select your XML schema
      Click "OK" to acknowledge that Excel will infer the schema from your XML file
      Click "OK" to close the dialogue window
      Click here:
      Right-click the root node to select "Map element"
      Select the columns to map to your XML schema. Select the top row only Click here:
      Populate the columns with some DATA
      Click "Developer"
      Click "Export"
      Your Imagen ready XML will now populate with data
      This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe