{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Before you start","Basic","Contributors","Pricing","Dropdowns"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Before you start","index":0,"n_rows":26,"n_cols":1,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["print-book-start:us-excel@1.0"]
[]
[]
["Before you start"]
["This metadata template has 3 tabs you need to fill out: Basic, Contributors, and Pricing. Before you start, read our top tips for avoiding issues that cause rejections:"]
[]
["Start on Row 5"]
["Leave Rows 1 to 4 on each tab as-is. Don't add columns."]
[]
["Required fields"]
["Missing entries for “title” and “contributor_last_name” are among the most common reasons files are rejected.\n* First-time uploads. You need to fill out all required fields\n* Updates to existing books. Only enter the reference ID and fields you want to change."]
[]
["Hidden invalid characters"]
["Often pasted unintentionally, \"hidden” invalid characters (e.g., commas, &, %) look fine in the template but cause errors. Invalid characters in the contributor name fields are among the most common errors we see. To check for hidden invalid characters, paste entries into a plain text editor (e.g., Notepad for Windows)."]
[]
["Character limits"]
["Avoid one of the most common errors we see by making sure the characters entered in the “title” and “subtitle” fields don’t exceed the combined maximum of 200 characters. "]
[]
["Format all entries as text in Excel"]
["This includes fields with numbers (e.g., ISBN, list price). To ensure fields are formatted as text: first, highlight cells and right-click and then choose Format Cells.” After doing this, on the Number tab, click Text, and click OK. \n\nSupported trim sizes for the Hardcover Beta \n5.5 x 8.5 in        139.7 x 215.9 mm     \n6 x 9 in              152.4 x 228.6 mm   \n6.14 x 9.21 in     156 x 234 mm           \n7 x 10 in            177.8 x 254 mm        \n8.25 x 11 in        209.6 x 279.4 mm    "]
[]
["Still have questions? "]
["See tips and examples for filling out each tab:"]
["* Basic tab tips"]
["* Contributors tab tips"]
["* Pricing tab tips"]

{"sheet":"Basic","index":1,"n_rows":5,"n_cols":23,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["print-book-base:us-excel@1.0 ","See template tips and examples"]
["required","required","required","required","required","required","required","required","required","required","required","required","required","required","optional","optional","optional","optional","optional","optional","optional","optional","optional"]
["reference_id","ISBN","binding_type","imprint","title","publication_date","language","paper_color","cover_finish","interior_type","bleed","trim_size_unit","trim_width","trim_height","subtitle","description","series_title","series_number","edition_number","bisac","keywords","is_adult_content","enable_for_sale"]
["\nEnter a unique ID for this book  (ISBN recommended)\n\n* Must match ID entered on other tabs in this spreadsheet\n\n* 50 characters max\n\n* Can contain numbers, letters, underscores, dashes\n\n* Format field as text","\nEnter ISBN-13 (preferred) or ISBN-10\n\n* Format field as text\n\n* Locked after publication\n\n\n","\nChoose between paperback and case laminate in the drop-down menu\n\n*Defaults to paperback if left blank on original upload\n\n*Locked after publication","\nEnter imprint associated with this book\n\n* 1 imprint allowed per title\n\n* 255 characters max","\nEnter book title\n\n* Combined 200 character max (includes spaces) for title and subtitle (see Column O) ","\nEnter date the book was published\n\n* Format date as YYYYMMDD\n\n* Example: 20191013 for October 13, 2019\n\n* Format field as text\n\n  \n","\nEnter 3-letter book language code\n\n* Examples: ENG, FRA, DEU, ITA, POR, SPA\n\n* See supported codes:\nhttps://kep.amazon.com/help?topicId=GY2VK9TSX29M8VAX","\nChoose paper color from the drop-down menu\n\n* Cream: for black-and-white interiors\n\n* White: for black-and-white and color interiors\n\n* Defaults to \"cream\" if left blank on original import\n\n* During future updates, selection won't change if left blank","\nChoose cover finish from the drop-down menu\n\n* Defaults to \"matte\" if left blank on original upload\n\n* During future updates, selection won't change if left blank","\nChoose interior type from the drop-down menu\n\n* Defaults to black and white if left blank on original upload\n\n* Standard color is not supported for case laminate binding type\n\n* During future updates, selection won't change if left blank","\nDoes the interior have bleed (e.g., images run off the page edge)?\n\n* Doesn't apply to cover\n\n* Defaults to \"N\" if left blank on original import\n\n* Selection won't change if left blank during future updates\n\n* Learn more about bleed: https://kep.amazon.com/help?topicId=GU9ASG23JVMNJEGK","\nChoose trim size unit of measurement from the drop-down menu: mm or in","\nEnter trim width in the unit of measurement selected in Column L\n\n* Numbers only (leave out \"in\" and \"mm\") with periods for decimals\n\n* Example: 5.5\n\n* Min width for paperback: 4 in (101.6 mm)\n\n* Max width for paperback: 8.5 in (215.9 mm)\n\n* Please see \"before you start\" tab for supported case laminate trim sizes","\nEnter trim height in the unit of measurement selected in Column L\n\n* Numbers only (leave out \"in\" and \"mm\") with periods for decimals\n\n* Example: 9.5\n\n* Min height for paperback: 6 in (152.4 mm)\n\n* Max height for paperback (black ink and Premium color): 11.69 in (296.93 mm) \n\n* Max height for paperback (Standard color): 11 in (279.4) mm)\n\n* Please see \"before you start\" tab for supported case laminate trim sizes\n","\nEnter subtitle\n\n* Combined 200 character max (includes spaces) for title and subtitle (see Column E) ","\nEnter book description\n\n* Basic HTML is accepted (e.g., <p>, <b>, <i>)\n\n* 4,000 characters max","\nEnter series title if book is part of a series\n\n* Leave empty if series title is already included in \"title\" field (Column D)\n","\nEnter series number if book is part of a series\n\n* Series number is the same as volume number","\nEnter edition number if book is new edition of an existing title","\nEnter up to 3 BISAC codes\n\n* Separate codes by semicolons\n\n* Example: FIC000000; FIC064000; FIC075000 \n\n* See a list of BISAC codes: https://bisg.org/page/BISACEdition\n","\nEnter keywords\n\n* Separate by semicolons\n\n* 7 keywords max per book \n \n* 2,000 characters max","\nDoes book include adult content?\n\n* Choose \"Y\" only if title can be deemed pornographic, which excludes it from certain search results on Amazon\n\n* Defaults to \"N\" if left blank on original upload\n\n* During future updates, original selection won't change if left blank","\nEnable or disable POD?\n\n* To enable POD, choose Y\n\n* To disable POD, choose N\n\n* Defaults to \"Y\" if left blank on original upload\n\n* During future updates, original selection won't change if left blank"]
["978-99949-8-955-3","978-99949-8-955-3","PAPERBACK","Eliva Press","The Art of Work",20221215,"ENG","WHITE","GLOSSY","BLACK AND WHITE","N","in",6,9,"A proven path to discovering what you where ment to do","What’s happened to you is rare,” my friend Mark said to me just before I made one of the most important decisions of my life—the decision to quit my job and become a full- time writer. My last day at work also happened to be my thirtieth birthday, which made it a milestone in many respects. The truth, though, is the day itself was less significant than the process it took to get there.\n\nWhen asked how I got to this point, I struggle to give an intelligent answer. The experience of finding your calling can be both mysterious and practical. It takes effort but also seems to happen to you at times. What I’ve come to understand is that finding your purpose is more of a path than a plan: it involves twists and turns that you never expected. Ultimately these surprises lead you to your destiny. And once you arrive at what you thought was the destination, you realize it’s only another leg in the journey.",null,null,null,"BUS000000"]

{"sheet":"Contributors","index":2,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["print-book-contributors:us-excel@1.0","See template tips and examples"]
["required","required","required","optional","optional","optional","optional"]
["reference_id","contributor_role","contributor_last_name","contributor_title","contributor_first_name","contributor_middle_name","contributor_suffix"]
["\nEnter a unique ID for this book  (ISBN recommended)\n\n* Must match ID entered on other tabs in this spreadsheet\n\n* 50 characters max\n\n* Can contain numbers, letters, underscores, dashes\n\n* Format field as text\n\n\n","\nChoose contributor role from the drop-down menu\n\n* Roles: author, editor, illustrator, photographer, translator, reader, writer, artist, penciller, inker, colorist, letterer, cover artist, other\n\n* Books should have at least 1 author or primary contributor","\nEnter contributor last name\n\n* Tip: Check for hidden invalid characters (they look OK in this template but cause errors) by pasting entries into a plain text editor (e.g., Notepad for Windows or Notes for Mac)\n\n* Common hidden invalid characters include commas and %, &, #, ©, ®\n\n* If contributor has only 1 name (e.g., Madonna), enter it in this field\n\n* 128 characters max\n\n* For books with multiple contributors, add a new row for each contributor with the same reference ID","\nEnter contributor title\n\n* Examples: Dr., Ms., Mr., Mrs.\n\n* 4 characters max","\nEnter contributor first name\n\n* Tip: Check for hidden invalid characters (they look OK in this template but cause errors) by pasting entries into a plain text editor (e.g., Notepad for Windows)\n\n* Common hidden invalid characters include commas and %, &, #, ©, ®\n\n* 128 characters max","\nEnter contributor middle name\n\n* Tip: Check for hidden invalid characters (they look OK in this template but cause errors) by pasting entries into a plain text editor (e.g., Notepad for Windows)\n\n* Common hidden invalid characters include commas and %, &, #, ©, ®\n\n* 128 characters max","\nEnter contributor suffix\n\n* Examples: Ph.D., Sr., II\n\n* 6 characters max"]
["978-99949-8-955-3","author","Goins",null,"Jeff"]
["978-99949-8-955-3","author","Goins",null,"Julia"]
["978-99949-8-955-3","author","Grey",null,"John"]

{"sheet":"Pricing","index":3,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["print-book-price:us-excel@1.0","See template tips and examples"]
["required","required","required","required","required","optional"]
["reference_id","stores","program","currency","list_price","Does_list_price_include_tax"]
["\nEnter a unique ID for this book  (ISBN recommended)\n\n* Must match ID entered on other tabs in this spreadsheet\n\n* 50 characters max\n\n* Can contain numbers, letters, underscores, dashes\n\n* Format field as text\n\n","\nEnter the Amazon stores where you want to enroll your book in POD\n\n* Stores: amazon.com, amazon.co.uk, amazon.de, amazon.fr, amazon.it, amazon.es, amazon.ca, amazon.co.jp, amazon.com.au (Amazon.co.jp and Amazon.com.au stores are not supported for standard color interior or case laminate binding type)\n\n* If stores have the same list price and currency, enter them in the same cell, separated by spaces (e.g., amazon.de amazon.fr amazon.it)\n\n* If stores have different list prices or currencies, enter each store on a separate row, beginning with the same reference ID\n\n* To list a book in any EU store, you need to list it in all 5 EU stores.\n\n\n","\nChoose a fulfillment program for each book and store from the drop-down menu\n\n* IF: Inventory free\n* ISP: In-stock protection\n\n* All 5 EU stores must share the same program\n\n* Defaults to \"IF\" if left blank on original upload\n\n* Selection won't change if left blank during future updates\n\n* Learn more about fulfillment programs: https://kep.amazon.com/help?topicId=GWX59MKCC6A2TX9V","\nChoose currency for each store and list price from the drow-down menu\n\n* Accepted currencies by store:\nAmazon.com (USD)\nAmazon.ca (CAD, USD) Amazon.co.uk (GBP)\nAmazon.de, Amazon.fr, Amazon.it, Amazon.es (EUR)\nAmazon.co.jp (USD, GBP, JPY)\nAmazon.com.au (AUD)\n\n* Leaving this field blank for us to auto-convert the list price isn't supported","\nEnter a list price by store and currency\n\n* Numbers only (no currency symbols), with periods for decimals (not commas)\n\n* Examples: 7.90, 14.99\n\n* Format field as text\n\n* Learn more about list prices: https://kep.amazon.com/help?topicId=G5W5HH9NGNWVWY7K","\nDoes the list price entered include Value Added Tax (VAT) or Australian Goods and Services Tax (GST)?\n\n* VAT applies to EU stores only\n\n*GST applies to AU store only\n\n* Defaults to \"N\" if left blank on original upload\n\n* During future updates, selection won't change if left blank\n\n* If you select \"Y\": the price in the \"list price\" column (column E) will appear on the detail page. Your royalties will be calculated on your list price minus the corresponding VAT/GST\n\n* If you select \"N\": we will add the corresponding VAT/GST to the price in the \"list price\" column (column E) and the adjusted price will appear on the detail page. Your royalties will be calculated on the price in the \"list price\" column.   \n\n"]
["978-99949-8-955-3","amazon.com",null,"USD",70]
["978-99949-8-955-3","amazon.de",null,"EUR",70]
["978-99949-8-955-3","amazon.fr",null,"EUR",70]
["978-99949-8-955-3","amazon.es",null,"EUR",70]
["978-99949-8-955-3","amazon.it",null,"EUR",70]
["978-99949-8-955-3","amazon.ca",null,"USD",70]
["978-99949-8-955-3","amazon.co.uk",null,"GBP",70]
["978-99949-8-955-3","amazon.com.au",null,"AUD",105]
["978-99949-8-955-3","amazon.co.jp",null,"USD",70]

{"sheet":"Dropdowns","index":4,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["paperback-base:us-excel@1.0"]
["Y","MATTE","CREAM","mm","author","IF","USD","PAPERBACK","BLACK AND WHITE","NO",5.5,8.5,139.7,215.9]
["N","GLOSSY","WHITE","in","editor","ISP","EUR","CASE_LAMINATE","STANDARD COLOR","STANDARD COLOR",6,9,152.4,228.6]
[null,null,null,null,"illustrator",null,"GBP",null,"PREMIUM COLOR","PREMIUM COLOR",6.14,9.21,155.96,233.93]
[null,null,null,null,"photographer",null,"CAD",null,null,null,7,10,177.8,254]
[null,null,null,null,"translator",null,"JPY",null,null,null,8.25,11,209.55,279.4]
[null,null,null,null,"reader",null,"AUD"]
[null,null,null,null,"writer"]
[null,null,null,null,"artist"]
[null,null,null,null,"penciller"]
[null,null,null,null,"inker"]
[null,null,null,null,"colorist"]
[null,null,null,null,"letterer"]
[null,null,null,null,"cover artist"]
[null,null,null,null,"other"]