{"id":2825,"date":"2022-10-12T14:12:51","date_gmt":"2022-10-12T06:12:51","guid":{"rendered":"https:\/\/blog.facilitybot.co\/blog\/?post_type=knowledgebase&#038;p=2825"},"modified":"2025-06-05T21:08:03","modified_gmt":"2025-06-05T13:08:03","slug":"importing-assets-from-csv-excel","status":"publish","type":"knowledgebase","link":"https:\/\/blog.facilitybot.co\/blog\/knowledge-base\/manager-web-portal\/importing-assets-from-csv-excel\/","title":{"rendered":"Importing Assets from CSV \/ Excel"},"content":{"rendered":"\n<p>FacilityBot enables facility managers to import <a href=\"https:\/\/blog.facilitybot.co\/blog\/knowledge-base\/manager-web-portal\/managing-assets\/\">a list of assets<\/a> from CSV\/Excel into FacilityBot.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to import assets from CSV file into FacilityBot\" width=\"1170\" height=\"658\" src=\"https:\/\/www.youtube.com\/embed\/rrf_c6NHTdQ?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Log in to FacilityBot Manager Portal.&nbsp;<\/li>\n\n\n\n<li>Navigate to Features then Assets.&nbsp;<\/li>\n\n\n\n<li>Click on the 3 vertical dots menu located on the upper right.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"507\" src=\"https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-1-1024x507.png\" alt=\"\" class=\"wp-image-3355\" srcset=\"https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-1-1024x507.png 1024w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-1-300x148.png 300w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-1-768x380.png 768w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-1-920x455.png 920w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-1-230x114.png 230w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-1-350x173.png 350w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-1-480x238.png 480w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-1.png 1461w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on the \u201cImport CSV\u201d to import assets.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-2-1024x576.png\" alt=\"\" class=\"wp-image-3356\" srcset=\"https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-2-1024x576.png 1024w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-2-300x169.png 300w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-2-768x432.png 768w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-2-920x517.png 920w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-2-230x129.png 230w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-2-350x197.png 350w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-2-480x270.png 480w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-2.png 1366w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>(Note: You can download the Asset Import CSV Template as a guide)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Once the template has been downloaded, populate the fields with asset data.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p>(Note: The Asset Type field is compulsory. All other fields are optional)<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"255\" src=\"https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-3-1024x255.png\" alt=\"\" class=\"wp-image-3357\" srcset=\"https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-3-1024x255.png 1024w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-3-300x75.png 300w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-3-768x192.png 768w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-3-1536x383.png 1536w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-3-920x229.png 920w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-3-230x57.png 230w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-3-350x87.png 350w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-3-480x120.png 480w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-3.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Once populated, upload the CSV\/Excel file to import the assets by clicking on the Upload button<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"615\" height=\"767\" src=\"https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-4.png\" alt=\"\" class=\"wp-image-3358\" srcset=\"https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-4.png 615w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-4-241x300.png 241w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-4-230x287.png 230w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-4-350x437.png 350w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-4-480x599.png 480w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Once the file is uploaded, the system generates a unique Asset ID QR code that is linked to the specific asset. When a responder scans this Asset ID QR code using the FacilityBot Mobile App, the asset details can be viewed including the fault reports and preventive maintenance checklists linked to that asset.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Creating Custom Asset Fields<\/h2>\n\n\n\n<p>Managers can add custom asset fields. Ideally, managers should set custom asset fields before importing the assets as the CSV import template changes when custom asset fields are added.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>To add a new custom asset field, click on the three vertical buttons then Manage Asset Field.&nbsp;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"517\" src=\"https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-5-1024x517.png\" alt=\"\" class=\"wp-image-3359\" srcset=\"https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-5-1024x517.png 1024w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-5-300x151.png 300w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-5-768x388.png 768w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-5-920x464.png 920w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-5-230x116.png 230w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-5-350x177.png 350w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-5-480x242.png 480w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-5.png 1468w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The page shows the list of asset fields. Configure additional Asset fields that you would like to store additional Asset information by clicking on the + Add Field button.&nbsp;<\/li>\n\n\n\n<li>You may also remove specific fields using the bin icon.&nbsp;<\/li>\n\n\n\n<li>The name of each field is editable. Edit the name by clicking on the pen icon.&nbsp;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"571\" src=\"https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-6-1024x571.png\" alt=\"\" class=\"wp-image-3360\" srcset=\"https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-6-1024x571.png 1024w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-6-300x167.png 300w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-6-768x428.png 768w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-6-920x513.png 920w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-6-230x128.png 230w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-6-350x195.png 350w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-6-480x268.png 480w, https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-6.png 1458w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Once completed, click Save.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p>(Note: The CSV import template changes when custom asset fields are added.)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>FacilityBot enables facility managers to import a list of assets from CSV\/Excel into FacilityBot.&nbsp; (Note: You can download the Asset Import CSV [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","knowledgebase_cat":[44],"class_list":["post-2825","knowledgebase","type-knowledgebase","status-publish","hentry","knowledgebase_cat-manager-web-portal"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Importing Assets from CSV \/ Excel - FacilityBot - Facilities Management Software<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.facilitybot.co\/blog\/knowledge-base\/manager-web-portal\/importing-assets-from-csv-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importing Assets from CSV \/ Excel - FacilityBot - Facilities Management Software\" \/>\n<meta property=\"og:description\" content=\"FacilityBot enables facility managers to import a list of assets from CSV\/Excel into FacilityBot.&nbsp; (Note: You can download the Asset Import CSV [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.facilitybot.co\/blog\/knowledge-base\/manager-web-portal\/importing-assets-from-csv-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"FacilityBot - Facilities Management Software\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-05T13:08:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-1-1024x507.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.facilitybot.co\/blog\/knowledge-base\/manager-web-portal\/importing-assets-from-csv-excel\/\",\"url\":\"https:\/\/blog.facilitybot.co\/blog\/knowledge-base\/manager-web-portal\/importing-assets-from-csv-excel\/\",\"name\":\"Importing Assets from CSV \/ Excel - FacilityBot - Facilities Management Software\",\"isPartOf\":{\"@id\":\"https:\/\/blog.facilitybot.co\/blog\/#website\"},\"datePublished\":\"2022-10-12T06:12:51+00:00\",\"dateModified\":\"2025-06-05T13:08:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.facilitybot.co\/blog\/knowledge-base\/manager-web-portal\/importing-assets-from-csv-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.facilitybot.co\/blog\/knowledge-base\/manager-web-portal\/importing-assets-from-csv-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.facilitybot.co\/blog\/knowledge-base\/manager-web-portal\/importing-assets-from-csv-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/blog.facilitybot.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Importing Assets from CSV \/ Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.facilitybot.co\/blog\/#website\",\"url\":\"https:\/\/blog.facilitybot.co\/blog\/\",\"name\":\"FacilityBot - Facilities Management Software\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/blog.facilitybot.co\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.facilitybot.co\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blog.facilitybot.co\/blog\/#organization\",\"name\":\"FacilityBot - Facilities Management Software\",\"url\":\"https:\/\/blog.facilitybot.co\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blog.facilitybot.co\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2025\/03\/fb_logo.png\",\"contentUrl\":\"https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2025\/03\/fb_logo.png\",\"width\":150,\"height\":38,\"caption\":\"FacilityBot - Facilities Management Software\"},\"image\":{\"@id\":\"https:\/\/blog.facilitybot.co\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/sg.linkedin.com\/company\/facilitybot\",\"https:\/\/www.youtube.com\/channel\/UCFykie6GjYNh4fxv2PIv8mA\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Importing Assets from CSV \/ Excel - FacilityBot - Facilities Management Software","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog.facilitybot.co\/blog\/knowledge-base\/manager-web-portal\/importing-assets-from-csv-excel\/","og_locale":"en_US","og_type":"article","og_title":"Importing Assets from CSV \/ Excel - FacilityBot - Facilities Management Software","og_description":"FacilityBot enables facility managers to import a list of assets from CSV\/Excel into FacilityBot.&nbsp; (Note: You can download the Asset Import CSV [&hellip;]","og_url":"https:\/\/blog.facilitybot.co\/blog\/knowledge-base\/manager-web-portal\/importing-assets-from-csv-excel\/","og_site_name":"FacilityBot - Facilities Management Software","article_modified_time":"2025-06-05T13:08:03+00:00","og_image":[{"url":"https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2023\/02\/import-asset-csv-1-1024x507.png"}],"twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/blog.facilitybot.co\/blog\/knowledge-base\/manager-web-portal\/importing-assets-from-csv-excel\/","url":"https:\/\/blog.facilitybot.co\/blog\/knowledge-base\/manager-web-portal\/importing-assets-from-csv-excel\/","name":"Importing Assets from CSV \/ Excel - FacilityBot - Facilities Management Software","isPartOf":{"@id":"https:\/\/blog.facilitybot.co\/blog\/#website"},"datePublished":"2022-10-12T06:12:51+00:00","dateModified":"2025-06-05T13:08:03+00:00","breadcrumb":{"@id":"https:\/\/blog.facilitybot.co\/blog\/knowledge-base\/manager-web-portal\/importing-assets-from-csv-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.facilitybot.co\/blog\/knowledge-base\/manager-web-portal\/importing-assets-from-csv-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.facilitybot.co\/blog\/knowledge-base\/manager-web-portal\/importing-assets-from-csv-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blog.facilitybot.co\/blog\/"},{"@type":"ListItem","position":2,"name":"Importing Assets from CSV \/ Excel"}]},{"@type":"WebSite","@id":"https:\/\/blog.facilitybot.co\/blog\/#website","url":"https:\/\/blog.facilitybot.co\/blog\/","name":"FacilityBot - Facilities Management Software","description":"","publisher":{"@id":"https:\/\/blog.facilitybot.co\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.facilitybot.co\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/blog.facilitybot.co\/blog\/#organization","name":"FacilityBot - Facilities Management Software","url":"https:\/\/blog.facilitybot.co\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blog.facilitybot.co\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2025\/03\/fb_logo.png","contentUrl":"https:\/\/blog.facilitybot.co\/wp-content\/uploads\/2025\/03\/fb_logo.png","width":150,"height":38,"caption":"FacilityBot - Facilities Management Software"},"image":{"@id":"https:\/\/blog.facilitybot.co\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/sg.linkedin.com\/company\/facilitybot","https:\/\/www.youtube.com\/channel\/UCFykie6GjYNh4fxv2PIv8mA"]}]}},"_links":{"self":[{"href":"https:\/\/blog.facilitybot.co\/blog\/wp-json\/wp\/v2\/knowledgebase\/2825","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.facilitybot.co\/blog\/wp-json\/wp\/v2\/knowledgebase"}],"about":[{"href":"https:\/\/blog.facilitybot.co\/blog\/wp-json\/wp\/v2\/types\/knowledgebase"}],"author":[{"embeddable":true,"href":"https:\/\/blog.facilitybot.co\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.facilitybot.co\/blog\/wp-json\/wp\/v2\/comments?post=2825"}],"version-history":[{"count":5,"href":"https:\/\/blog.facilitybot.co\/blog\/wp-json\/wp\/v2\/knowledgebase\/2825\/revisions"}],"predecessor-version":[{"id":6653,"href":"https:\/\/blog.facilitybot.co\/blog\/wp-json\/wp\/v2\/knowledgebase\/2825\/revisions\/6653"}],"wp:attachment":[{"href":"https:\/\/blog.facilitybot.co\/blog\/wp-json\/wp\/v2\/media?parent=2825"}],"wp:term":[{"taxonomy":"knowledgebase_cat","embeddable":true,"href":"https:\/\/blog.facilitybot.co\/blog\/wp-json\/wp\/v2\/knowledgebase_cat?post=2825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}