qgis - Geometry Errors with Imported Shapefile, Unable to Fix

Software Used

• QGIS 2.18.10


• MS Excel 2016

GitHub Repository With Files (link)

Blank file when reprojecting

---

---

Unable to find Processing Tools

Here is something close, but none of the three sub-categories ask for output shapefile.

---

---

---

Update 1

Here are steps ... it appears correct in QGIS but there are still Invalid Geometry Errors in Excel Power Map

NOTE: Just for grins, in Step 5 I saved using NY projection instead of WGS 84 projection and I get same error.

1. Add Delimited Text Layer

2. Select options > OK

3. Select NY Projection

4. Right-click > Save As

5. Select WGS 84 Projection (what Excel accepts)

6. Output

---

---

Original Question

I am trying to create shapefile with DSNY_Graffiti_Information.csv

Created Layer from delimited text file

Then I select New York Projection (EPSG:2263)

Finally I save as shapefile in NY_Graffiti_Shapefile.zip

When I attempt to import shapefile to MS Excel 2016 Power Maps I get Invalid regions error

Attempted to use Topology Checker Plugin, but no errors are detected.

How do I fix this?

Answer

According to this post:

The Custom Regions feature in Power Map allows you to import KML or SHP files which contain custom polygons.

Since you're trying to import point geometry that would explain the Invalid Geometry error.

You could try running a buffer on the points in QGIS to convert them into small circles which might make it acceptable to Excel.