+ Reply to Thread
Results 1 to 6 of 6

Thread: Export attribute table into MS Excel

  1. #1
    Joshua Benton
    Join Date
    Oct 2011
    Posts
    32
    Points
    0
    Answers Provided
    5


    0

    Default Export attribute table into MS Excel

    Working with ArcGIS desktop 10.1, I am looking for a way to export an attribute table (or any table really) into an MS Excel file.

  2. #2
    T. Wayne Whitley

    Join Date
    Apr 2010
    Posts
    1,032
    Points
    848
    Answers Provided
    119


    2
    This post is marked as the answer

    Default Re: Export attribute table into MS Excel

    Well, you can export to dbf or csv which readily opens with Excel, which if you want this in native Excel format, then you can save it within Excel. Is that what you want?...then, a scripting solution is to use Python to read the attribute table and write directly in xls format.

    ah, forgot about this, from the Model and Tool gallery, you can export directly to Excel:

    Additional Conversion - Generic Tools
    http://resources.arcgis.com/gallery/...5-B8638ECB2FA9


    This was cross-referenced by the webhelp which contains interesting further info about Excel and ArcGIS:

    Understanding how to use Microsoft Excel files in ArcGIS
    Geodata » Data types » Tables » Creating and editing tables
    http://resources.arcgis.com/en/help/...0000001w000000
    Last edited by Wayne_Whitley; 12-02-2012 at 10:29 AM.

  3. #3
    Shaun Cavey
    Join Date
    Nov 2012
    Posts
    10
    Points
    1
    Answers Provided
    0


    0

    Default Re: Export attribute table into MS Excel

    I use XToolsPro freeware license. There is a command 'Export Data to MS Excel' that I use all the time. Nice user interface too. You can place the 'Export Data to MS Excel' button on any of your toolbars by using the 'Customize Mode...' window.

  4. #4
    Joshua Benton
    Join Date
    Oct 2011
    Posts
    32
    Points
    0
    Answers Provided
    5


    0

    Default Re: Export attribute table into MS Excel

    Thank you both for you answers.

  5. #5
    Thaniel G
    Join Date
    Apr 2010
    Posts
    99
    Points
    15
    Answers Provided
    2


    0

    Question Re: Export attribute table into MS Excel

    Quote Originally Posted by scavey View Post
    I use XToolsPro freeware license.
    can i ask where you find this "freeware"? i went to their website but i'm looking at $250 for a single license.

  6. #6
    Mark Fawkes
    Join Date
    Jun 2010
    Posts
    29
    Points
    1
    Answers Provided
    0


    0

    Default Re: Export attribute table into MS Excel

    Quote Originally Posted by ngouk View Post
    can i ask where you find this "freeware"? i went to their website but i'm looking at $250 for a single license.
    Unless they have changed things in the most recent version, the 'free'version is a subset of the full paid version (i.e. not all tools available).

    From their FAQ:
    Q: Do you have a free downloadable version or do we have to pay per download for the XTools Pro version?

    A: XTools Pro is a shareware extension to ArcGIS Desktop. You can download it for FREE from Data East or XTools Pro sites.
    This version is full-functional and available for the trial period of 14 days. Then you can either register for a free license key to use the free tools or purchase a full license to have access to the paid tools. Downloading and evaluating XTools Pro does not oblige you to pay.

+ Reply to Thread

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts