{"id":32001,"date":"2024-12-04T09:00:00","date_gmt":"2024-12-04T09:00:00","guid":{"rendered":"https:\/\/readcube.wpenginepowered.com\/?post_type=docs&#038;p=32001"},"modified":"2025-01-23T00:20:51","modified_gmt":"2025-01-23T00:20:51","password":"","slug":"csv-import-export-in-readcube","status":"publish","type":"docs","link":"https:\/\/readcube.wpenginepowered.com\/en\/help-center\/csv-import-export-in-readcube\/","title":{"rendered":"CSV Import\/Export"},"content":{"rendered":"\n<p>Papers allows you to import or export a library as a .csv (comma-separated values) file. This format will allow you to make batch edits to your information using a spreadsheet (with software such as Excel).<\/p>\n\n\n\n<p><strong>What is a CSV file?<\/strong><\/p>\n\n\n\n<p>A CSV file has a fairly simple structure. It\u2019s a list of data separated by commas. For example, if you have a few contacts in a contact manager and you export them as a CSV file, you would get a file that looks like this:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.papersapp.com\/wp-content\/uploads\/2024\/11\/csvfile-example-1024x61.png\" alt=\"\" class=\"wp-image-32189\" \/><\/figure>\n\n\n\n<p>Essentially, this is all a CSV file is. They can be far more complicated with thousands of lines, a large number of entries for each line and\/or long strings of text. &nbsp;Some CSV files may not even have the headers at the top, and some may use quotation marks to surround each bit of data.However, this is the basic format.<\/p>\n\n\n\n<p><strong>What kind of CSV&#8217;s can I import?<\/strong><br>There are many different types of CSV files and while most should work with Papers, there will be some that may not. However, most CSV&#8217;s should work if they have at least one of the following fields that are required when you import a CSV:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.papersapp.com\/wp-content\/uploads\/2024\/11\/csv-requiredfields-1024x237.png\" alt=\"\" class=\"wp-image-32190\" \/><\/figure>\n\n\n\n<p>Only one of the above fields is required. This allows you to import a list full of DOI&#8217;s or some titles of references. Note that if there is no identifier (such as DOI, PMID, etc.) we won&#8217;t be able to fill in any more metadata information for you (as the app requires identifiers to search for and locate metadata information of a reference).&nbsp;<\/p>\n\n\n\n<p>For instance, the following CSV will allow you to import these DOIs and get information on them. If any of the articles are open access ones the app will automatically import the PDFs for them (from this particular example, the last article is an open access one). You can get a copy of this file at the bottom of the page (DOIExample.csv).<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-dba23349-e3f5-4933-9b06-1f3ce3b826d0\" href=\"https:\/\/www.papersapp.com\/wp-content\/uploads\/2024\/11\/DOIexample.csv\">DOIexample<\/a><a href=\"https:\/\/www.papersapp.com\/wp-content\/uploads\/2024\/11\/DOIexample.csv\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-dba23349-e3f5-4933-9b06-1f3ce3b826d0\">Download<\/a><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.papersapp.com\/wp-content\/uploads\/2024\/11\/csv-doi-example-1024x75.png\" alt=\"\" class=\"wp-image-32191\" \/><\/figure>\n\n\n\n<p>Another common CSV you might want to import is a PubMed search result. You can find this option under &#8220;Save&#8221; and by changing the format to CSV:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.papersapp.com\/wp-content\/uploads\/2024\/11\/pubmed-saveas-csv-1024x688.png\" alt=\"\" class=\"wp-image-32193\" \/><\/figure>\n\n\n\n<p>Results will be formatted like:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.papersapp.com\/wp-content\/uploads\/2024\/11\/csv-pubmed-example-1024x70.png\" alt=\"\" class=\"wp-image-32194\" \/><\/figure>\n\n\n\n<p>These have a lot more information and will import automatically into your library. To get an example of this file see below (csv-ElephantSh-set.csv).<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-f067762b-e108-4efc-944e-8b498bcf9c1b\" href=\"https:\/\/www.papersapp.com\/wp-content\/uploads\/2024\/11\/csv-ElephantSh-set.csv\">csv-ElephantSh-set<\/a><a href=\"https:\/\/www.papersapp.com\/wp-content\/uploads\/2024\/11\/csv-ElephantSh-set.csv\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-f067762b-e108-4efc-944e-8b498bcf9c1b\">Download<\/a><\/div>\n\n\n\n<p><strong>What kind of fields does the CSV file support?<\/strong><\/p>\n\n\n\n<p>Any of the fields that are part of our&nbsp;<a href=\"https:\/\/support.papersapp.com\/en\/support\/solutions\/articles\/30000037532\" rel=\"noreferrer noopener\" target=\"_blank\">Advanced Search Syntax<\/a>&nbsp;article can be imported. The length of these items can only be 256 characters long. Importing other fields will work but we currently hide these fields in the app. We will be adding a way to visualize these fields in the future.<\/p>\n\n\n\n<p><strong>Can I import a TSV(Or another file that has different delimiters)?<\/strong><\/p>\n\n\n\n<p>Currently, we don&#8217;t support TSV but the easiest way to fix this is to open the TSV in a program like Excel and then save it as a CSV file. This will allow you to use other file formats that use different delimiters to separate fields. If you can&#8217;t import the file in Excel you can always use the Data tab and import from file or database:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.papersapp.com\/wp-content\/uploads\/2024\/11\/excel-datatab.png\" alt=\"\" class=\"wp-image-32196\" \/><\/figure>\n\n\n\n<p><strong>Exporting CSV from Papers<\/strong><\/p>\n\n\n\n<p>To export from Papers all you need to do is hit the gear next to a library and click export as &#8220;Comma-separated Values&#8221;. This will open up a dialog box that allows you to save the CSV to your computer and default to the library&#8217;s name. Once saved you can edit the file in excel or any other program to edit the CSV. You can then import this file back into the app to bulk update any of the items you had updated.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.papersapp.com\/wp-content\/uploads\/2024\/11\/export-csv-1024x346.png\" alt=\"\" class=\"wp-image-32198\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Papers allows you to import or export a library as a .csv (comma-separated values) file. This format will allow you to make batch edits to your information using a spreadsheet&hellip;<\/p>\n","protected":false},"author":22,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_EventAllDay":false,"_EventTimezone":"","_EventStartDate":"","_EventEndDate":"","_EventStartDateUTC":"","_EventEndDateUTC":"","_EventShowMap":false,"_EventShowMapLink":false,"_EventURL":"","_EventCost":"","_EventCostDescription":"","_EventCurrencySymbol":"","_EventCurrencyCode":"","_EventCurrencyPosition":"","_EventDateTimeSeparator":"","_EventTimeRangeSeparator":"","_EventOrganizerID":[],"_EventVenueID":[],"_OrganizerEmail":"","_OrganizerPhone":"","_OrganizerWebsite":"","_VenueAddress":"","_VenueCity":"","_VenueCountry":"","_VenueProvince":"","_VenueState":"","_VenueZip":"","_VenuePhone":"","_VenueURL":"","_VenueStateProvince":"","_VenueLat":"","_VenueLng":"","_VenueShowMap":false,"_VenueShowMapLink":false,"_price":"","_stock":"","_tribe_ticket_header":"","_tribe_default_ticket_provider":"","_ticket_start_date":"","_ticket_end_date":"","_tribe_ticket_show_description":"","_tribe_ticket_show_not_going":false,"_tribe_ticket_use_global_stock":"","_tribe_ticket_global_stock_level":"","_global_stock_mode":"","_global_stock_cap":"","_tribe_rsvp_for_event":"","_tribe_ticket_going_count":"","_tribe_ticket_not_going_count":"","_tribe_tickets_list":"[]","_tribe_ticket_has_attendee_info_fields":false,"footnotes":""},"doc_category":[1551],"doc_tag":[],"class_list":["post-32001","docs","type-docs","status-publish","hentry","doc_category-organize"],"acf":[],"year_month":"2026-04","word_count":616,"total_views":"1280","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Katarina","author_nicename":"katarina","author_url":"https:\/\/readcube.wpenginepowered.com\/en\/news\/author\/katarina\/"},"doc_category_info":[{"term_name":"Organize","term_url":"https:\/\/readcube.wpenginepowered.com\/en\/docs-category\/organize\/"}],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.10 (Yoast SEO v27.1.1) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Exporting and Importing CSV files in ReadCube<\/title>\n<meta name=\"description\" content=\"Learn how to import\/export libraries in ReadCube using CSV files for batch edits. Easily update metadata, import DOIs, or manage PubMed search results.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/readcube.wpenginepowered.com\/en\/docs\/csv-import-export-in-readcube\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CSV Import\/Export\" \/>\n<meta property=\"og:description\" content=\"Learn how to import\/export libraries in ReadCube using CSV files for batch edits. Easily update metadata, import DOIs, or manage PubMed search results.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/readcube.wpenginepowered.com\/en\/docs\/csv-import-export-in-readcube\/\" \/>\n<meta property=\"og:site_name\" content=\"ReadCube\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-23T00:20:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.papersapp.com\/wp-content\/uploads\/2024\/11\/csvfile-example-1024x61.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/readcube.wpenginepowered.com\/docs\/csv-import-export-in-readcube\/\",\"url\":\"https:\/\/readcube.wpenginepowered.com\/docs\/csv-import-export-in-readcube\/\",\"name\":\"Exporting and Importing CSV files in ReadCube\",\"isPartOf\":{\"@id\":\"https:\/\/readcube.wpenginepowered.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/readcube.wpenginepowered.com\/docs\/csv-import-export-in-readcube\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/readcube.wpenginepowered.com\/docs\/csv-import-export-in-readcube\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.papersapp.com\/wp-content\/uploads\/2024\/11\/csvfile-example-1024x61.png\",\"datePublished\":\"2024-12-04T09:00:00+00:00\",\"dateModified\":\"2025-01-23T00:20:51+00:00\",\"description\":\"Learn how to import\/export libraries in ReadCube using CSV files for batch edits. Easily update metadata, import DOIs, or manage PubMed search results.\",\"breadcrumb\":{\"@id\":\"https:\/\/readcube.wpenginepowered.com\/docs\/csv-import-export-in-readcube\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/readcube.wpenginepowered.com\/docs\/csv-import-export-in-readcube\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/readcube.wpenginepowered.com\/docs\/csv-import-export-in-readcube\/#primaryimage\",\"url\":\"https:\/\/www.papersapp.com\/wp-content\/uploads\/2024\/11\/csvfile-example-1024x61.png\",\"contentUrl\":\"https:\/\/www.papersapp.com\/wp-content\/uploads\/2024\/11\/csvfile-example-1024x61.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/readcube.wpenginepowered.com\/docs\/csv-import-export-in-readcube\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/readcube.wpenginepowered.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Docs\",\"item\":\"https:\/\/readcube.wpenginepowered.com\/docs\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"CSV Import\/Export\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/readcube.wpenginepowered.com\/#website\",\"url\":\"https:\/\/readcube.wpenginepowered.com\/\",\"name\":\"ReadCube\",\"description\":\"Your personal library of research\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/readcube.wpenginepowered.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Exporting and Importing CSV files in ReadCube","description":"Learn how to import\/export libraries in ReadCube using CSV files for batch edits. Easily update metadata, import DOIs, or manage PubMed search results.","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:\/\/readcube.wpenginepowered.com\/en\/docs\/csv-import-export-in-readcube\/","og_locale":"en_US","og_type":"article","og_title":"CSV Import\/Export","og_description":"Learn how to import\/export libraries in ReadCube using CSV files for batch edits. Easily update metadata, import DOIs, or manage PubMed search results.","og_url":"https:\/\/readcube.wpenginepowered.com\/en\/docs\/csv-import-export-in-readcube\/","og_site_name":"ReadCube","article_modified_time":"2025-01-23T00:20:51+00:00","og_image":[{"url":"https:\/\/www.papersapp.com\/wp-content\/uploads\/2024\/11\/csvfile-example-1024x61.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/readcube.wpenginepowered.com\/docs\/csv-import-export-in-readcube\/","url":"https:\/\/readcube.wpenginepowered.com\/docs\/csv-import-export-in-readcube\/","name":"Exporting and Importing CSV files in ReadCube","isPartOf":{"@id":"https:\/\/readcube.wpenginepowered.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/readcube.wpenginepowered.com\/docs\/csv-import-export-in-readcube\/#primaryimage"},"image":{"@id":"https:\/\/readcube.wpenginepowered.com\/docs\/csv-import-export-in-readcube\/#primaryimage"},"thumbnailUrl":"https:\/\/www.papersapp.com\/wp-content\/uploads\/2024\/11\/csvfile-example-1024x61.png","datePublished":"2024-12-04T09:00:00+00:00","dateModified":"2025-01-23T00:20:51+00:00","description":"Learn how to import\/export libraries in ReadCube using CSV files for batch edits. Easily update metadata, import DOIs, or manage PubMed search results.","breadcrumb":{"@id":"https:\/\/readcube.wpenginepowered.com\/docs\/csv-import-export-in-readcube\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/readcube.wpenginepowered.com\/docs\/csv-import-export-in-readcube\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/readcube.wpenginepowered.com\/docs\/csv-import-export-in-readcube\/#primaryimage","url":"https:\/\/www.papersapp.com\/wp-content\/uploads\/2024\/11\/csvfile-example-1024x61.png","contentUrl":"https:\/\/www.papersapp.com\/wp-content\/uploads\/2024\/11\/csvfile-example-1024x61.png"},{"@type":"BreadcrumbList","@id":"https:\/\/readcube.wpenginepowered.com\/docs\/csv-import-export-in-readcube\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/readcube.wpenginepowered.com\/en\/"},{"@type":"ListItem","position":2,"name":"Docs","item":"https:\/\/readcube.wpenginepowered.com\/docs\/"},{"@type":"ListItem","position":3,"name":"CSV Import\/Export"}]},{"@type":"WebSite","@id":"https:\/\/readcube.wpenginepowered.com\/#website","url":"https:\/\/readcube.wpenginepowered.com\/","name":"ReadCube","description":"Your personal library of research","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/readcube.wpenginepowered.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/readcube.wpenginepowered.com\/en\/wp-json\/wp\/v2\/docs\/32001","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/readcube.wpenginepowered.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/readcube.wpenginepowered.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/readcube.wpenginepowered.com\/en\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/readcube.wpenginepowered.com\/en\/wp-json\/wp\/v2\/comments?post=32001"}],"version-history":[{"count":0,"href":"https:\/\/readcube.wpenginepowered.com\/en\/wp-json\/wp\/v2\/docs\/32001\/revisions"}],"wp:attachment":[{"href":"https:\/\/readcube.wpenginepowered.com\/en\/wp-json\/wp\/v2\/media?parent=32001"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/readcube.wpenginepowered.com\/en\/wp-json\/wp\/v2\/doc_category?post=32001"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/readcube.wpenginepowered.com\/en\/wp-json\/wp\/v2\/doc_tag?post=32001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}