Select to view content in your preferred language

Excel file to shapefile

57686
18
11-28-2016 10:34 AM
ABDALLAMOHAMED
Occasional Contributor

Hi,

I have my data in excel file and want to convert it into shapefile. Any help please. Appreciated!

0 Kudos
18 Replies
RebeccaStrauch__GISP
MVP Emeritus

yes.  You would still probably create the shape first, then add the attribute info with a joinitem.  Look at Chris's comments above. 

Also, depending on what coordinates you enter,

  • if not lat/long, you will need to know the coordinate system.
  • if lat/long, remember it is actually x = longitude, y = latitude.  Also South and West are negative numbers
0 Kudos
ABDALLAMOHAMED
Occasional Contributor

Okay, let me try that and see the result..

Thanks a lot!

0 Kudos
EllenSleeter
New Contributor

Ouch.  Spoken like a GIS person and not a social scientist.  "Longitudinal" in this context very likely means that the study was conducted over a "long" period of of time, thereby increasing the validity of the dataset...

0 Kudos
RebeccaStrauch__GISP
MVP Emeritus

lol.....yep I'm and institutionalized GIS person.   My brain always looks for the geospatial possibility ...and of course not always correct.

0 Kudos
ABDALLAMOHAMED
Occasional Contributor

Yes, you are wonderful. Looking forward to learning a lot from your institutionalized GIS brain.   

0 Kudos
AbdullahAnter
Regular Contributor II

Could you attach your excel file?

0 Kudos
ABDALLAMOHAMED
Occasional Contributor

I will send you a sample of my file soon!

0 Kudos
ABDALLAMOHAMED
Occasional Contributor

I got it.. Thanks all for your inputs

0 Kudos
BobbyMaiden
New Contributor

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.