Export data in DataPage to a normal xls file, not xml or csv with quotation marks.
Hello,
In Caspio there is an option to export data from DataPage to an xml and csv file.
But such export is of little use, because if I would like to make nicer data prints using mail merge, MS Word does not read data from an XML file only from xls. The csv file is also not read because the data is in quotation marks ("data"). For mail merge, both xml and csv files are useless.
Can you think of exporting data to a regular xls file?
Greetings,
Mirosław RUS
Poland
-
OIR commented
You can use Excel's PowerQuery to extract the data out of the XML file. It's a bit tedious, but once it's been set up, it works pretty well.
-
Floris commented
I strongly support this suggestion, as I want to use the xls download as a feed to SAP