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:
- 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.
(Untested, but steps should be similar to this:)
- Click Data tab
- Click Get
- Click From File - XML
- Maybe set some options
- Click Load