Ardoq Data Inventory - Unlock Easier Data Management
Description: Find, edit, and connect your Ardoq data in one spreadsheet-style table, with what Admins, Writers, and Contributors can each do.
What Is Data Inventory?
Data Inventory is a spreadsheet-style view of your Ardoq data. Open the workspaces or component types you care about, then find, edit, and connect components in one table. Every change is a live update to your Ardoq data.
Why you'll love it:
See your components in a familiar table format
Filter, sort, and choose columns to focus on what matters
Edit many components at once with copy, paste, and fill
Create, connect, and restructure components without leaving the table
Visualize or export what you see in a couple of clicks
What you can do depends on your role. Admins and Writers get every action in the table. Contributors can find, edit, and export data with a simpler set of actions. See Data Inventory for Admins and Writers, and Data Inventory for Contributors, below.
Opening Data Inventory
Select Data Inventory under Data in the main navigation to open the Data overview.
Choose By type to list component types, or By workspace to list workspaces.
Select a name to open it. To open several at once, tick their rows, then select Open.
You can also start from other places:
Browse Data on the Discover page opens a component type directly, or the Data overview with See all.
Manage data on a homepage card opens Data Inventory with that card's data.
To switch to other workspaces or component types, click Data Inventory in the breadcrumb at the top of the page.
Finding Your Data
Columns
Select Columns to choose which fields and references to show, then drag column headers to reorder them. Use a column's menu to pin it left or right. Select Reset Columns to go back to the defaults.
How columns behave:
Ardoq saves your columns for the workspaces or component types you have open, so the same view comes back next time.
Ardoq doesn't save column widths.
Field groups appear in the column picker, so related fields are easier to find.
Calculated fields show (Calculated) after their name.
Reference Columns
References appear as columns labeled with their type and direction. For example, ← Owns ← is incoming and → Is Supported By → is outgoing.
Filtering and Searching
Filter from any column header. Each column takes one condition. When you filter several columns, components must match all of them.
Column type | Filter options |
Name | Contains, Equals |
Text, Text area, Email | Contains, Does not contain, Equals, Does not equal, Blank, Not blank |
Description, URL | Contains, Does not contain, Blank, Not blank |
Number | Equals, Does not equal, Greater than, Less than, Blank, Not blank |
Date | Equals, Does not equal, Before, After, In range, Blank, Not blank |
Created at, Updated at | Equals, Before, After, In range |
Date range | Before, After, In range, Blank, Not blank |
List, Multi-select list, User | One or more values, or No value |
Type, Workspace | One or more values |
Checkbox | Checked, Unchecked, Not set |
Tags | Has value, No value, or specific tags |
References | Has References, No References, or specific components |
Parent | Has value, No value, or a specific parent |
Lucidchart | Has value, No value |
Ardoq ID, Ardoq OID | Equals, Does not equal |
To filter by name, type in the Search components box. Other active filters show as pills above the table. Remove them one at a time, or select Clear all filters, which also clears the search box.
Sorting
Select a column header to sort by that column. You can sort by one column at a time. Without a sort, components are listed by name.
You can't sort reference, tag, Lucidchart, user, multi-select list, file, or date range columns.
Datasource Information
The panel above the table describes what you have open:
One workspace: its description and when it was last updated. Workspace admins also get Workspace manager and Edit fields links.
One component type: its description. Workspace admins also get Workspace manager links for the workspaces that contain it.
The number of matching components shows next to the panel, for example "248 components".
[IMG: check "Datasource information.png" doesn't show the "features in N workspaces" list or the Component type overview link]
Opening Component Details
Select a component's name, or a component in a reference cell, to open its overview in a drawer. You won't lose your place in the table.
Editing Your Data
Anyone with edit access to a workspace can edit its components in Data Inventory. That includes Contributors. What you can change follows your workspace and field permissions.
Creating Components
Select Create. A new row appears at the top of the table.
If you can edit more than one workspace, pick the workspace for the new component.
Type a name and press Enter to save it. A new row opens with the same workspace and type, so you can keep going.
Select Finish editing when you're done.
Tags, parent, and reference cells become editable once the new component is saved. New components stay at the top until you finish. After that, they follow your sorting and filtering.
Editing Components
Double-click a cell to edit it. Changes save straight away.
In text and number cells, press Enter or Tab to save, or Esc to cancel.
In a list, choosing a value saves it.
In tags and other multi-value cells, press Tab when you're done.
Some cells can't be edited:
Ardoq ID, Ardoq OID, Created at, Created by, Updated at, Last updated by, Origin, and Updated via
Calculated and derived fields
Fields managed by an integration
Locked components
A cell shows n/a when a field doesn't apply to that component's type. Hover over a read-only cell to see why it can't be edited. If an edit can't be saved, the cell shows an error icon with the reason.
ℹ️ Notes:
There's no undo for edits made in Data Inventory. Double-check changes before saving.
Data Inventory doesn't refresh when someone edits data elsewhere. Reopen the view to see their changes.
Editing Many Components at Once
Select a range of cells by clicking one cell and Shift-clicking another, then use any of these:
Copy and paste cells within Data Inventory or from a spreadsheet, up to 100 rows at a time.
Fill neighboring cells by dragging the corner of a cell up or down.
Clear every selected cell with Delete or Backspace.
A confirmation dialog shows what will change when a change affects two or more components, or adds or removes references. Select Cancel to back out before anything is saved. Once you confirm, there's no undo.
ℹ️ Notes:
For more than 100 rows, use the Excel importer.
If filters are active, you're only changing what's visible. Check your filters before you confirm.
Editing References
Create or change a reference: double-click a reference cell. Pick the component type, search for a component, then select it to add the reference. Close the editor when you're done. Your options follow the relationships defined in your organization's metamodel.
Remove a reference: open the cell and select × on the component. Or select the cells and press Delete or Backspace, then confirm.
Paste references:
Copy references from one cell to another.
Paste component IDs or names into a reference column.
Make sure each name matches exactly one component. If any name doesn't match, nothing is pasted, and Data Inventory tells you how many cells didn't match.
Keep in mind:
References can only connect component types your metamodel allows. If any pasted reference isn't allowed, nothing changes.
n/a in a reference cell means that reference type isn't defined for the component's type.
Dragging to fill doesn't work on reference columns. Use copy and paste instead.
Fields on references can't be edited in Data Inventory yet. Use the Grid Editor for that.
Tags
Turn on the Tags column to manage tags inline:
Apply an existing tag from the component's workspace
Create a new tag by typing a name that doesn't exist yet (letters, numbers, "_" and "-")
Remove a tag by clearing it from the cell
To find every component that shares a tag, filter the Tags column. Data Inventory shows component tags only. Reference tags are edited in workspace mode.
Changing Component Type and Parent
To change a component's type, edit its Type cell. You can paste or fill across many rows to change types in bulk. The new type has to exist in the component's workspace.
To change a component's parent, edit or paste into the Parent column. The parent has to be in the same workspace.
Workspaces with a rigid model don't allow type or parent changes.
Lucidchart
Turn on the Lucidchart column to view, attach, and remove linked Lucidchart documents. See Lucidchart Integration.
Data Inventory for Admins and Writers
Admins and Writers get every action in the table, on top of everything in Finding Your Data and Editing Your Data.
Actions on Selected Components
Select components with the row checkboxes. The toolbar shows how many are selected, with Cancel to clear the selection. Then right-click, or open the ⋮ menu above the table:
Duplicate component: creates a copy with "(copy)" added to the name. References aren't copied.
Merge components: combines two or more components into one, keeping the values you choose. Merges are permanent.
View history: opens the audit log for the selected components.
Create scenario from selection or Add selection to scenario: adds the components to a scenario. These show when you have scenario permissions and no scenario is open.
Delete component: deletes the components, their children, and references to and from them. A dialog lists everything that will be deleted before you confirm.
Hierarchies
On a workspace view, use the List and Hierarchy toggle next to Columns to see parent and child components nested in the table. Workspace views open in hierarchy view until you switch to List.
Hierarchies are based on workspaces. On a component type view, select Show full hierarchy to switch to the workspaces that contain it. Select Back to component type to return.
In hierarchy view you can:
Expand and collapse with the row arrows, or with the Expand all and Collapse all icons in the Name column header
Add a child by right-clicking a component and selecting Add child
Change parent by dragging components onto a new parent, or by right-clicking and selecting Change parent
ℹ️ Notes:
Components can only move to a parent in the same workspace, in workspaces with a flexible model.
You can't move a component to a different workspace in Data Inventory.
Save as report isn't available in hierarchy view. Switch to List first.
Visualize
Select Visualize all to visualize every component that matches your current filters. To visualize specific components, select them first, then choose Visualize selected (up to 100 components).
The menu offers:
Priority viewpoints for the component type
View styles to choose a visualization
Apply a saved viewpoint for the component type
Priority viewpoints and saved viewpoints work when all the components are the same type.
ℹ️ Priority viewpoints: With components of one type, the menu lists that type's priority viewpoints above View styles. With several types it shows "Available when a single component type is selected." If no priority viewpoints are set up for the type, the section is hidden. Admins set priority viewpoints in Priority settings.
Exporting
Select Save as and choose a format:
Excel file (data only): the table as it looks now
Excel file (import format): a file laid out for re-importing into Ardoq
JSON file: a structured, machine-readable file
The file matches your view, including visible columns, filters, sort order, and hierarchy. If you've selected components, only those are exported.
Saving as a Report
Select Save as, then Report. The Report Builder opens with your current filters, visible columns, and sort order, ready to save and share.
Report isn't available:
In hierarchy view
While components are selected
If you don't have permission to create reports
Data Inventory for Contributors
As a Contributor, you can use everything in Finding Your Data. You can also edit components in workspaces you have edit access to, as described in Editing Your Data. A few things work differently.
Creating Components
If you can edit a workspace you've opened, select Create as described above. If you can't, you may see Document new component instead. It opens a survey where you can add the component.
Hierarchies
You can switch between List and Hierarchy on a workspace view, use Expand all and Collapse all, and select Show full hierarchy from a component type view. Where you have edit access, drag components onto a new parent to move them. Add child and Change parent aren't available.
Visualize
Select between 1 and 100 components, then select Visualize selection to open an overview of them. With one component selected, its details panel opens too.
Exporting
Select Export as and choose Excel file (data only), Excel file (import format), or JSON file. The file matches your view. If you've selected components, only those are exported.
Not Available to Contributors
These actions are only available to Admins and Writers:
The right-click menu and the ⋮ menu for selected components (Duplicate, Merge, View history, scenarios, and Delete)
Saving as a report
Visualize all, view styles, and saved viewpoints
Permissions
Data Inventory follows your existing Ardoq permissions and doesn't grant new ones:
If you can't read a workspace, component, or field, you won't see it here.
If you can't edit a component or field, you can't edit it here.
Confidential fields stay hidden unless you have access.
Your role decides which table actions you get. See the Admins and Writers and the Contributors sections above.
Tips for Working Faster
Tip 1: Fill Values by Dragging
Select a cell, then drag its corner down or up to copy the value into neighboring rows.
Tip 2: Copy and Paste From a Spreadsheet
Copy (Ctrl/Cmd + C) and paste (Ctrl/Cmd + V) work within Data Inventory and from Excel, up to 100 rows at a time. They work for references too, using component names or IDs.
Tip 3: Merge Duplicates (Admins and Writers)
Select the components, right-click, then select Merge components.
Tip 4: Select a Range With Shift
Hold Shift to extend a selection of cells, then copy, paste, or clear them in one go.








