Book data is widely exchanged between publishers and retailers in ONIX formatted files. ONIX is a book industry XML standard defined by EditEUR. Libraries use MARC formatted records to catalog book records. BookDataSolutions supports conversion of book data between ONIX 3.0/2.1 and Excel files. BookDataSolutions allows you to do conversions with predefined Excel layout for input and output. Download Excel template file along with instructions to create book records for uploading and converting to ONIX records.






Uploading Excel and ONIX inputs files are done from "Process Files" page. You will need to register and login to use this feature. The application will determine the type of input file based on the file extention. Excel input file should have an extention ".xlsx" or ".xls" and Onix files must be saved with extention ".xml"

You can easily create ONIX 3.0/2.1 records in few steps by preparing book data in an Excel spreadsheet. Prepare the spreadsheet with book records using a customized layout. Use ONIX standard code list values/descriptions for some of the data columns. Upload the spreadsheet from "Process Files" page. BookDataSolutions will process the records and ONIX file will be generated behind the scenes. The generated ONIX records are displayed on the web page and available for downloading.

To output ONIX 3.0/2.1 records to Excel spreadsheets, upload valid ONIX file from "Process Files" page. The Excel output file generated will have the same layout used for uploading Excel files. Excel output records will also be displayed and made available for download.



Metadata Input File Layout:
ColumnField NameField Type: Maximum LengthExampleRemarks
1ISBNNumeric: 139780545582957Book Number
2LCCNAlphaNumeric: 1200131084Library of Congress catalog number.
3OCLC#AlphaNumeric: 12ocn856909163OCLC control number
4TitleText: 1000Harry Potter and the Goblet of FireMain Title of the book
5AuthorShipText: 4000J. K. Rowling,By (author);Kazu Kibuishi ,Illustrated by;Mary GrandPré,Illustrated byFirstName1 LastName1, Role1;FirstName2 LastName2, Role2;…
6ProductFormText: 100Paperback / softbackDescription From ONIX Code List 150
7ProductFormDetailText: 100EPUBDescription From ONIX Code List 175
8HeightNumber: 9 (2 decimal places)7.80Physical Height of book
9WidthNumber: 9 (2 decimal places)5.20Physical Width of book
10DepthNumber: 9 (2 decimal places)0.90Physical Depth of book
11MeasureUnitText: 2inMeasument units, in,mm,cm,etc.
12WeightNumber: 9 (2 decimal places)8.00Weight of book
13WeightUnitText: 2ozWeight units, oz,lb,gm,kg,etc.
14PublicationDateText:820130101Publication date in YYYYMMDD format
15LanguageRoleText: 40Language of textDescription From ONIX Code List 22
16LanguageText:25EnglishDescription From ONIX Code List 74
17BISACMainSubjectText:255Juvenile Fiction / Action & Adventure / GeneralDescription from BISAC Code List - Main (Primary) BISAC Subject of the book
18BISACSubjectsText:1000Juvenile Fiction / Fantasy & Magic;Juvenile Fiction / Science FictionDescription from BISAC Code List - Secondary BISAC Subjects separated by ";".
19BICMainSubjectText:255Science fiction (Children's / Teenage)Description from BIC Code List - Main (Primary) BIC Subject of the book
20BICSubjectsText:1000Adventure stories (Children's / Teenage);Fantasy & magical realism (Children's / Teenage)Description from BIC Code List - Secondary BIC Subjects separated by ";".
21GeneralMainSubjectText:255Children's Books, Action & AdventureDescription of Main (Primary) General Subject of the book
22GeneralSubjectsText:1000Adventure stories (Children's / Teenage);Fantasy & magical realism (Children's / Teenage)Description of Secondary General Subjects separated by ";".
23AudienceTypeText:40ONIX audience codesDescription From Code List 29
24AudienceText:25Children/juvenileDescription From Code List 28
25NumofPagesNumber: 6368Number of Pages of Book
26DescriptionLanguageText:25EnglishDescription From ONIX Code List 74
27DescriptionFormatText:100Default text formatDescription From ONIX Code List 34 - Default text format,HTML,XHTML,XML etc.
28DescriptionText:32000Harry Potter's summer has included the worst birthday ever, doomy warnings from a house-elf called Dobby, and Description of Book
29FlapCopyLanguageText:25EnglishDescription From ONIX Code List 74
30FlapCopyFormatText:100Default text formatDescription From ONIX Code List 34 - Default text format,HTML,XHTML,XML etc.
31FlapCopyText:32000For twelve long years, the dread fortress of Azkaban held an infamous prisoner named Sirius Black. Convicted of killing Flap Copy Text of Book
32BiographyLanguageText:25EnglishDescription From ONIX Code List 74
33BiographyFormatText:100Default text formatDescription From ONIX Code List 34 - Default text format,HTML,XHTML,XML etc.
34BiographyText:32000For twelve long years, the dread fortress of Azkaban held an infamous prisoner named Sirius Black. Convicted of killing Biography Text of Book
35TableofContentsLanguageText:25EnglishDescription From ONIX Code List 74
36TableofContentsFormatText:100Default text formatDescription From ONIX Code List 34 - Default text format,HTML,XHTML,XML etc.
37TableofContentsText:32000 Table of Contents of Book
38ImprintText:255Scholastic Inc.Imprint Name of Book
39PublisherText:255Scholastic Inc.Publisher Name of Book
40CountryOfPublicationText:100United KingdomDescription From ONIX Code List 91 - Country Name of Publication of Book.
41PublishingStatusText:100ActiveDescription From ONIX Code List 64
42PublishingDateText:820130101Publication date in YYYYMMDD format
43CopyRightYearText:42013Copy Right Year in YYYY format
44SalesRightsExclusiveText:4000AU GB IE NZ ZAValue From ONIX Code List 91 and 49 - ISO and Region codes separated by space " ".
45SalesRightsText:4000WORLDValue From ONIX Code List 91 and/or 49 - ISO and Region codes separated by space " ".
46NotForSalesRightsText:4000GB-EWSValue From ONIX Code List 91 and/or 49 - ISO and Region codes separated by space " ".
47ROWSalesRightsText:25For Sale ExclusiveFor Sale Exclusive/For Sale/Not For Sale
48SupplierRoleText:25Publisher to retailersDescription From ONIX Code List 93
49SupplierText:255Scholastic Inc.Supplier Name
50ProductAvailabilityText:100In stockDescription From ONIX Code List 65
51PriceText:4000RRP excluding tax/14.99/USD;RRP excluding tax/11.75/GBP;RRP excluding tax/19.75/CADPrice Type (From ONIX Code List 58)/Price Amount/Currency Code. Multiple Prices are separated by ";"

Click here to View Sample ONIX 3.0 Reference Output