How to convert salesforce xml data export to json
- Step 1Run a Salesforce data export — In Salesforce Setup, go to Data →’ Data Export and request a full or incremental export. Download the ZIP archive and extract the XML file for the object type you want — Account.xml, Contact.xml, Opportunity.xml, etc.
- Step 2Upload the XML to the converter — Drop the XML file into the tool. The converter reads the root records element and maps each child element to a JSON object in an array, one object per Salesforce record.
- Step 3Review field names and inferred types — Check that 18-character Salesforce ID fields are strings, date fields are ISO-8601 strings, and currency fields are numbers. Adjust the type-inference settings if any field is misdetected.
- Step 4Download and load into your pipeline — Save the JSON and load it into pandas with pd.read_json(), upload it to an S3 stage for Snowflake COPY INTO, or pass it to your ETL tool's JSON data source connector.
Frequently asked questions
How do Salesforce relationship (lookup) fields appear in the JSON?+
Lookup fields in Salesforce XML appear as nested elements — for example <Account><Name>Acme</Name><Id>001...</Id></Account>. The converter flattens these to Account_Name and Account_Id by default, or uses dot notation (Account.Name) if you prefer the lookup prefix style.
My export ZIP contains XML files for dozens of object types. How should I work through them?+
Convert each object's XML file separately and name the resulting JSON file after the Salesforce object — Account.json, Contact.json, Opportunity.json. This keeps the mapping auditable and allows you to import objects in the correct order to resolve foreign-key references.
Is the Salesforce CRM data safe in the browser?+
Yes. Conversion is entirely client-side using fast-xml-parser. CRM records, pipeline revenue, and contact information in the XML are never transmitted to JAD Apps servers.
Privacy first
Conversion runs locally in your browser. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.