+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Forum Newbie
    Computer Details
    arkitectin's Computer Details
    Operating System:
    Windows 7
    Discipline
    Facilities Mgmt
    arkitectin's Discipline Details
    Occupation
    Project Manager, Healthcare
    Discipline
    Facilities Mgmt
    Using
    AutoCAD 2014
    Join Date
    May 2014
    Location
    Southern Illinois
    Posts
    2

    Default Data Extraction to Excel turns data into dates.

    Registered forum members do not see this ad.

    Hello Everyone,
    I'm using AutoCad 2014 and have Microsoft office 2007. I use attributes in every drawing. Most have identifications as 1-01 which stands for Floor 1-Item #01 or 3-27 which stands for Floor 3-Item#27. When I use the data extraction, I extract it to the drawing, everything is correct at this point. Then export to a CSV file. If I open the CSV file in Excel all of my attributes turn into dates 1-Jan or 27-Mar. If I try to turn the column back to general or text it becomes some 5 digit number. Is there a way to export the data into excel but it keep the formating of the data in Cad?

  2. #2
    Forum Deity steven-g's Avatar
    Computer Details
    steven-g's Computer Details
    Operating System:
    Win 7
    Discipline
    Construction
    steven-g's Discipline Details
    Occupation
    Draughtsman
    Discipline
    Construction
    Details
    I work in the estimating department of a large building contractor.
    Using
    AutoCAD 2017
    Join Date
    May 2013
    Location
    An Englishman in Belgium
    Posts
    2,038

    Default

    Format your excel cells as text before you import the data, or if you use the excel import data wizard the third screen gives you the chance to select the type of data for each column (choose text).

  3. #3
    Forum Newbie
    Computer Details
    arkitectin's Computer Details
    Operating System:
    Windows 7
    Discipline
    Facilities Mgmt
    arkitectin's Discipline Details
    Occupation
    Project Manager, Healthcare
    Discipline
    Facilities Mgmt
    Using
    AutoCAD 2014
    Join Date
    May 2014
    Location
    Southern Illinois
    Posts
    2

    Default

    Registered forum members do not see this ad.

    In CAD the columns were previously set to text which is why I couldn't figure out why they were becoming dates in excel.

    I redid the data extraction. On Page 5 of 8, I right clicked on each column, selected Set Column Data Format and changed them all to General. On Page 6 of 8, I selected to Insert data and to Output data. Instead of trying to export the table from CAD to excel, I opened the Output Data file created in excel directly. It opened and all of my data was correct, it had not converted to dates.

    Thanks for your help!

Similar Threads

  1. Replies: 2
    Last Post: 22nd Apr 2012, 07:13 am
  2. Autocad 2010, data extraction to excel
    By Lagviper in forum AutoCAD Beginners' Area
    Replies: 2
    Last Post: 21st Sep 2011, 11:33 pm
  3. Replies: 5
    Last Post: 1st Mar 2011, 02:55 pm
  4. Replies: 2
    Last Post: 5th Jan 2011, 09:40 pm
  5. Data Extraction to Excel table problem
    By JBullseye74 in forum AutoCAD Drawing Management & Output
    Replies: 8
    Last Post: 20th Nov 2009, 12:51 pm

Tags for this Thread

Bookmarks

Posting Permissions

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