StatPlanet Data Editor / News: Recent posts

v 1.6 updates the import macros to support Excel for Mac, as well as improvements such as importing data from spreadsheets with multiple sheets in one go. Although optimized for country data, the names in the sheet 'import names' can be modified to import data for any kind of variable or map area. See also the 'shapefile map' version of an example, included in StatPlanet Plus: www.statsilk.com/downloads

World development data from different organizations is becoming easier to access and download - but the data is structured in different ways and country names are spelled differently. This makes it more difficult to link and compare data from these different sources. The StatPlanet data editor (Excel macro) can import data from various sources and rearrange it into a consistent structure, facilitating comparison. The data is structured so that it can be read by the StatPlanet data visualization software and instantly visualized as thematic maps and graphs. However, the Data Editor could be modified relatively easily to also support the importing of other types of data, which could then be re-arranged in different ways.... read more