# Importing From a CSV File Books can be imported in bulk from a CSV (comma-separated values) file. The easiest way to make a CSV file is to use a spreadsheet program such as Excel or Numbers. Then save the file in CSV format. In order to be imported properly, the flie must follow a very specific format. The first line of the file (or first row of the spreadsheet) must be the names of the columns. The columns can be in any order, and the only required column is title. All others are optional. You can download a template that has the first line set up for you, and all you will need to do is add your data in the format described below. ![](//d33v4339jhl8k0.cloudfront.net/docs/assets/594e95b004286305c68d57d3/images/6320aa26037bc877147b8751/file-G8L7u6P4cs.png) Columns must match **exactly** -- using the proper capitalization, spacing, etc. Any columns that do not match the list of allowed names will be ignored. Each following line (or row) is the information for a single book. This is the list of allowed column names, and a description of data that should be in that column for each book: * **title** * Title of book * **summary** * Summary of book * **subtitle** * Subtitle of book * **goodreads** * Valid link to book on Goodreads * **reedsy** * Valid link to book on Reedsy * **google** * Valid link to book on Google Books * **order** * Series order * **additional** * Additional Information text * **date** * Publication date of book. MUST be in YYYY-MM-DD format * **genres** * Comma-separated list of genre slugs. If it doesn't exist, it will be created. * FInd slugs here: * ![](//d33v4339jhl8k0.cloudfront.net/docs/assets/594e95b004286305c68d57d3/images/62bb679fc74a080359c84c8f/file-s7SvFxO7Mb.png) * **tags** * Comma-separated list of tag slugs. If it doesn't exist, it will be created. * see genres above for where to find slugs * **series** * Comma-separated list of series slugs. If it doesn't exist, it will be created. * see genres above for where to find slugs * **editors** * Comma-separated list of editor slugs. If it doesn't exist, it will be created. * see genres above for where to find slugs * **illustrators** * Comma-separated list of illustrator slugs. If it doesn't exist, it will be created. * see genres above for where to find slugs * **cover\_artists** * Comma-separated list of cover artist slugs. If it doesn't exist, it will be created. * see genres above for where to find slugs * **publisher** * If the publisher doesn't exist on the site already, a new author will be added (so should be entered into the CSV file with proper capitalization, ie Mooberry Dreams) * To use an existing publisher, must use the slug (ie, mooberry-dreams):\ ![](//d33v4339jhl8k0.cloudfront.net/docs/assets/594e95b004286305c68d57d3/images/6320a95790c29a3d732c71c8/file-26pfgf1hUU.png) * **imprint** * Exact match of an imprint name. If it doesn't exist, it will be created.\ ![](//d33v4339jhl8k0.cloudfront.net/docs/assets/594e95b004286305c68d57d3/images/62bb69aa360964399e46bb88/file-ESOy0l2ts6.png) * **excerpt\_type** * must be either text or kindle * **excerpt** * if excerpt\_type is kindle, this should be the ASIN of the book. If excerpt\_type is text, this should be the text of the excerpt. * **cover** * Can be a number OR a link. If a number, it must be the ID of an image already existing in the media library. If a link, it must be a link to an image #### Retailer Links * **retailer\_{retailer name}\_link** * {retailer name} must match name exactly * Can have a column for each retailer (or just the ones you want to add links for) * Copy the retailer name exactly from here * ![](//d33v4339jhl8k0.cloudfront.net/docs/assets/594e95b004286305c68d57d3/images/62bb652b360964399e46bb54/file-O2pHuQ2cSg.png)Example: retailer\_Barnes and Noble\_link #### **Download Links** * **download\_{format name}\_link** * {format\_name} must match name exactly * Can have a column for each format (or just the ones you want to add links for) * Copy the format name exactly from here * ![](//d33v4339jhl8k0.cloudfront.net/docs/assets/594e95b004286305c68d57d3/images/62bb658ac74a080359c84c7b/file-12eQ0raFrN.png)Example: download\_Kindle\_link #### **Formats** For all of these, {format} must match edition format name exactly Can have columns for each format (or just the ones you want to add) Copy the format name exactly from here: ![](//d33v4339jhl8k0.cloudfront.net/docs/assets/594e95b004286305c68d57d3/images/62bb661cc74a080359c84c85/file-m5NhV9Q85j.png) Examples: format\_Kindle\_isbn, format\_PDF\_isbn * f**ormat\_{format}\_isbn** * ISBN * **format\_{format}\_doi** * DOI * **format\_{format}\_sku** * SKU * **format\_{format}\_language** * Language – must match ISO 639-1 2-letter designation in CAPITAL LETTERS (see ) * **format\_{format}\_pages** * number of pages * **format\_{format}\_height** * height of book * **format\_{format}\_width** * width of book * **format\_{format}\_unit** * units of measurement for height and width – must be one of these values: in, cm, or mm * **format\_{format}\_price** * price of book * **format\_{format}\_currency** * currency the price is listed in – must match 3 letter ISO 4217 code in CAPITAL LETTERS (see ) * **format\_{format}\_title** * title for this format #### **Reviews** Can include up to 5 reviews. Change columns to review2, review3, etc. * **review1\_name** * Name of reviewer * **review1\_link** * Link to review if review is on another website * **review1\_website** * Name of website if review is on another website * **review1\_review** * Text of review to display review on your site ### If Multi-Author installed: * **author** * Comma-separated list of authors of book. * If the author doesn't exist on the site already, a new author will be added (so should be entered into the CSV file with proper capitalization, ie Robin Stone) * To use an existing author, must use the slug (ie, robin-stone):\ ![](//d33v4339jhl8k0.cloudfront.net/docs/assets/594e95b004286305c68d57d3/images/62bb66f7eabe9a7235b38bf3/file-RCpnmOLTKE.png) ### If Custom Fields installed: * **custom\_{field name}** * **custom\_{taxonomy singular name}** * comma-separated list of slugs for the taxonomy * Find Taxonomy singular name here: * ![](//d33v4339jhl8k0.cloudfront.net/docs/assets/594e95b004286305c68d57d3/images/62bb676deabe9a7235b38bf9/file-rP4l0XD73Q.png)See genres above for how to find taxonomy slugs Still need help? [Contact Us](broken://pages/Vdp9vR41lcjyV2IVUmmc) [Contact Us](broken://pages/Vdp9vR41lcjyV2IVUmmc) Last updated on September 13, 2022 --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://mooberrydreams.gitbook.io/mooberry-book-manager-v5/importing-and-exporting-books/importing-from-a-csv-file.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.