Save It as CSV

1. 1One Row per BookPut each book on its own row, with the column names in the first row. A title is all a row needs.
2. 2Export as CSVIn Numbers, choose File, Export To, CSV. In Excel, save as CSV UTF-8. In Google Sheets, choose File, Download, Comma Separated Values.
3. 3Keep It HandySave the file to Files or iCloud Drive, where your iPhone or iPad can reach it.

Import into Pagio

1. 1Open SettingsIn Pagio, open Settings and tap Import Books.
2. 2Choose SpreadsheetPick Spreadsheet, tap Pick a CSV File, and choose your file.
3. 3Match the RestIf a column has a name Pagio doesn’t know, it asks which field it belongs to. Match it, or skip it.
4. 4Choose What to KeepReview your books and pick which ones to bring over.

Columns Pagio Recognizes

• Title and Author, plus Co-Authors and Translators
• Reading Status, Date Started, Date Finished and Read Count
• Rating, My Review, Private Notes and Quotes
• Shelves, Collections, Tags and Genres
• Series and Series Position
• ISBN, Number of Pages, Audio Duration, Publisher, Publication Year, Language and Format
• Favorite, Price, Currency and Purchase Date

Common variations work too, like “Book Title”, “Date Read” or “My Rating”. Several shelves, tags or genres can share one cell, separated by commas. In the app, See What We Can Import lists every name Pagio knows.