One way that has worked for me is to first, save you're data in a table format (Collections).
Then add an export button by, Insert>Controls>Export , and place it somewhere on the screen.
Select the Export Button, and under its property, find the one that says "Data". Then type the name of the Collections who want to export . If confused Read Step 6 here.
What this does is exports the Collection as a zip file, and in the zip file will be an xml file with you're information.
So if you have some data you export:
1. extract the files on you're computer.
2. Open up excel, click Data>GetData>FromFile>FromXML And select the extracted file and hit import.
3. Excel will try to show a preview (might not work), but in the Left Navigator column there should be a table, might be named data. If there is a drop down, click on it and select the table underneath it (might be labeled "Row"). Highlight that and click on Edit.
This should give you a preview of the table that will be inserted to excel. I found that instead of spaces, it added a %20 , so to fix that highlight the whole table, under Transform, select Replace Values > and replace the %20 with a space.
After that, hit "Close and Load", and now there should be a new table in you're excel.
Edit: Clarified Step 3.
