Title: [Plugin: Basic Google Maps Placemarks] Export to Excel Last modified: August 20, 2016 --- # [Plugin: Basic Google Maps Placemarks] Export to Excel * Resolved [firesitedesign](https://wordpress.org/support/users/firesitedesign/) * (@firesitedesign) * [13 years, 8 months ago](https://wordpress.org/support/topic/plugin-basic-google-maps-placemarks-export-to-excel/) * Our site under development is here: * [http://www.carolinasfirepage.com/gis](http://www.carolinasfirepage.com/gis/) * We have a need to capture our placemark data as a cvs or excel file. I know that we can Export from WordPress as an xml file. Is there a known converter after you have an xml file? * I have also checked into the database in mysql through myphpadmin. * It looks like wp_postmeta contains the data we are looking for, but it’s not easily accessed. * Any tricks for getting our existing placemarks into a simple xls or cvs file? * Thanks in advance. * [http://wordpress.org/extend/plugins/basic-google-maps-placemarks/](http://wordpress.org/extend/plugins/basic-google-maps-placemarks/) Viewing 10 replies - 1 through 10 (of 10 total) * Plugin Author [Ian Dunn](https://wordpress.org/support/users/iandunn/) * (@iandunn) * [13 years, 8 months ago](https://wordpress.org/support/topic/plugin-basic-google-maps-placemarks-export-to-excel/#post-3058868) * The placemarks are a custom post type, so they’re no different than regular WordPress posts, pages, etc. If you can find a plugin that converts post data to a CSV then that should work. * One problem is that the database form is [normalized](http://en.wikipedia.org/wiki/Database_normalization), though, so you might need a way to combine the wp_posts and wp_postmeta tables, depending on what you want. * Thread Starter [firesitedesign](https://wordpress.org/support/users/firesitedesign/) * (@firesitedesign) * [13 years, 8 months ago](https://wordpress.org/support/topic/plugin-basic-google-maps-placemarks-export-to-excel/#post-3058991) * Found what appears to be a useful plugin, Supra CSV, that will extract to an . xls file. * I’m trying to export the post_title and post_content. * One option asks for “meta keys provide a comma separated value” * I would like to export the coordinates. What’s the meta name for that? * Thread Starter [firesitedesign](https://wordpress.org/support/users/firesitedesign/) * (@firesitedesign) * [13 years, 8 months ago](https://wordpress.org/support/topic/plugin-basic-google-maps-placemarks-export-to-excel/#post-3058992) * I figured this much out: * bgmp-latitude bgmp-longitude * Any tips on extracting the bgmp categories, so I can easily sort the list? * Plugin Author [Ian Dunn](https://wordpress.org/support/users/iandunn/) * (@iandunn) * [13 years, 7 months ago](https://wordpress.org/support/topic/plugin-basic-google-maps-placemarks-export-to-excel/#post-3058994) * Categories are stored in the wp_terms, wp_terms_taxonomy and wp_terms_relationships tables, just not like categories and tags for regular Posts. So, the plugin will have to support taxonomies for it to work. * Thread Starter [firesitedesign](https://wordpress.org/support/users/firesitedesign/) * (@firesitedesign) * [13 years, 7 months ago](https://wordpress.org/support/topic/plugin-basic-google-maps-placemarks-export-to-excel/#post-3058996) * It does support export of taxonomies. * What string should I enter for the taxonomies for the bgmp categories? * Thread Starter [firesitedesign](https://wordpress.org/support/users/firesitedesign/) * (@firesitedesign) * [13 years, 7 months ago](https://wordpress.org/support/topic/plugin-basic-google-maps-placemarks-export-to-excel/#post-3058997) * Correct to above post, use underscore, not the dash * so * bgmp_latitude bgmp_longitude * Plugin Author [Ian Dunn](https://wordpress.org/support/users/iandunn/) * (@iandunn) * [13 years, 7 months ago](https://wordpress.org/support/topic/plugin-basic-google-maps-placemarks-export-to-excel/#post-3058998) * The taxonomy slug is `bgmp-category` * Thread Starter [firesitedesign](https://wordpress.org/support/users/firesitedesign/) * (@firesitedesign) * [13 years, 7 months ago](https://wordpress.org/support/topic/plugin-basic-google-maps-placemarks-export-to-excel/#post-3058999) * Excellent! * Got it to work. * Just one last question: * Some placemarks are assigned to multiple bgmp categories, is there a way to determine which category the “bgmp-category” taxonomy will produce? * Plugin Author [Ian Dunn](https://wordpress.org/support/users/iandunn/) * (@iandunn) * [13 years, 7 months ago](https://wordpress.org/support/topic/plugin-basic-google-maps-placemarks-export-to-excel/#post-3059001) * That’s probably determined by the CSV plugin’s implementation. It could choose to export all of them in a single field, or create multiple rows, or only pick one. * [maximusbrown](https://wordpress.org/support/users/maximusbrown/) * (@maximusbrown) * [13 years, 6 months ago](https://wordpress.org/support/topic/plugin-basic-google-maps-placemarks-export-to-excel/#post-3059013) * Would you be open to establishing an ODBC connection for Excel to communicate to your mySQL database? The excel template could include parameters like date, user, etc. Then all you have to do is click “refresh data” and the data will be retrieved from mySQL into Excel. Which version of Excel do you use? Do you have admin permissions on your computer? Would this be something useful for WordPress users like yourself? * Best, * maximusbrown Viewing 10 replies - 1 through 10 (of 10 total) The topic ‘[Plugin: Basic Google Maps Placemarks] Export to Excel’ is closed to new replies. * ![](https://ps.w.org/basic-google-maps-placemarks/assets/icon-128x128.png?rev =1152531) * [Basic Google Maps Placemarks](https://wordpress.org/plugins/basic-google-maps-placemarks/) * [Frequently Asked Questions](https://wordpress.org/plugins/basic-google-maps-placemarks/#faq) * [Support Threads](https://wordpress.org/support/plugin/basic-google-maps-placemarks/) * [Active Topics](https://wordpress.org/support/plugin/basic-google-maps-placemarks/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/basic-google-maps-placemarks/unresolved/) * [Reviews](https://wordpress.org/support/plugin/basic-google-maps-placemarks/reviews/) ## Tags * [cvs](https://wordpress.org/support/topic-tag/cvs/) * [Excel](https://wordpress.org/support/topic-tag/excel/) * 10 replies * 3 participants * Last reply from: [maximusbrown](https://wordpress.org/support/users/maximusbrown/) * Last activity: [13 years, 6 months ago](https://wordpress.org/support/topic/plugin-basic-google-maps-placemarks-export-to-excel/#post-3059013) * Status: resolved