Hi,
I have my data in excel file and want to convert it into shapefile. Any help please. Appreciated!
Here is what I do with census type data.
1. Download the data as an excel spreadsheet or csv.
2. Download the shapefile relating to the data granularity (State, County, Zip, or block)
3. Open the spreadsheet data check
A. that there are no blank lines,
B. that there are no extraneous data lines such as summations or superfluous titles
C. column headers in the first row and that they are less than 12 characters with no spaces or special symbols
other than underscore or hyphens
4. Save spreadsheet and import into MS Access. This step allows you to set the datatypes correctly. Excel has it's
own mind when declaring datatypes.
5. In Access, set the datatypes appropriately in table design mode.
6. Save the MS Access database in 2002-2003 format. This will allow you to import table to ArcGIS Desktop in the
next step.
7. Open ArcGIS Desktop and add both the census polygon shapefile and the Access data table. You can add a
base layer first to set the map's coordinate system.
8. Join the data table to the shapefile using a common key such as county, zip or tract.
9. Data>Export the shapefile (now containing joined data) to a new shapefile of your choosing. The shapefile's
coordinate system will be the same as your working map's. At this point you are finished. You do not need to
save the map. The shapefile is saved and available for use as soon as it is exported.
I got it.. Thanks all for your inputs
I will send you a sample of my file soon!
But my excel data are not points. They are just data in excel format.
You may want to also look at this thread
https://community.esri.com/thread/186447-creating-a-polygon-footprint-with-4-coordinates-from-excel-file
which has a script that may work......similar question.
Could you attach your excel file?
Is your Excel Data of points that make up the polygons? Also, is there an ID field that identifies which points are part of which polygons? If so, the workflow would be check the Excel data to make sure it is "GIS compatible", import the Excel data to GIS, save the resulting import as a point shapefile (or feature class in a geodatabase), then build the polygons from points.
Before importing to ArcGIS, be sure the Excel spreadsheet has been "cleaned up" to GIS standards. This will help avoid issues after import.
Formatting a table in Microsoft Excel for use in ArcGIS—Help | ArcGIS for Desktop
Adding the Excel table to ArcGIS
Adding a Microsoft Excel table to ArcMap—Help | ArcGIS for Desktop
Once the Excel data is in ArcGIS, be sure to save it out as its own shapefile, as the initial display is an "Event layer" and is just temporary.
To convert the points to polygons, there are several methods. Note that some depend on what license level one has and one method involves a third-party add on (ET Geowizards). For the latter, I believe one can download a demo copy for free.
Also, some of the methods rely in part on using a File or Personal Geodatabase during the processing. If so, from the beginning import save to a geodatabase, do the processing, then export the final product once the polygons are completed to a shapefile.
How To: Convert a point feature class to a polygon feature class
Chris Donohue, GISP
Hi Chris.. thanks for your response. I want the resultant shapefile to be a polygon. I have GIs version 10.2.2, and it is student version I got through my university.
Hope that helps
Best!
ABDALLA
There are several ways to do this, but it depends on what you are working with and what type of shapefile you want. Some questions to help clarify what you are after:
1. Will the resulting shapefile be of points, lines, or polygons?
2. What version of ArcMap do you have and what license level?
サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
