Can I transfer data from Excel into Readerware?

< Back to Knowledge Base Home

Last Updated: June 01, 2012
Keywords: transfer, excel, csv, column, tab, delimited

Yes.

Export your data from Excel to a CSV or TAB delimited file and import that into Readerware.

The mapping line is key to importing data into Readerware. By itself a CSV or TAB delimited file is just a collection of data. For example a line in your file could contain:

    "The Last Juror","John Grisham"

or it could be:

    "John Grisham","The Last Juror"

Readerware has no way of knowing what order the fields are in, i.e. what column in the input file goes into which column in the database. So you need to tell it using a mapping line:

    "Title","Author"
    "The Last Juror","John Grisham"

This is a common technique used with CSV and TAB delimited files. You can include the Readerware column names in your spreadsheet and they will be included in the exported file. You can also edit the exported file in a text editor like Notepad or TextEdit and add the mapping line.

You will find the full list of Readerware column names here.