{"__v":6,"_id":"5633034538f8aa0d00d31002","category":{"__v":21,"_id":"5614a5076ebd340d006a1bd0","pages":["5614a5086ebd340d006a1bd2","5614a68fb283fb0d00a487d5","5614aab0163a7d2100ab5f02","563301637b563e0d00904900","56330184b904a10d0032f797","563302048c9cda0d002526ff","5633020e62c48a0d00334df3","5633022c10b6040d0087946b","5633024010b6040d0087946d","5633026fb904a10d0032f799","5633034538f8aa0d00d31002","5633035062c48a0d00334df5","5633036949e16d0d00122537","5633037b38f8aa0d00d31005","5633038d38f8aa0d00d31007","5633039bb904a10d0032f79b","56330b63b904a10d0032f7a6","56330e587b563e0d00904908","56370adb0704070d00f06c0c","563bc913dfa1282b000dd33e","56ad51b279011b0d00c32aba"],"project":"5614a5066ebd340d006a1bcc","version":"5614a5076ebd340d006a1bcf","sync":{"url":"","isSync":false},"reference":false,"createdAt":"2015-10-07T04:52:23.567Z","from_sync":false,"order":1,"slug":"reference","title":"Reference"},"parentDoc":null,"project":"5614a5066ebd340d006a1bcc","user":"5614a4b8b283fb0d00a487d3","version":{"__v":5,"_id":"5614a5076ebd340d006a1bcf","project":"5614a5066ebd340d006a1bcc","createdAt":"2015-10-07T04:52:23.031Z","releaseDate":"2015-10-07T04:52:23.031Z","categories":["5614a5076ebd340d006a1bd0","5614aa6253a1830d0098e962","5633048649e16d0d00122539","563305b08c9cda0d00252704","563305dc8c9cda0d00252705"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"1.0.0","version":"1.0"},"updates":[],"next":{"pages":[],"description":""},"createdAt":"2015-10-30T05:42:29.310Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":11,"body":"Fieldbook can import and export data in CSV format.\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"What's a CSV?\"\n}\n[/block]\n“CSV” stands for Comma-Separated Values. It's a format that spreadsheet programs support. To export a CSV from your spreadsheet, choose a sheet and “Save as” or “Download as” CSV.\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Creating a new book from a CSV file\"\n}\n[/block]\nYou can create a new book from a CSV file on the main book list:\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/xtNhC9IXRL6oTfsJBcJs_Screen%20Shot%202015-11-03%20at%201.55.10%20PM.png\",\n        \"Screen Shot 2015-11-03 at 1.55.10 PM.png\",\n        \"1084\",\n        \"159\",\n        \"#405f3a\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\nYou can also just drag and drop a CSV file onto the list.\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Importing a CSV into an existing book\"\n}\n[/block]\nYou can import a CSV file into an existing book to create a new sheet.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/XCyXWSOGQVuOiZumtOpG_Screen%20Shot%202015-11-03%20at%201.55.59%20PM.png\",\n        \"Screen Shot 2015-11-03 at 1.55.59 PM.png\",\n        \"238\",\n        \"319\",\n        \"#3ba642\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n(Right now you can't import a CSV into an existing sheet.)\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"CSV import tips\"\n}\n[/block]\nFor a clean import:\n\n* Make sure the first row of your CSV contains the column headers.\n* Eliminate:\n    - blank lines\n    - blank columns\n    - totals rows\n    - anything else that doesn't fit the core grid of data\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Exporting a CSV\"\n}\n[/block]\nYou can download any sheet, view or report in Fieldbook as a CSV, just choose this option from the menu next to the book title:\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/glbUuVpQ4KMSV3auycYN_Screen%20Shot%202015-11-03%20at%201.46.53%20PM.png\",\n        \"Screen Shot 2015-11-03 at 1.46.53 PM.png\",\n        \"686\",\n        \"270\",\n        \"#31a346\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Import/export via API\"\n}\n[/block]\nYou can also use [our API](doc:api) to import or export data programatically. Check out our [API documentation](https://github.com/fieldbook/api-docs) to get started.","excerpt":"","slug":"import-and-export","type":"basic","title":"Import & export"}
Fieldbook can import and export data in CSV format. [block:api-header] { "type": "basic", "title": "What's a CSV?" } [/block] “CSV” stands for Comma-Separated Values. It's a format that spreadsheet programs support. To export a CSV from your spreadsheet, choose a sheet and “Save as” or “Download as” CSV. [block:api-header] { "type": "basic", "title": "Creating a new book from a CSV file" } [/block] You can create a new book from a CSV file on the main book list: [block:image] { "images": [ { "image": [ "https://files.readme.io/xtNhC9IXRL6oTfsJBcJs_Screen%20Shot%202015-11-03%20at%201.55.10%20PM.png", "Screen Shot 2015-11-03 at 1.55.10 PM.png", "1084", "159", "#405f3a", "" ] } ] } [/block] You can also just drag and drop a CSV file onto the list. [block:api-header] { "type": "basic", "title": "Importing a CSV into an existing book" } [/block] You can import a CSV file into an existing book to create a new sheet. [block:image] { "images": [ { "image": [ "https://files.readme.io/XCyXWSOGQVuOiZumtOpG_Screen%20Shot%202015-11-03%20at%201.55.59%20PM.png", "Screen Shot 2015-11-03 at 1.55.59 PM.png", "238", "319", "#3ba642", "" ] } ] } [/block] (Right now you can't import a CSV into an existing sheet.) [block:api-header] { "type": "basic", "title": "CSV import tips" } [/block] For a clean import: * Make sure the first row of your CSV contains the column headers. * Eliminate: - blank lines - blank columns - totals rows - anything else that doesn't fit the core grid of data [block:api-header] { "type": "basic", "title": "Exporting a CSV" } [/block] You can download any sheet, view or report in Fieldbook as a CSV, just choose this option from the menu next to the book title: [block:image] { "images": [ { "image": [ "https://files.readme.io/glbUuVpQ4KMSV3auycYN_Screen%20Shot%202015-11-03%20at%201.46.53%20PM.png", "Screen Shot 2015-11-03 at 1.46.53 PM.png", "686", "270", "#31a346", "" ] } ] } [/block] [block:api-header] { "type": "basic", "title": "Import/export via API" } [/block] You can also use [our API](doc:api) to import or export data programatically. Check out our [API documentation](https://github.com/fieldbook/api-docs) to get started.