Mandatory fields in the bulk import spreadsheets
A list of the mandatory fields in the model, asset, and model and asset templates for bulk import in the Enterprise Asset Workspace.
Mandatory fields for model template
|
Field/column |
Mandatory for creating models |
Mandatory for updating models |
|---|---|---|
|
IndexNote: Representing the row number can be used to identify a specific row. However, you must fill this in manually. |
Yes |
Yes |
|
Manufacturer |
Yes |
Yes |
|
Model Name |
Yes |
Yes |
|
Model Number |
Yes |
Yes |
|
Model category |
Yes |
Yes |
|
Model type |
Yes |
Yes |
|
Parent model manufacturer |
YesNote: Not applicable for single models. |
No |
|
Parent model name |
YesNote: Not applicable for single models. |
No |
|
Parent model number |
YesNote: Not applicable for single models. |
No |
|
Component number |
YesNote: Not applicable for single models. |
No |
|
Component quantity |
YesNote: Not applicable for single models. |
No |
|
Required |
YesNote: Not applicable for single models. |
No |
|
Hot swappable |
YesNote: Not applicable for single models. |
No |
|
Repairable |
YesNote: Not applicable for single models. |
No |
|
Field/column |
Mandatory for creating assets |
Mandatory for updating assets |
|---|---|---|
|
IndexNote: Representing the row number can be used to identify a specific row. However, you must fill this in manually. |
Yes |
Yes |
|
Manufacturer |
Yes |
Yes |
|
Model |
Yes |
Yes |
|
Model Name |
Yes |
Yes |
|
Model Number |
Yes |
Yes |
|
Parent model manufacturer |
YesNote: Not applicable for single assets. |
YesNote: Not applicable for single assets. |
|
Parent model name |
YesNote: Not applicable for single assets. |
YesNote: Not applicable for single assets. |
|
Parent model number |
YesNote: Not applicable for single assets. |
YesNote: Not applicable for single assets. |
|
Component number |
YesNote: Not applicable for single assets. |
Yes |
|
Asset Tag |
ConditionalNote: At least one unique identifier is required for non-consumables based on model category. |
ConditionalNote: At least one unique identifier is required for non-consumables based on model category. |
|
Serial Number |
ConditionalNote: At least one unique identifier is required for non-consumables based on model category. |
ConditionalNote: At least one unique identifier is required for non-consumables based on model category. |
|
MAC Address |
ConditionalNote: At least one unique identifier is required for non-consumables based on model category. |
ConditionalNote: At least one unique identifier is required for non-consumables based on model category. |
|
Parent asset |
ConditionalNote: Required for child assets when parent model information is provided. |
ConditionalNote: Required for child assets when parent model information is provided. |
|
Quantity |
ConditionalNote: Required for consumable assets (positive number). |
NoNote: Consumable assets cannot be updated. |
|
State |
Yes |
No |
|
Sub state |
Yes |
No |
|
Stockroom |
ConditionalNote: Required for In stock and Build states. |
ConditionalNote: Required for In stock and Build states. |
|
Location |
ConditionalNote: Required for In stock, In use, and Build states. |
ConditionalNote: Required for In stock, In use, and Build states. |
|
Install status |
Yes |
Yes |
|
Substatus |
ConditionalNote: Required for In stock state only. |
ConditionalNote: Required for In stock state only. |
|
Component ID |
ConditionalNote: Required for child assets when applicable. |
No |
|
OT entity |
ConditionalNote: Required as true for hardware models when the OT Asset Management application is activated. |
ConditionalNote: Required as true for hardware models when the OT Asset Management application is activated. |
|
Field/column |
Mandatory for creating models and assets |
Mandatory for updating models and assets |
|---|---|---|
|
IndexNote: Representing the row number can be used to identify a specific row. However, you must fill this in manually. |
Yes |
Yes |
|
Manufacturer |
Yes |
Yes |
|
Model Name |
Yes |
Yes |
|
Model Number |
Yes |
Yes |
|
Model category |
Yes |
Yes |
|
Model type |
Yes |
Yes |
|
Parent model manufacturer |
YesNote: Not applicable for single models and single assets. |
Yes |
|
Parent model name |
YesNote: Not applicable for single models and single assets. |
Yes |
|
Parent model number |
YesNote: Not applicable for single models and single assets. |
Yes |
|
Component number |
YesNote: Not applicable for single models and single assets. |
No |
|
Component quantity |
YesNote: Not applicable for single models and single assets. |
No |
|
Required |
YesNote: Not applicable for single models and single assets. |
No |
|
Hot swappable |
YesNote: Not applicable for single models and single assets. |
No |
|
Repairable |
YesNote: Not applicable for single models and single assets. |
No |
|
Asset Tag |
ConditionalNote: At least one unique identifier is required for non-consumables based on model category. |
ConditionalNote: At least one unique identifier is required for non-consumables based on model category. |
|
Serial Number |
ConditionalNote: At least one unique identifier is required for non-consumables based on model category. |
ConditionalNote: At least one unique identifier is required for non-consumables based on model category. |
|
MAC Address |
ConditionalNote: At least one unique identifier is required for non-consumables based on model category. |
ConditionalNote: At least one unique identifier is required for non-consumables based on model category. |
|
Parent asset |
YesNote: Not applicable for single models and single assets. |
No |
|
Quantity |
Yes |
No |
|
State |
Yes |
No |
|
Sub state |
Yes |
No |
|
Stockroom |
ConditionalNote: Required for In stock and Build states. |
ConditionalNote: Required for In stock and Build states. |
|
Location |
ConditionalNote: Required for In stock, In use, and Build states. |
ConditionalNote: Required for In stock, In use, and Build states. |
|
Field/column |
Mandatory for creating models |
Mandatory for updating models |
|---|---|---|
|
Dimensions Unit |
ConditionalNote: Required if length, width, height, or depth is provided. |
ConditionalNote: Required if length, width, height, or depth is provided. |
|
Weight Unit |
ConditionalNote: Required if the weight_decimal value is provided. |
ConditionalNote: Required if the weight_decimal value is provided. |
|
Volume Unit |
ConditionalNote: Required if the volume is provided. |
ConditionalNote: Required if the volume is provided. |
|
Current Unit |
ConditionalNote: Required if the value is provided for Current. |
ConditionalNote: Required if the value is provided for Current. |
|
Power Unit |
ConditionalNote: Required if the rated_power value is provided. |
ConditionalNote: Required if rated_power is provided. |
|
Voltage Unit |
ConditionalNote: Required if the voltage value is provided. |
ConditionalNote: Required if voltage is provided. |
|
Cooling Unit |
ConditionalNote: Required if the cooling value is provided (Enterprise models only). |
ConditionalNote: Required if the cooling value is provided (Enterprise models only). |
|
Pressure Unit |
ConditionalNote: Required if the pressure value is provided (Enterprise models only). |
ConditionalNote: Required if the pressure value is provided (Enterprise models only). |
|
Temperature Unit |
ConditionalNote: Required if the temperature value is provided (Enterprise models only). |
ConditionalNote: Required if the temperature value is provided (Enterprise models only). |
The values entered in the following columns must exist in the database:
- Manufacturer
- Model failure impact
- Model failure likelihood
- Owner
- Stockroom
- Location
- Managed by
- Owned by
- Reserved for
- Supported by
- Vendor
- Asset failure impact
- Asset failure likelihood
Parent Topic:Enterprise Asset Management reference
Related topics
Domain separation and Enterprise Asset Management
Components installed with Enterprise Asset Management
Asset fields for enterprise assets
Asset audit fields for enterprise assets
Enterprise model categories and corresponding classes
Normalization status for enterprise models
Model fields for Enterprise Asset Management
Contract fields for Enterprise Asset Management
Maintenance plan fields for Enterprise Asset Management
Maintenance schedule fields for Enterprise Asset Management
Work plan fields for Enterprise Asset Management
Work plan schedule fields for Enterprise Asset Management
Expense line fields for Enterprise Asset Management
Fields inherited from a parent asset group to a sub group
Enterprise asset disposal order stages
Scheduled jobs and tables installed with normalization of firmware models
--- title: Mandatory fields in the bulk import spreadsheets description: A list of the mandatory fields in the model, asset, and model and asset templates for bulk import in the Enterprise Asset Workspace. locale: en-US canonical_url: https://www.servicenow.com/docs/r/it-asset-management/enterprise-asset-management/mandatory-bulk-fields.html release: brazil product: Enterprise Asset Management classification: enterprise-asset-management topic_type: reference last_updated: "2026-09-10" reading_time_minutes: 7 breadcrumb: [Enterprise Asset Management reference, Enterprise Asset Management, Asset Management] --- # Mandatory fields in the bulk import spreadsheets A list of the mandatory fields in the model, asset, and model and asset templates for bulk import in the Enterprise Asset Workspace. ## Mandatory fields for model template <table id="table_eh1_gx2_3xb"><thead><tr><th> Field/column </th><th> Mandatory for creating models </th><th> Mandatory for updating models </th></tr></thead><tbody><tr><td> Index**Note:** Representing the row number can be used to identify a specific row. However, you must fill this in manually. </td><td> Yes </td><td> Yes </td></tr><tr><td> Manufacturer </td><td> Yes </td><td> Yes </td></tr><tr><td> Model Name </td><td> Yes </td><td> Yes </td></tr><tr><td> Model Number </td><td> Yes </td><td> Yes </td></tr><tr><td> Model category </td><td> Yes </td><td> Yes </td></tr><tr><td> Model type </td><td> Yes </td><td> Yes </td></tr><tr><td> Parent model manufacturer </td><td> Yes**Note:** Not applicable for single models. </td><td> No </td></tr><tr><td> Parent model name </td><td> Yes**Note:** Not applicable for single models. </td><td> No </td></tr><tr><td> Parent model number </td><td> Yes**Note:** Not applicable for single models. </td><td> No </td></tr><tr><td> Component number </td><td> Yes**Note:** Not applicable for single models. </td><td> No </td></tr><tr><td> Component quantity </td><td> Yes**Note:** Not applicable for single models. </td><td> No </td></tr><tr><td> Required </td><td> Yes**Note:** Not applicable for single models. </td><td> No </td></tr><tr><td> Hot swappable </td><td> Yes**Note:** Not applicable for single models. </td><td> No </td></tr><tr><td> Repairable </td><td> Yes**Note:** Not applicable for single models. </td><td> No </td></tr></tbody> </table>## Mandatory fields for asset template <table id="table_bqz_psg_3xb"><thead><tr><th> Field/column </th><th> Mandatory for creating assets </th><th> Mandatory for updating assets </th></tr></thead><tbody><tr><td> Index**Note:** Representing the row number can be used to identify a specific row. However, you must fill this in manually. </td><td> Yes </td><td> Yes </td></tr><tr><td> Manufacturer </td><td> Yes </td><td> Yes </td></tr><tr><td> Model </td><td> Yes </td><td> Yes </td></tr><tr><td> Model Name </td><td> Yes </td><td> Yes </td></tr><tr><td> Model Number </td><td> Yes </td><td> Yes </td></tr><tr><td> Parent model manufacturer </td><td> Yes**Note:** Not applicable for single assets. </td><td> Yes**Note:** Not applicable for single assets. </td></tr><tr><td> Parent model name </td><td> Yes**Note:** Not applicable for single assets. </td><td> Yes**Note:** Not applicable for single assets. </td></tr><tr><td> Parent model number </td><td> Yes**Note:** Not applicable for single assets. </td><td> Yes**Note:** Not applicable for single assets. </td></tr><tr><td> Component number </td><td> Yes**Note:** Not applicable for single assets. </td><td> Yes </td></tr><tr><td> Asset Tag </td><td> Conditional**Note:** At least one unique identifier is required for non-consumables based on model category. </td><td> Conditional**Note:** At least one unique identifier is required for non-consumables based on model category. </td></tr><tr><td> Serial Number </td><td> Conditional**Note:** At least one unique identifier is required for non-consumables based on model category. </td><td> Conditional**Note:** At least one unique identifier is required for non-consumables based on model category. </td></tr><tr><td> MAC Address </td><td> Conditional**Note:** At least one unique identifier is required for non-consumables based on model category. </td><td> Conditional**Note:** At least one unique identifier is required for non-consumables based on model category. </td></tr><tr><td> Parent asset </td><td> Conditional**Note:** Required for child assets when parent model information is provided. </td><td> Conditional**Note:** Required for child assets when parent model information is provided. </td></tr><tr><td> Quantity </td><td> Conditional**Note:** Required for consumable assets \(positive number\). </td><td> No**Note:** Consumable assets cannot be updated. </td></tr><tr><td> State </td><td> Yes </td><td> No </td></tr><tr><td> Sub state </td><td> Yes </td><td> No </td></tr><tr><td> Stockroom </td><td> Conditional**Note:** Required for In stock and Build states. </td><td> Conditional**Note:** Required for In stock and Build states. </td></tr><tr><td> Location </td><td> Conditional**Note:** Required for In stock, In use, and Build states. </td><td> Conditional**Note:** Required for In stock, In use, and Build states. </td></tr><tr><td> Install status </td><td> Yes </td><td> Yes </td></tr><tr><td> Substatus </td><td> Conditional**Note:** Required for In stock state only. </td><td> Conditional**Note:** Required for In stock state only. </td></tr><tr><td> Component ID </td><td> Conditional**Note:** Required for child assets when applicable. </td><td> No </td></tr><tr><td> OT entity </td><td> Conditional**Note:** Required as **true** for hardware models when the OT Asset Management application is activated. </td><td> Conditional**Note:** Required as **true** for hardware models when the OT Asset Management application is activated. </td></tr></tbody> </table>## Mandatory fields for model and asset template <table id="table_ukz_yyj_3xb"><thead><tr><th> Field/column </th><th> Mandatory for creating models and assets </th><th> Mandatory for updating models and assets </th></tr></thead><tbody><tr><td> Index**Note:** Representing the row number can be used to identify a specific row. However, you must fill this in manually. </td><td> Yes </td><td> Yes </td></tr><tr><td> Manufacturer </td><td> Yes </td><td> Yes </td></tr><tr><td> Model Name </td><td> Yes </td><td> Yes </td></tr><tr><td> Model Number </td><td> Yes </td><td> Yes </td></tr><tr><td> Model category </td><td> Yes </td><td> Yes </td></tr><tr><td> Model type </td><td> Yes </td><td> Yes </td></tr><tr><td> Parent model manufacturer </td><td> Yes**Note:** Not applicable for single models and single assets. </td><td> Yes </td></tr><tr><td> Parent model name </td><td> Yes**Note:** Not applicable for single models and single assets. </td><td> Yes </td></tr><tr><td> Parent model number </td><td> Yes**Note:** Not applicable for single models and single assets. </td><td> Yes </td></tr><tr><td> Component number </td><td> Yes**Note:** Not applicable for single models and single assets. </td><td> No </td></tr><tr><td> Component quantity </td><td> Yes**Note:** Not applicable for single models and single assets. </td><td> No </td></tr><tr><td> Required </td><td> Yes**Note:** Not applicable for single models and single assets. </td><td> No </td></tr><tr><td> Hot swappable </td><td> Yes**Note:** Not applicable for single models and single assets. </td><td> No </td></tr><tr><td> Repairable </td><td> Yes**Note:** Not applicable for single models and single assets. </td><td> No </td></tr><tr><td> Asset Tag </td><td> Conditional**Note:** At least one unique identifier is required for non-consumables based on model category. </td><td> Conditional**Note:** At least one unique identifier is required for non-consumables based on model category. </td></tr><tr><td> Serial Number </td><td> Conditional**Note:** At least one unique identifier is required for non-consumables based on model category. </td><td> Conditional**Note:** At least one unique identifier is required for non-consumables based on model category. </td></tr><tr><td> MAC Address </td><td> Conditional**Note:** At least one unique identifier is required for non-consumables based on model category. </td><td> Conditional**Note:** At least one unique identifier is required for non-consumables based on model category. </td></tr><tr><td> Parent asset </td><td> Yes**Note:** Not applicable for single models and single assets. </td><td> No </td></tr><tr><td> Quantity </td><td> Yes </td><td> No </td></tr><tr><td> State </td><td> Yes </td><td> No </td></tr><tr><td> Sub state </td><td> Yes </td><td> No </td></tr><tr><td> Stockroom </td><td> Conditional**Note:** Required for In stock and Build states. </td><td> Conditional**Note:** Required for In stock and Build states. </td></tr><tr><td> Location </td><td> Conditional**Note:** Required for In stock, In use, and Build states. </td><td> Conditional**Note:** Required for In stock, In use, and Build states. </td></tr></tbody> </table>## Unit of measurement fields <table id="table_ult_2sm_ngc"><thead><tr><th> Field/column </th><th> Mandatory for creating models </th><th> Mandatory for updating models </th></tr></thead><tbody><tr><td> Dimensions Unit </td><td> Conditional**Note:** Required if length, width, height, or depth is provided. </td><td> Conditional**Note:** Required if length, width, height, or depth is provided. </td></tr><tr><td> Weight Unit </td><td> Conditional**Note:** Required if the weight\_decimal value is provided. </td><td> Conditional**Note:** Required if the weight\_decimal value is provided. </td></tr><tr><td> Volume Unit </td><td> Conditional**Note:** Required if the volume is provided. </td><td> Conditional**Note:** Required if the volume is provided. </td></tr><tr><td> Current Unit </td><td> Conditional**Note:** Required if the value is provided for Current. </td><td> Conditional**Note:** Required if the value is provided for Current. </td></tr><tr><td> Power Unit </td><td> Conditional**Note:** Required if the rated\_power value is provided. </td><td> Conditional**Note:** Required if rated\_power is provided. </td></tr><tr><td> Voltage Unit </td><td> Conditional**Note:** Required if the voltage value is provided. </td><td> Conditional**Note:** Required if voltage is provided. </td></tr><tr><td> Cooling Unit </td><td> Conditional**Note:** Required if the cooling value is provided \(Enterprise models only\). </td><td> Conditional**Note:** Required if the cooling value is provided \(Enterprise models only\). </td></tr><tr><td> Pressure Unit </td><td> Conditional**Note:** Required if the pressure value is provided \(Enterprise models only\). </td><td> Conditional**Note:** Required if the pressure value is provided \(Enterprise models only\). </td></tr><tr><td> Temperature Unit </td><td> Conditional**Note:** Required if the temperature value is provided \(Enterprise models only\). </td><td> Conditional**Note:** Required if the temperature value is provided \(Enterprise models only\). </td></tr></tbody> </table>## Reference fields validation The values entered in the following columns must exist in the database: - Manufacturer - Model failure impact - Model failure likelihood - Owner - Stockroom - Location - Managed by - Owned by - Reserved for - Supported by - Vendor - Asset failure impact - Asset failure likelihood **Parent Topic:**[Enterprise Asset Management reference](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/brazil/markdown/it-asset-management/enterprise-asset-management/reference-enterprise-asset-management.md) **Related topics** [Domain separation and Enterprise Asset Management]() [Components installed with Enterprise Asset Management]() [OT Asset Workspace roles]() [Asset fields for enterprise assets]() [Asset audit fields for enterprise assets]() [Audit results]() [Enterprise model categories and corresponding classes]() [Normalization status for enterprise models]() [Model fields for Enterprise Asset Management]() [Contract fields for Enterprise Asset Management]() [Maintenance plan fields for Enterprise Asset Management]() [Maintenance schedule fields for Enterprise Asset Management]() [Work plan fields for Enterprise Asset Management]() [Work plan schedule fields for Enterprise Asset Management]() [Expense line fields for Enterprise Asset Management]() [Fields inherited from a parent asset group to a sub group]() [Enterprise asset disposal order stages]() [Terminology for linear assets]() [Scheduled jobs and tables installed with normalization of firmware models]() [Asset put away task fields]()
| title | Mandatory fields in the bulk import spreadsheets |
| description | A list of the mandatory fields in the model, asset, and model and asset templates for bulk import in the Enterprise Asset Workspace. |
| locale | en-US |
| canonical_url | https://www.servicenow.com/docs/r/it-asset-management/enterprise-asset-management/mandatory-bulk-fields.html |
| release | brazil |
| product | Enterprise Asset Management |
| classification | enterprise-asset-management |
| topic_type | reference |
| last_updated | 2026-09-10 |
| reading_time_minutes | 7 |
| breadcrumb | Enterprise Asset Management referenceEnterprise Asset ManagementAsset Management |