XML to Spreadsheet

Back up to the Technical Documents category
From AAISP Support Site
Revision as of 15:05, 8 December 2023 by AA-Andrew (talk | contribs) (Created page with "<indicator name="Front">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. 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 == #...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)


Our invoices are available as xml 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

  1. Go to: Data - XML Source.
  2. Pick the xml file
  3. Set Mapped cell: a1
  4. 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:)

  1. Click Data tab
  2. Click Get
  3. Click From File - XML
  4. Maybe set some options
  5. Click Load