A post from a few days ago describes a somewhat convoluted multi-step process for converting shapefiles to text/spreadsheet format. Zonums Software has let me know that a new version of his free Shape2Text utility is available which simplifies the process tremendously.
Download the Shape2Text zipfile, and unzip it and the supporting .bpl files into its own directory (no install program). Run the program, and select the shapefile you want to convert to a text format:
For point shapefiles, an Attributes button will become active; click on it, and you can select which of the shapefile attributes will be exported along with the coordinates. You can delimit the file with commas (CSV), spaces (TXT) or tabs (TAB). An output file name and location will be auto-generated, but you can change that as well. Click on Accept, and the text file will be created. A lot easier than the earlier method!
The program also exports line and area shapefile vertices, but without attribute data, there’s no separation of data from individual shapes in the shapefiles, and there’s some additional data in the header section that you may need to edit out.
Addendum: The program requires Borland .bpl files, which should come included in the zip file. If you get an error message indicating that .bpl file is missing, you can download the needed file from this site. Copy it to the program directory, or put it in your Windows/System32 folder for access by any program in the future that might need it.
Other posts in the GIS Tools series
- Converting E00 Vector Data To Shapefiles – A Free And Fairly Painless Approach
- Simplifying Line And Polygon Shapefiles
- Converting US Census TIGER Data Into Shapefiles For Free
- Converting Shapefiles and ArcINFO Coverages To AutoCAD DXF Format
- Converting Point Shapefiles To Text/Spreadsheet Format
- Converting Text/Spreadsheet Files To Point Shapefile Format
- An Easier Way To Convert Shapefiles to Text/Spreadsheet Format
- Converting Text/Spreadsheet Data To Line/Area Shapefiles
- Full Resolution Raster Map Combining, Subsetting And Export With The TatukGIS Viewer
- Viewing Vector Data In The TatukGIS Viewer
- The LizardTech Stand-Alone MRSID Viewer
- Converting Raster Area Images Into Polygon Shapefiles
- SAGA GIS 2.0 Released
- ILWIS GIS Is Now Open Source
- AVHRR Analysis Add-On For ILWIS
- Advanced Image Mosaicking With Regeemy
- A Free GIS Viewer (And Cheap GIS Editor) For Windows Mobile Systems
- Updates For MapWindow And Saga GIS Programs
- Updates For Two Open-Source GIS Programs
- Putting Together A Basic Linux GIS Workstation
- Free Online Courses For Open Source GIS
- GIS-Oriented Linux Distributions
- Tabular Terrain Elevation Data
- Quick Data Gridding With QuikGrid
- A Good Introduction To Geospatial Data Analysis
- Converting Digital Elevation Models To Shapefile/DXF Contours
- Fixing "Broken" Shapefiles
- A Simple DBF Editor
- Two Online Vector GIS/GPS/KML Conversion Utilities
- Another Shapefile Repair Tool
- Quantum GIS (qGIS) Version 0.10 Released
- Online Raster Map Georeferencing/Registration With Map Rectifier
- Using The Demo Version Of Global Mapper As A Raster/Vector Data Viewer
- New Stable Release Of MapWindow GIS
- The Big List Of Free Metadata Software I
- The Big List Of Free Metadata Software II
- GIS On A Stick
Sounds promising – but I get an error message when trying to start, indicating that “vclx60.bpl” cannot be found.
Thanks for the comment. That’s a missing Borland .bpl file; I’ve added a note to the original post explaining where you can get a copy of any missing files, and where to put them.