Software Used

  • QGIS 2.18.10
  • MS Excel 2016

GitHub Repository With Files (link)

Update 3

Blank file when reprojecting

1. Open the layer

enter image description here

2. Double-click Reproject Layer

enter image description here

3. Select Reprojection Parameters

enter image description here

4. Reprojected layer is blank

enter image description here

5. Error when attempting to import to Excel 2016 Power Map

enter image description here

6. Directory of shapefile

enter image description here

Update 2

Unable to find Processing Tools

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

enter image description here

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

enter image description here

2. Select options > OK

enter image description here

3. Select NY Projection

enter image description here

4. Right-click > Save As

enter image description here

5. Select WGS 84 Projection (what Excel accepts)

enter image description here

6. Output

enter image description here

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

enter image description here

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

How do I fix this?

  • 1
    What projection are you using? Your csv is fine. I just created a shapefile from it in ArcGIS, so it has to be a problem related to the projection you're using in QGIS and Excel. Maybe you're not using the same one for both?
    – Sergio C.
    Jul 3, 2017 at 5:03
  • @SergioC. I tried with projections WGS84 and New York Projection (EPSG:2263)
    – Rhonda
    Jul 3, 2017 at 15:10

2 Answers 2


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.


Before importing to Excel, make sure you define the projection in QGIS. Select the layer properties --> general --> Reference system and find the New York projection EPSG 2263.

Then right click on the layer again and select save as: The result should be a valid shapefile. I did it myself and works well both in QGIS and ArcGIS. Unfortenately, I don't have a license for Excel Power Maps so I can't try it there, but if ArcGIS opens it, the shapefile should be fine.

  • Hello @sergio-c I'm trying this now ...
    – Rhonda
    Jul 4, 2017 at 14:31
  • I tried, still not working. Please see updated question for screenshots -- perhaps I overlooked something?
    – Rhonda
    Jul 4, 2017 at 15:12
  • You should save your shapefile without changing the projection to wgs 1984 but keeping the New York one. That's what making Excel to be "confused". Once you have saved your shapefile, you need to convert it to wgs 1984, you'll get a second shp that you will add to excel. You will find the reproject tool under "processing tools".
    – Sergio C.
    Jul 4, 2017 at 17:55
  • Unable to find processing tools. Closest thing I can find is Raster > Projections but neither Warp,Assign Projection, nor Extract Projection ask for shapefile or projection. Please see question under Update 2
    – Rhonda
    Jul 4, 2017 at 21:10
  • Try this: gis.stackexchange.com/a/218554/99720
    – Sergio C.
    Jul 4, 2017 at 21:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.