You can export your gallery or parts of it as a CSV file from the top right corner under the menu item "Extension tools".
CSV is a generic file format for tabular data supported by all spreadsheet applications.
{% embed url="https://youtu.be/F3GTXB1hj1k" %}
{% hint style="warning" %}
In some cases the file is saved with the extension .txt instead of .csv. This is a known issue and not a big deal since all spreadsheet applications should open/import the file just fine with either extension.
The only issue is that your operating system likely won't recognize the correct default application for CSV files. If that is an wissue for you, you can just manually rename the file from
.txtto →.csvand that's it. {% endhint %}
Pick raw data if you're not importing to Google Sheets or Goodreads. You can also use Raw data in Google Sheets if you don't like the clickable links and icons.
| Compatibility | Description |
|---|---|
| Compatibility | Description |
| Google Sheets | Uses formulas to add useful icon links to the front of the spreadsheet. My library in Google Sheets. This format is preferred for Google Sheets but you can also use Raw data if the icon links aren't your thing. Check the import instructions here. |
| Goodreads | Exports all books with ISBN numbers in a Goodreads compatible format. Bookshelves are generated automatically from the book categories and status: not started (to-read), started (currently-reading), finished (read). My audible books in Goodreads. Check the import instructions here. |
| Raw data | This one doesn't have any formulas and as such works in any application, like Libre Office, Numbers, Excel, Google Sheets, etc. |
{% hint style="success" %} Just a reminder that the gallery has a spreadsheet view mode that could potentially give you what you want with less effort if all you want from an actual spreadsheet application is to view the data in that format. The spreadsheet view is read-only, but it does have the same exact search, filter, and sorting methods as the grid view. {% endhint %}