Work with AutoCAD Plant 3D Data in One Table

Load P&ID or 3D Piping rows, choose the classes and fields you need, make controlled edits, review every pending change, and exchange selected data with Excel.

6 steps
P&ID · 3D Piping
Review before accepting

What does Data Manager do?

Data Manager gives you a project data table that is easier to search, filter, compare, and edit than the regular Plant 3D palettes. It works with P&ID and 3D Piping data already registered in the active project.

Edits are staged first

Typing in an editable cell or importing an Excel file creates a pending change. Nothing is applied until you choose Accept. Use Discard to remove pending changes, or Review changes to inspect and exclude individual ones.

Have this ready

An open Plant 3D project

The drawing and project data must be available to the Plant 3D session.

A clear purpose

Start with one family/class and one or two fields so the first result is easy to verify.

Editable target fields

Plant 3D controls which properties can be changed. Grey or unavailable cells cannot be edited here.

A project copy for a new workflow

Use a copy for the first bulk-edit or Excel-import test.

Load the right rows, then narrow the table

Initial Data Manager Choose data to load screen with 3D Piping and Full project selected.
Choose data to load is the initial state. Select the project part, scope and one or more classes, then choose Load selected data.
1

Open Data Manager and choose the data scope

Open the Data Manager panel from RKCadTools, or type P3DDATAMANAGER (short form P3DDM).

  1. Choose P&ID or 3D Piping under Project part.
  2. Choose Current drawing when working in one drawing, or Full project to include the project-wide rows.
  3. Use the Classes tab to select the classes to load. A parent selection includes its checked child classes.
  4. Click Load selected data on the initial screen, or Refresh Data to reload the selection.
Data Manager with 3D Piping, Full project and the Equipment branch selected before loading.
Choose a project part, scope and classes before loading. Selecting Equipment includes its checked child classes; this example has 22 classes selected and no rows loaded yet.

2

Show only the fields you need

  1. Open the Fields tab.
  2. Use the field search box to find a property, such as AreaID.
  3. Tick the fields you want to display, then click Apply.
  4. Use the column headers, search box, and class filter to focus on the rows that matter.
Data Manager Fields tab listing editable, locked and mixed fields and their object counts.
The field list reports editable, locked or mixed status with counts. Apply in this pane changes the displayed columns; it does not apply object-data edits.

3

Save a view for a repeatable task

  1. Set the project part, scope, classes, visible fields, search/filter, and column layout you need.
  2. Enter a name under View, then click Save view.
  3. Choose the saved view later to restore the same working layout.

Useful first views: one view per discipline or purpose, such as “Valves — 3D Piping”, “Equipment tags — P&ID”, or “AreaID cleanup”.

Edit, review, and apply with confidence

4

Edit only green cells

  1. Click an editable green cell and enter the new value.
  2. Pending changes are shown in the grid and counted in the status bar.
  3. Use Review changes to search the pending changes and exclude any item you do not want to apply.
  4. Click Accept to apply the remaining changes, or Discard to remove them.
Data Manager with 160 loaded 3D Piping rows, grey reference columns and green editable PartSizeLongDesc cells.
The loaded sample has 160 rows. Grey columns are locked reference fields; green cells are editable. This screenshot has no staged changes. Edits made here remain pending until Accept applies them.

5

Confirm the result and save the affected drawings

After accepting, Data Manager reports that values have been applied to the affected open drawings. Save and check those drawings through the normal Plant 3D workflow to publish the changes.

Data Manager after applying two changes, with the status text telling the user to save and check in the affected drawings.
Accepted values are applied to the open drawings. The status message reminds you to save and check in the affected drawings.

Cell appearance Meaning What to do
Green Editable property Edit it directly; then review and accept.
Grey Locked property It cannot be changed through this grid.
Dark grey Not available for this row The selected class does not provide that property.
Yellow Tag cell Tag-controlled field Use the Plant 3D tag command; double-click the cell to start it.

Exchange the visible data with Excel

  1. Filter the grid and choose the fields you want to work with.
  2. Click Export Excel. The workbook includes a hidden stable object key used to match rows safely on import.
  3. Edit only the unlocked cells, then click Import Excel.
  4. Use Review changes before accepting the imported values.
  5. After accepting, inspect the generated .import-result.xlsx file. It records applied, skipped, unsafe, or unmatched rows.

Do not alter the hidden key or row identity

Keep the exported workbook structure intact. Data Manager uses its stable hidden key to identify the correct Plant 3D object when importing.

Quick troubleshooting

The grid is empty

Confirm that the correct project part and data scope are selected, then check at least one class and click Refresh Data. A class selection changed after loading does not update the grid until you refresh.

I cannot edit a cell

Only green cells are editable. A grey cell is locked by Plant 3D or the column rule; a dark-grey cell is not available for that row. Tag fields must be edited using the Plant 3D tag command.

The table shows old values after another command changed data

Click Quick Refresh or Refresh Data to load current values again.

Selecting a row opens or zooms to a drawing

Turn off the Zoom option in the Navigation area when you want to inspect the table without navigating the drawing.

Excel import did not apply every row

Open the generated .import-result.xlsx copy. It identifies rows that could not be safely matched or changed and records the staged changes.

RKCadTools · Data Manager guideUse P3DDATAMANAGER or P3DDM to open Data Manager.

Explore the Excel import and export workflow →

RKCadTools

Welcome back

Sign in to manage licenses, activated computers, purchases, and billing.

Use your existing RKCadTools account, including a free Component Studio account. In My Account, register your company to buy and manage licenses. Creating a company does not start a trial or subscription.

New here? Create an RKCadTools account or contact us about a company purchase.