{"metadata":{"image":[],"title":"","description":""},"api":{"url":"","auth":"never","settings":"","params":[],"results":{"codes":[]}},"next":{"description":"","pages":[]},"title":"Excel import for checklists","type":"basic","slug":"excel-import-for-checklists","excerpt":"","body":"You can create checklists from the online ArchiSnapper account, or you can draft your checklists in excel and then import them into ArchiSnapper. \n\nIf you want to import your checklist from excel, it's important that you use *exactly the same columns* as in the sample file. \n\nLet's walk you through this ;)\n\n[block:api-header]\n{\n  \"title\": \"1. Go to the Checklist section in ArchiSnapper\"\n}\n[/block]\n* Navigate to the [Categories/Checklist](https://app3.archisnapper.com/checklists?doc_checklists=false&lang=en) section\n* Click on the 'checklists' tab.\n* You'll see the screen below -- click on **'import a checklist via Excel'**\n\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/b99eb0b-checklist_import_excel.png\",\n        \"checklist import excel.png\",\n        1280,\n        740,\n        \"#0a1012\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"title\": \"2. Download the sample checklist file\"\n}\n[/block]\n[On this page](https://app3.archisnapper.com/checklist_excel_files/new?doc_checklists=false&lang=en) you can download a sample Excel file. We strongly advise you use this sample file.\n\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/828915d-2.png\",\n        \"2.png\",\n        1280,\n        740,\n        \"#0a0d0d\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"title\": \"3. Complete the sample file with your own categories, checklist items and standard descriptions\"\n}\n[/block]\nTo give you an idea, look at the image below. This is the sample file uploaded without making any changes. Now you know where your categories, checklist items and standard descriptions will appear.\n\n**Important:** As you can see in the sample excel file, the checklist items for a category are in the cells to the right and below that category (and the same for the standard descriptions that belong to a checklist item).\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/82cdf22-5.png\",\n        \"5.png\",\n        1280,\n        740,\n        \"#0a0b0c\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"title\": \"4. Import your Excel file\"\n}\n[/block]\n* Choose a name for your checklist\n* Click on the 'browse' button\n* Select the right file on your computer to upload\n* Click on 'import checklist'\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/97e578f-3.png\",\n        \"3.png\",\n        1280,\n        740,\n        \"#0a0d0d\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"title\": \"5. Verify your uploaded checklist\"\n}\n[/block]\n* Click on 'back to my checklists'\n* Your uploaded checklist will now appear in your list of checklists\n* Open the checklist to verify if the checklist looks OK\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/61805d4-checklist_import_excel1.png\",\n        \"checklist import excel(1).png\",\n        1280,\n        740,\n        \"#0a0d0d\"\n      ]\n    }\n  ]\n}\n[/block]\nTadaam. You're all set.\n[block:api-header]\n{\n  \"title\": \"Also read:\"\n}\n[/block]\n* [Working with checklists](doc:working-with-checklists) \n* [How to create punch lists with ArchiSnapper - using the checklist functionality](doc:how-to-manage-punch-lists-using-the-checklist-functionality) \n* [How to create daily reports with ArchiSnapper - using the checklist functionality](doc:how-to-create-daily-reports-with-archisnapper-using-the-checklist-functionality) \n* [How to create safety inspection reports with ArchiSnapper - using the checklist functionality](doc:how-to-create-safety-inspection-reports-with-archisnapper-using-the-checklist-functionality)  \n\nIf you have any questions, email us at [support:::at:::archisnapper.com](mailto:[email protected]), we're here to help!","updates":[],"order":34,"isReference":false,"hidden":false,"sync_unique":"","link_url":"","link_external":false,"_id":"5e9f415a9a9f050020b8580f","createdAt":"2020-04-21T18:54:18.649Z","user":"54870d54f907080b00fc49cd","category":{"sync":{"isSync":false,"url":""},"pages":[],"title":"More features","slug":"more-features","order":1,"from_sync":false,"reference":false,"_id":"583e9d764ced340f00b05a5c","project":"54870ea47810260b001c36ab","version":"54870ea57810260b001c36ae","createdAt":"2016-11-30T09:35:50.177Z","__v":0},"version":{"version":"1.0","version_clean":"1.0.0","codename":"","is_stable":true,"is_beta":false,"is_hidden":false,"is_deprecated":false,"categories":["54870ea57810260b001c36af","5487116f7810260b001c36b5","548711797810260b001c36b6","548711807810260b001c36b7","548713127810260b001c36bd","548713247810260b001c36be","548713aa7810260b001c36c0","548713c2f907080b00fc49d5","548713eef907080b00fc49d9","54871a0db3441a1f00f20d78","54871b15b3441a1f00f20d7e","54871cbeb3441a1f00f20d87","548817fac178b40b00aa2eec","558a6dd975eaf50d004e4bf5","558a6e37dbe5b63700f8d1fe","56795d8c07bf6a0d0083ee9e","583e9d764ced340f00b05a5c","5d1f3f70b4648901728803b7","5d22f7db4c9e14005111e34f","5d22fa62a541770012a07464"],"_id":"54870ea57810260b001c36ae","createdAt":"2014-12-09T15:00:53.237Z","project":"54870ea47810260b001c36ab","releaseDate":"2014-12-09T15:00:53.237Z","__v":20},"project":"54870ea47810260b001c36ab","__v":0,"parentDoc":null}

Excel import for checklists


You can create checklists from the online ArchiSnapper account, or you can draft your checklists in excel and then import them into ArchiSnapper. If you want to import your checklist from excel, it's important that you use *exactly the same columns* as in the sample file. Let's walk you through this ;) [block:api-header] { "title": "1. Go to the Checklist section in ArchiSnapper" } [/block] * Navigate to the [Categories/Checklist](https://app3.archisnapper.com/checklists?doc_checklists=false&lang=en) section * Click on the 'checklists' tab. * You'll see the screen below -- click on **'import a checklist via Excel'** [block:image] { "images": [ { "image": [ "https://files.readme.io/b99eb0b-checklist_import_excel.png", "checklist import excel.png", 1280, 740, "#0a1012" ] } ] } [/block] [block:api-header] { "title": "2. Download the sample checklist file" } [/block] [On this page](https://app3.archisnapper.com/checklist_excel_files/new?doc_checklists=false&lang=en) you can download a sample Excel file. We strongly advise you use this sample file. [block:image] { "images": [ { "image": [ "https://files.readme.io/828915d-2.png", "2.png", 1280, 740, "#0a0d0d" ] } ] } [/block] [block:api-header] { "title": "3. Complete the sample file with your own categories, checklist items and standard descriptions" } [/block] To give you an idea, look at the image below. This is the sample file uploaded without making any changes. Now you know where your categories, checklist items and standard descriptions will appear. **Important:** As you can see in the sample excel file, the checklist items for a category are in the cells to the right and below that category (and the same for the standard descriptions that belong to a checklist item). [block:image] { "images": [ { "image": [ "https://files.readme.io/82cdf22-5.png", "5.png", 1280, 740, "#0a0b0c" ] } ] } [/block] [block:api-header] { "title": "4. Import your Excel file" } [/block] * Choose a name for your checklist * Click on the 'browse' button * Select the right file on your computer to upload * Click on 'import checklist' [block:image] { "images": [ { "image": [ "https://files.readme.io/97e578f-3.png", "3.png", 1280, 740, "#0a0d0d" ] } ] } [/block] [block:api-header] { "title": "5. Verify your uploaded checklist" } [/block] * Click on 'back to my checklists' * Your uploaded checklist will now appear in your list of checklists * Open the checklist to verify if the checklist looks OK [block:image] { "images": [ { "image": [ "https://files.readme.io/61805d4-checklist_import_excel1.png", "checklist import excel(1).png", 1280, 740, "#0a0d0d" ] } ] } [/block] Tadaam. You're all set. [block:api-header] { "title": "Also read:" } [/block] * [Working with checklists](doc:working-with-checklists) * [How to create punch lists with ArchiSnapper - using the checklist functionality](doc:how-to-manage-punch-lists-using-the-checklist-functionality) * [How to create daily reports with ArchiSnapper - using the checklist functionality](doc:how-to-create-daily-reports-with-archisnapper-using-the-checklist-functionality) * [How to create safety inspection reports with ArchiSnapper - using the checklist functionality](doc:how-to-create-safety-inspection-reports-with-archisnapper-using-the-checklist-functionality) If you have any questions, email us at [[email protected]](mailto:[email protected]), we're here to help!