Add export in Excel XLS format and/or CSV
Wild Apricot uses XML Spreadsheet format forimport and export. It can be opened in MS Excel 2003 and higher orExcel for Mac 2004 or higher. It also can be opened in some free Officesoftware like StarOffice.
Using 'old' XLS format instead to be compatible with old version of Microsoft Excel and other spreadsheet software.
Released in 5.2
Jeanne Hoffman commented
Is there a simple way to convert the "member since" column to a sortable date field after exporting to excel? Due to the field settings, I can't just select the column and convert it to a different date format.
"Add export in Excel XLS format and/or CSV" implemented in 5.2 release on December 10, 2014. See 5.2 release description http://help.wildapricot.com/display/DOC/Release+5.2 for details.
Question for anyone now. I use Excel 2013 on my PC to open the xml file as a spreadsheet.....that works fine. But on my android I can't find an app to open the xml file as a spreadsheet. Tried Sheets, Quickoffice and Office Mobile....none will open the xml file. Anyone know an app that works?
Date changed - now it's December. The most recent updates on current development status can be found in our Roadmap, see http://forums.wildapricot.com/forums/308932-wishlist/suggestions/8827717-roadmap-2015-plans-releases-expected-dates
Probably - depends on our development speed. Can be beginning of November.
Use this thread to track our most recent status on development - http://forums.wildapricot.com/forums/308932-wishlist/suggestions/8827717-roadmap-2015-plans-releases-expected-dates
This will be fantastic! So, we should be looking for this sometime in October 2014?
I want to share our progress with you. Click the image below for a sneak preview of of export changes we are working on right now:
This feature will be included in version 5.2 - see our Roadmap http://forums.wildapricot.com/forums/308932-wishlist/suggestions/8827717-roadmap-2015-plans-releases-expected-dates . Feel free to share your comments here, in this forum thread.
when your system cannot read the xml export, is this what everyone is getting?
<?xml version="1.0"?><?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel"><Styles>
We are a small membership organization and most of our nonprofit board members are non familiar with the XML format. Would like to see this exporter support .xls and .csv. Seems like a lot of people are asking for it.
Except i dont think the CVS exports from SQL include the passwords or hached phrase either.
But keep in mind that most SQL databases do have an option to export to CSV so there is no reason you couldn't just use our regular CSV import to import your membership data (including their passwords).
See "Passwords" under http://help.wildapricot.com/display/DOC/Import+field+guide
No SQL database, correct.
I dont suppose there is a way to import an existing SQL database? I hate to have to start over collecting new passwords from membership!
We usually do not give updates on the possible release date - too many factors that can change this date. But I can tell, that we made thorough analysis and design and the feature is ready for development. There are good chances for next year.
Shelbi Hoffman commented
I have many clients using a older versions of Excel. Having the ability to export to CSV would be very beneficial. Any updates on when this feature may be added?
This discussion seems to have been running for several years, when can we expect to have ability to export contacts etc as CSV, XLS, ODS etc as well as the ability to select which fields to export
Please provide something OTHER than the proprietary MS Excel XML format!
Like: XML, CSV, XLS, JSON, tab-delimted, etc….
PLEASE provide export in some (or all) of these formats:
XML, CSV, XLS, JSON, Tab-delimited
Any of these would be better than the proprietary Excel XML/XLS format of today.
Thanks for the workaround, Jessica. Still this is in a queue for now, sorry.
However, I finally got them to work in OpenOffice by changing the filenames from xxxx.xml.xls to just xxxx.xml. I then opened them and saved them as .xls files. I'm glad I have a workaround but there really should be a more straightforward way. Many people do not have MS Office.