Convert SHP to XLS

A GIS department may need a spreadsheet when non-GIS staff must review, filter, or edit map records in Microsoft Excel. Converting the data produces an .xls workbook from the shapefile's attribute table; it does not create an editable map layer in Excel.

What the SHP format is

SHP usually means the ESRI Shapefile format, a vector dataset used for points, lines, and polygons such as addresses, roads, parcels, and boundaries. A usable shapefile normally includes matching files: .shp stores geometry, .shx stores the shape index, .dbf stores attribute records, and .prj stores the coordinate reference system when available. A .cpg file may identify the character encoding.

QGIS, ArcGIS Pro, and other GIS applications read and create shapefiles. The .dbf attribute table supplies the columns and records that can become spreadsheet rows. Geometry, spatial indexes, and projection information need separate handling.

What the XLS format is

.xls is Microsoft's binary Excel 97–2003 workbook format. Excel, LibreOffice Calc, and compatible spreadsheet programs can sort, filter, calculate, chart, and edit its tabular data.

Use XLS when a recipient or older application specifically requires that format. Each worksheet supports at most 65,536 rows and 256 columns; modern .xlsx supports substantially larger worksheets and is preferable when legacy compatibility is not required.

How to convert SHP to XLS

Using QGIS and LibreOffice

1. Put the complete shapefile component set in one folder. Keep identical base names for files such as parcels.shp, parcels.shx, parcels.dbf, and parcels.prj. If transferring the set, zip the files together rather than sending only the .shp file.
2. In QGIS, choose Layer → Add Layer → Add Vector Layer and open the .shp file.
3. Right-click the layer and choose Open Attribute Table. Apply a filter or select records if the workbook should contain only part of the layer.
4. Right-click the layer and choose Export → Save Features As. Select Comma Separated Value [CSV] as the format and choose an output filename. Enable geometry export as WKT, or export explicit X and Y fields, only if the spreadsheet needs location values. A CSV is still tabular text, not a GIS layer.
5. Open the CSV in LibreOffice Calc. In the import dialog, verify the delimiter, character encoding, quoted text, dates, and numeric fields. Set identifiers such as postal codes and parcel numbers to text when leading zeroes must remain.
6. Choose File → Save As, select Excel 97–2003 (.xls), and accept the format warning. Reopen the saved workbook and check the row count, headers, characters, dates, and identifier fields.

This two-step route exposes the import settings before the workbook is created and works without a full commercial GIS installation.

Using ArcGIS Pro

In ArcGIS Pro, add the shapefile, then use Geoprocessing → Conversion Tools → Excel → Table To Excel on the layer or its attribute table. Select an XLS output when the installed ArcGIS Pro version offers the legacy format. If it creates only .xlsx, open that workbook in Excel or LibreOffice and use Save As to select .xls. This exports the table, not the shapefile's geometry or coordinate reference system.

Using an online converter

A GIS conversion service such as MyGeodata Cloud can convert supported shapefile uploads to spreadsheet formats through a browser. Upload a ZIP containing the matching shapefile components, select XLS if it is offered, and inspect the downloaded workbook. Online services may impose file-size, row-count, or format restrictions, and their support for older XLS output can change. Do not upload confidential, personal, restricted, or legally sensitive location data; use QGIS or ArcGIS locally instead.

Quality and compatibility limits

• The workbook contains attribute records and, if requested, text or numeric coordinate fields. It does not retain editable points, lines, polygons, spatial indexes, styles, topology, or GIS behavior. Keep the original shapefile set for mapping and spatial analysis.
• Shapefile field names are limited to 10 characters. Preserve a field dictionary separately if the shortened names are ambiguous.
• The DBF component may use an encoding that is missing or incorrectly identified. Check accented characters and non-Latin text after export; a .cpg file can help GIS software interpret the encoding.
• Spreadsheet programs may convert long integers, dates, scientific notation, and codes automatically. Import sensitive identifiers as text and verify exact values after saving.
• An XLS worksheet cannot hold more than 65,536 rows or 256 columns. Use .xlsx or CSV for larger tables, subject to the destination application's requirements.
• The .prj coordinate reference system is not embedded in an XLS workbook. If coordinates are exported, record the CRS and the coordinate order separately; WKT or explicit X/Y columns do not by themselves preserve projection metadata.