Revit App: Import/Export Excel

Lowdown

The Import/Export Excel allows you to synchronize data back and forth between Autodesk® Revit® and Excel. It also means you can alleviate the data management process by delegating tasks related to the model to team members that don’t use the model. You can export schedules as well as Revit standards to manage them in Excel. Once modified, you import the data back to Revit and your schedules or standards are going to be updated.

Benefits 

  • Data management without managing the 3D model
  • Better segregation of duties
  • Reduced training costs on BIM software’s

Documentation can be found here

French: http://bimone.com/userguide/Import-Export%20Excel%20-%20Guide%20Utilisateur.pdf

English: http://bimone.com/userguide/Import-Export%20Excel%20-%20User%20Guide.pdf

ADD-IN LIMITATIONS

Read only and type parameters: Some parameters in Revit are considered as “read-only” when their value is controlled by the Revit engine. You won’t be able to modify this kind of parameters even you modify it in the Excel file because you aren’t allowed to write in those parameters. Type parameters are one in a kind parameters too. If we modify them, we modify all the instances of that type. For that matter, type parameter modifications are not supported by our application. Read only parameters and type parameters are colored in light gray when exporting to Excel so you can distinguish them from the rest.
Importing Issue: It is mandatory to use the Export feature at first and let the add-in generate its own fields. Importing a man-made Excel file will not work as Revit will only answer to a specific structure of data. Once the file has been exported, you can only modify existing data in the fields generated during the export. Adding lines/columns will not work as they won’t be recognized by Revit. However, you can fill-in empty fields as long as they belong to a line/column that was generated by the export tool.


Info

Install: apps.autodesk.com

Cost: Free

Compatible with:

  • Autodesk Revit – Version: 2017 , 2016 , 2015
  • Autodesk Revit Architecture – Version: 2016 , 2015 , 2014
  • Autodesk Revit Structure – Version: 2016 , 2015 , 2014
  • Autodesk Revit MEP – Version: 2016 , 2015 , 2014

Contact

Company Name: Virtual construction and technology BIM One Inc.
Company URL: www.bimone.com
Support Contact: support@bimone.com

Import PDF as AutoCAD Objects

Lynn Allen, Cadalyst contributing editor and Autodesk Technical Evangelist , presents a useful video for AutoCAD professionals. In this video tutorial, Allen provides some useful cad tips to transform PDF files (underlay) to AutoCAD objects.

So, the AutoCAD users can get rid of time consuming tracing on top of PDFs to reproduce objects or draw it from the beginning.

You can import the objects in a PDF file or PDF underlay into your current drawing file.

Import the Data from a PDF File

  1. Click Insert tabImport panelPDF Import Find
  2. In the Import PDF dialog box, specify the PDF file that you want to import, and click Open.
  3. If the PDF has multiple pages, choose the page to import by clicking a thumbnail image or by entering a page number.
  4. Choose any of the options and click OK.
  5. Specify the insertion point if prompted.

Import a Specified Area from a PDF Underlay

  1. Select the PDF underlay.
  2. On the PDF Underlay contextual tab, Click Import as Objects.  Find
  3. At the prompt, click two diagonal points that define a rectangular crossing area, or choose one of the other options.

    A crossing area is similar to a crossing selection. The Settings option displays a dialog box in which you can choose what types of objects to import, how layers should be accommodated, whether the imported objects should be imported as a block, and several other options.

  4. Choose whether you want to keep, detach, or unload the attached PDF after the selected objects have been imported.

The specified area of the attached PDF is imported into the drawing as AutoCAD objects.

For more details, watch the following video tutorial.