Convert SHP to XLSX
Turn SHP files into XLSX. A workbook with one sheet named after the file, cut to 31 characters, and one row for each feature: its shape as WKT in a first column named WKT, then every attribute as a column, with numbers, dates and true and false as typed cells.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop SHP files on the dialor turn it to pick what to do
A spreadsheet with one row per feature.Each shape becomes a row, with its attributes in columns beside it.
What you get
A workbook with one sheet, named after the file and cut to 31 characters. Each feature is one row. The first column, named WKT, holds the shape as WKT, and every attribute follows as its own column.
Numbers, dates and true and false values are written as typed cells.
How the data is written
Coordinates are written in WGS 84 longitude and latitude. If the source uses another system, such as Korea's EPSG:5186, they are converted. If the data names no system, the coordinates stay as they are.
Lists and nested values become JSON text. Times with a time zone are written in UTC.
A feature without a geometry keeps its row, with an empty WKT cell. If a column is already named WKT, it is renamed WKT_1.
Limits and layers
A cell holds at most 32,767 characters. A shape longer than that leaves its cell empty and a warning is given.
A map of more than 1,048,575 features stops with
resource_limit.When the source has several layers, they are joined into one sheet. A layer column names where each feature came from.
For other routes, see every SHP conversion or every XLSX conversion.
SHP and XLSX.What each format is.
The formats
Shapefile
Esri shapefiles zipped with their .shx, .dbf and .cpg parts, the vector format GIS programs exchange.
- Extensions
- .shp.zip .shz .shp
- MIME type
- application
/x -shapefile +zip - Kind
- Text and data
Excel Workbook
Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.
- Extensions
- .xlsx
- MIME type
- application
/vnd .openxmlformats -officedocument .spreadsheetml .sheet - Kind
- Documents
In your code.The same SHP to XLSX conversion through the API, for your app or your agent.
$ cv convert report.shp.zip report.xlsx$ cv convert report.shp.zip report.xlsxQuestions.What people ask about SHP to XLSX.
It is in the first column, named WKT, as text in the WKT format. A feature without a geometry has an empty cell there.
WGS 84 longitude and latitude. Coordinates from another system, such as EPSG:5186, are converted. Data that names no system keeps its coordinates as they are.
The layers are joined into one sheet. A layer column shows which layer each feature came from.
The map has more than 1,048,575 features, which is more than the sheet can hold as rows.