Linking Drawing Data to Spreadsheets

      Tips on pulling data from AutoCAD drawings into Excel spreadsheets to compile cabinet ordering information. November 26, 2007

I am in the process of drawing casework for a few hundred apartments. One thing I would like to do is include a MS Word document in the drawing that I can edit with quantities of different base cabs, wall cabs, fillers, etc. Is there a way I can pull the numbers from the drawing and insert them back into a spreadsheet for ordering?

Forum Responses
(CAD Forum)
From contributor Y:
I do not know about MS Word, but the latest version, ACAD 08, has a bidirectional link with MS Excel. Depending on the ACAD version, you can find an add-on program that will do this. Check for ACAD useful add-ons.

From the original questioner:
Currently running AutoCad 2006.

From contributor J:
Look into using tables. On one project with hundreds of cabinets, I set up various blocks with attributes. One for each type of cabinet, base, upper, tall, sink, etc. The attributes where (name, WxHxD). I created one of each type of unit with the attribute above or below the cabinet along with a dimension. Then when I needed to put a string of cabinets together, it was like drag and drop. Then when I was ready to create a table, just window the area I wanted, and the table was created with the quantity of each block and the attributes. You need to play with the table setup a bit, but it worked out great.

From contributor B:
You should be able to copy an Excel table into your drawing. Once it's there, you can easily edit it. It's been a while since I used 2006, but have been using Excel in AutoCAD since version 2000.

Would you like to add information to this article?
Interested in writing or submitting an article?
Have a question about this article?

Have you reviewed the related Knowledge Base areas below?
  • KnowledgeBase: Knowledge Base

  • KnowledgeBase: Computerization

  • KnowledgeBase: Computerization: CAD Computer Related Design

    Would you like to add information to this article? ... Click Here

    If you have a question regarding a Knowledge Base article, your best chance at uncovering an answer is to search the entire Knowledge Base for related articles or to post your question at the appropriate WOODWEB Forum. Before posting your message, be sure to
    review our Forum Guidelines.

    Questions entered in the Knowledge Base Article comment form will not generate responses! A list of WOODWEB Forums can be found at WOODWEB's Site Map.

    When you post your question at the Forum, be sure to include references to the Knowledge Base article that inspired your question. The more information you provide with your question, the better your chances are of receiving responses.

    Return to beginning of article.

    Refer a Friend || Read This Important Information || Site Map || Privacy Policy || Site User Agreement

    Letters, questions or comments? E-Mail us and let us know what you think. Be sure to review our Frequently Asked Questions page.

    Contact us to discuss advertising or to report problems with this site.

    To report a problem, send an e-mail to our Webmaster

    Copyright © 1996-2020 - WOODWEB ® Inc.
    All rights reserved. No part of this publication may be reproduced in any manner without permission of the Editor.
    Review WOODWEB's Copyright Policy.

    The editors, writers, and staff at WOODWEB try to promote safe practices. What is safe for one woodworker under certain conditions may not be safe for others in different circumstances. Readers should undertake the use of materials and methods discussed at WOODWEB after considerate evaluation, and at their own risk.

    WOODWEB, Inc.
    335 Bedell Road
    Montrose, PA 18801

    Contact WOODWEB

  • WOODWEB - the leading resource for professional woodworkers

      Home » Knowledge Base » Knowledge Base Article