XML to Spreadsheet: Difference between revisions

Latest revision as of 15:06, 8 December 2023

Our invoices are available as xml and json for machine processing, as well as the more usual pdf files.

We have been asked how to import xml invoices in to a spreadsheet program like Excel or LibreOffice. This can be useful especially for invoices with phone call charges listed in them.

here are some steps in importing xml files:

LibreOffice Calc

Go to: Data - XML Source.
Pick the xml file
Set Mapped cell: a1
Click import

All line items are listed in a flat sheet, but you can cut out the stuff you don't want to process and leave yourself with just the telephone calls, if that's what you're after.

Microsoft Excel

(Untested, but steps should be similar to this:)

Click Data tab
Click Get
Click From File - XML
Maybe set some options
Click Load

@@ Line 1: / Line 1: @@
 <indicator name="Front">[[File:Menu-document.svg|link=Category:Technical Documents|30px|Back up to the Technical Documents category]]</indicator>
-Our invoices are available as xml as well as the more usual pdf files.
+Our invoices are available as xml and json for machine processing, as well as the more usual pdf files.
 We have been asked how to import xml invoices in to a spreadsheet program like Excel or LibreOffice. This can be useful especially for invoices with phone call charges listed in them.