Skip to content
NewAI dashboards.See how →
Open MammothTry free
Free · Runs in your browser

XML to Excel converter

Turn an XML file into an Excel spreadsheet. Repeated elements become rows, and your file never leaves your browser.

Works with
XMLXLSXCSV
Opens inExcelGoogle Sheets

Drop an XML file here

Any XML file, up to 100 MB. It stays on your computer.

  • No sign-up
  • Nothing uploaded
  • Excel or CSV
  • Arla Foods logo
  • Bacardi logo
  • British American Tobacco logo
  • Everest Detection logo
  • Golden Acre logo
  • Handlangers logo
  • Inspired Learning Group logo
  • Kantar logo
  • MUFG logo
  • NielsenIQ logo
  • PTI Digital logo
  • RethinkFirst logo
  • Starbucks logo
  • The Specialist Works logo
What you get

A clean spreadsheet from your XML, made on your computer.

  • Your file stays on your computer

    The spreadsheet is built in your browser. Nothing is sent to Mammoth or anyone else.

  • Attributes become columns

    An attribute like id="1041" gets its own column, next to the child elements.

  • Numbers stay numbers

    Values that look like numbers arrive as numbers. Codes with a leading zero stay as text.

How it works

How to convert XML to Excel

The converter finds the element that repeats, gives each one a row, and gives every child element and attribute a column.

  1. 1

    Add your XML

    Drop an .xml file on the box, choose one, or paste the XML in.

  2. 2

    Check the table

    A preview shows the rows and columns the file will have.

  3. 3

    Download

    Save it as an Excel file, or as a CSV if that is what you need.

Your options

Other ways to do it

Excel can import XML itself, with a few more clicks.

  • Excel's Power Query

    A file you refresh often

    • Finds the repeating rows for youPartly
    • Flattens nested elementsPartly
    • Ready in one stepNo
    • Refreshes when the file changesYes

  • Copy and paste

    A few short records

    • Finds the repeating rows for youNo
    • Flattens nested elementsNo
    • Ready in one stepNo
    • Refreshes when the file changesNo
  • This page

    This converter

    One-off files, deep nesting

    • Finds the repeating rows for youYes
    • Flattens nested elementsYes
    • Ready in one stepYes
    • Refreshes when the file changesNo
In Excel itself

How to import XML into Excel with Power Query

Excel for Windows can open an XML file without a converter. It works best on flat files, and nested elements need expanding by hand.

Use Power Query when you want the workbook to refresh from the same file. Use the converter above for a one-off file, or when the XML is nested several levels deep.

  1. 1

    Open a blank workbook and go to Data > Get Data > From File > From XML.

  2. 2

    Pick your .xml file. The Navigator lists the tables Excel found in it.

  3. 3

    Select the table that holds your records. A preview shows on the right.

  4. 4

    Select Load to put it on a sheet, or Transform Data to expand nested columns first.

Your file stays private

The converter runs inside this page. Your XML is read and turned into a spreadsheet on your computer, and nothing is sent to Mammoth. That makes it safe for exports with customer or invoice data in them.

How we handle your data

Once the page has loaded, it works with your internet switched off.

Every month

Converting XML exports every month?

Mammoth can take it from there. Put the converted Excel files in a folder and their rows are added to one table automatically.

Try Mammoth free

Supplier invoices

Septemberinvoices-sep.xlsx
Octoberinvoices-oct.xlsx
Novemberinvoices-nov.xlsx
DriveDropboxOneDriveSFTP
All invoicesUp to date
Sep 05Nordic Paper1,240.00
Sep 19Lisbon Freight860.50
Oct 03Nordic Paper1,180.00
Nov 07Atlas Office312.75
Nov 14Lisbon Freight905.20

Illustration. Every new file in the folder is added to the same table.

Questions

XML to Excel questions

Is my XML uploaded anywhere?
No. The page reads the file and builds the spreadsheet inside your browser. Once the page has loaded, it works with your internet switched off.
Will Excel open an XML file on its own?
Yes. Excel for Windows imports XML through Data > Get Data > From File > From XML. The steps are above. This converter is quicker when the file is deeply nested.
Is XML the same as XLSX?
No. XML is a text format for structured data. XLSX is Excel's own file format, which stores its sheets as XML inside a zip file. This page turns the first into the second.
Which part of my XML becomes the rows?
The element that repeats most, such as each order inside an orders element. The table tells you which element it used.
What happens to attributes and nested elements?
Both become columns. Nested elements get dotted names, like customer.name. An element that repeats inside a row, such as several tag elements, shares one cell, separated by commas.
How big a file can it convert?
Up to 100 MB. Excel holds up to 1,048,576 rows and 16,384 columns per sheet, and the converter tells you if your data goes past either.
Is it free?
Yes. There is no account and no email to give.

More free tools

Free toolXML to CSVThe same converter, with a CSV file as the result.Take a lookFree toolJSON to ExcelTurn a JSON file into an Excel sheet.Take a lookFree toolMerge Excel filesCombine several spreadsheets into one table.Take a look