CVS File

You need to select the “use CSV Header” checkbox, unless your CSV file has no headers and has the data in the proper order.

I know nothing about Excel (I have never used it) and have no idea how to get Excel to treat an ISBN (a string of digits) as a string and not as a number. I would say Excel is really the wrong tool — *I* would never use a spreadsheet for this purposes — I would create the CSV file using a plain text editor (Micro Emacs would be my personal choice).

I trick excel by copying the column of numbers; then paste that into a true ASCII editor, Notepad generally works although I prefer V-Edit.

The delete the contents -entire column of data in excel. Highlight that column, change the format type to text, and then paste back the column of data that you copied.

V-edit or a similar program is good because you can view the text in other formats (Hex, etc) and this allows you to see any extraneous junk that excel has added into you supposedly number only column.