Book Solutions Made Easy

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.

View Sample Excel Input and ONIX Output

Convert Data Between Excel and ONIX 3.0/2.1 Files:

BookDataSolutions.com allows you to Upload Excel and ONIX input files from "Process" 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".

Create ONIX 3.0 records in few steps by preparing book data in an Excel spreadsheet (Download Sample Excel Template). Prepare the spreadsheet with book records using a customized layout (Download Metadata Input Instructions). Use ONIX standard code list values/descriptions for some of the data columns. Upload the spreadsheet from "Work Queue/Upload New File" page. Generate Output ONIX 3.0 from "Work Queue" page. BookDataSolutions will process the records and ONIX file will be generated behind the scenes. The generated Output records can be viewed 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/Upload Files" tab. The Excel output file generated will have the same layout used for uploading Excel files. Excel output records can also be viewed and available to download.