{"metadata":{"image":[],"title":"","description":""},"api":{"url":"","auth":"required","settings":"","results":{"codes":[]},"params":[]},"next":{"description":"","pages":[]},"title":"Export your ArchiSnapper data to Excel","type":"basic","slug":"export-your-archisnapper-data-to-excel","excerpt":"","body":"You can export your ArchiSnapper data to excel, for further analysis.\n\nYou can do this [from here](https://app3.archisnapper.com/sites/explain_export?lang=en) in your online ArchiSnapper account:\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/cbf2c1f-archisnapper_export_to_csv.png\",\n        \"archisnapper export to csv.png\",\n        968,\n        456,\n        \"#e1e8eb\"\n      ]\n    }\n  ]\n}\n[/block]\nNext you will receive a CSV file in your mailbox, and you can import this CSV file into an excel or google spreadsheets file:\n\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/28c2a16-Schermafbeelding_2020-03-04_om_16.27.55.png\",\n        \"Schermafbeelding 2020-03-04 om 16.27.55.png\",\n        557,\n        237,\n        \"#eaebea\"\n      ]\n    }\n  ]\n}\n[/block]\nThis will give you a file like this, with one line per observation containing all the observation details like project name, report number, report date, assignees, observation name and descriptions, links to the photos and more. \n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/adf5d0c-Schermafbeelding_2020-03-04_om_16.37.15.png\",\n        \"Schermafbeelding 2020-03-04 om 16.37.15.png\",\n        1796,\n        450,\n        \"#dddddd\"\n      ]\n    }\n  ]\n}\n[/block]\nWhile you will probably not learn a lot by simply looking at this data, you can easily use the data in this table as input for a **pivot table**:\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/089d5ef-query_in_archisnapper_data.png\",\n        \"query in archisnapper data.png\",\n        824,\n        463,\n        \"#1d2527\"\n      ]\n    }\n  ]\n}\n[/block]\nIn the pivot table you could add the (project) name in the rows, and the report dates as values as a basic example. By using Summarize by \"countunique\" for the report date field, we are counting every report only once (as all observations in the same report have exact the same report date and time).\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/a911c93-Schermafbeelding_2020-03-04_om_16.56.30.png\",\n        \"Schermafbeelding 2020-03-04 om 16.56.30.png\",\n        324,\n        686,\n        \"#0c150f\"\n      ]\n    }\n  ]\n}\n[/block]\nThis will give you the number of reports per project; \n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/0af4477-Schermafbeelding_2020-03-04_om_16.59.19.png\",\n        \"Schermafbeelding 2020-03-04 om 16.59.19.png\",\n        335,\n        157,\n        \"#e8ebee\"\n      ]\n    }\n  ]\n}\n[/block]\nIn the same manner (playing with the pivot editor) you could query the number of reports by project, user and checklist, for example:\n\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/906ffe5-Schermafbeelding_2020-03-04_om_17.14.53.png\",\n        \"Schermafbeelding 2020-03-04 om 17.14.53.png\",\n        304,\n        907,\n        \"#cccbca\"\n      ]\n    }\n  ]\n}\n[/block]\nOr, you could query the number of times a certain observation occurs or the number of items for a certain assignee, etc. \n\nQuestions? support:::at:::archisnapper.com","updates":[],"order":32,"isReference":false,"hidden":false,"sync_unique":"","link_url":"","link_external":false,"_id":"5e5fd4f4ab0b7a0074056e76","createdAt":"2020-03-04T16:19:00.293Z","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}

Export your ArchiSnapper data to Excel


You can export your ArchiSnapper data to excel, for further analysis. You can do this [from here](https://app3.archisnapper.com/sites/explain_export?lang=en) in your online ArchiSnapper account: [block:image] { "images": [ { "image": [ "https://files.readme.io/cbf2c1f-archisnapper_export_to_csv.png", "archisnapper export to csv.png", 968, 456, "#e1e8eb" ] } ] } [/block] Next you will receive a CSV file in your mailbox, and you can import this CSV file into an excel or google spreadsheets file: [block:image] { "images": [ { "image": [ "https://files.readme.io/28c2a16-Schermafbeelding_2020-03-04_om_16.27.55.png", "Schermafbeelding 2020-03-04 om 16.27.55.png", 557, 237, "#eaebea" ] } ] } [/block] This will give you a file like this, with one line per observation containing all the observation details like project name, report number, report date, assignees, observation name and descriptions, links to the photos and more. [block:image] { "images": [ { "image": [ "https://files.readme.io/adf5d0c-Schermafbeelding_2020-03-04_om_16.37.15.png", "Schermafbeelding 2020-03-04 om 16.37.15.png", 1796, 450, "#dddddd" ] } ] } [/block] While you will probably not learn a lot by simply looking at this data, you can easily use the data in this table as input for a **pivot table**: [block:image] { "images": [ { "image": [ "https://files.readme.io/089d5ef-query_in_archisnapper_data.png", "query in archisnapper data.png", 824, 463, "#1d2527" ] } ] } [/block] In the pivot table you could add the (project) name in the rows, and the report dates as values as a basic example. By using Summarize by "countunique" for the report date field, we are counting every report only once (as all observations in the same report have exact the same report date and time). [block:image] { "images": [ { "image": [ "https://files.readme.io/a911c93-Schermafbeelding_2020-03-04_om_16.56.30.png", "Schermafbeelding 2020-03-04 om 16.56.30.png", 324, 686, "#0c150f" ] } ] } [/block] This will give you the number of reports per project; [block:image] { "images": [ { "image": [ "https://files.readme.io/0af4477-Schermafbeelding_2020-03-04_om_16.59.19.png", "Schermafbeelding 2020-03-04 om 16.59.19.png", 335, 157, "#e8ebee" ] } ] } [/block] In the same manner (playing with the pivot editor) you could query the number of reports by project, user and checklist, for example: [block:image] { "images": [ { "image": [ "https://files.readme.io/906ffe5-Schermafbeelding_2020-03-04_om_17.14.53.png", "Schermafbeelding 2020-03-04 om 17.14.53.png", 304, 907, "#cccbca" ] } ] } [/block] Or, you could query the number of times a certain observation occurs or the number of items for a certain assignee, etc. Questions? [email protected]