Eksportuj podkreślenia Kindle do OpenDocument Spreadsheet
Pobierz podkreślenia i notatki z Kindle jako arkusz OpenDocument .ods dla LibreOffice Calc lub Arkuszy Google, jedno podkreślenie w wierszu.
How to export Kindle highlights to OpenDocument Spreadsheet
- 1
Import your Kindle highlights
Use the Clippings.io browser extension to pull in highlights from books bought on Amazon, or upload the My Clippings.txt file from your Kindle to include personal documents. Duplicates are removed automatically.
- 2
Choose ODS Sheet
Select the books or highlights you want, open Export and pick ODS Sheet on the File Downloads tab. Open Show Advanced Export Options to choose which annotation types to include and how rows are sorted.
- 3
Download
Click Start Export. The file is built in the background and a Download File button appears when it is ready. If you asked for one file per book, they arrive together in a zip.
What you get in OpenDocument Spreadsheet
One highlight per row in a standards-based .ods file for LibreOffice Calc, Google Sheets and any spreadsheet that speaks OpenDocument.
- An open format, no lock-in
- OpenDocument Spreadsheet is an ISO standard, so your highlights open in LibreOffice Calc, Apache OpenOffice, Google Sheets, Collabora and Excel alike.
- Nine tidy columns
- Title, Author, Type, Created, Location, Page, Content, Tags and Notes, with a bold header row on a sheet called Highlights. Nothing merged, nothing to clean up.
- Filter, sort and pivot
- Filter to one author, sort by the date you highlighted, count highlights per book with a pivot table, or look up a quote by location.
- Or keep a sheet in the cloud
- Choose OpenDocument Spreadsheet as the file format for Dropbox, Google Drive or OneDrive and the sheet is updated automatically after each import.
Kindle to OpenDocument Spreadsheet questions
- Which columns does the spreadsheet have?
- Title, Author, Type, Created, Location, Page, Content, Tags and Notes, in that order, with a bold header row. Type says whether the row is a highlight, note, bookmark or clipping. Tags and Notes are filled in when you include them in the export options.
- Which apps open the .ods file?
- LibreOffice Calc, Apache OpenOffice, Google Sheets, Collabora Office, Microsoft Excel and most other spreadsheets. It is the same content as the Excel export in an open, vendor-neutral container.
- Can I choose a citation style for the spreadsheet?
- No. Citations only apply to the document formats such as Word and PDF. In a spreadsheet the author, title, location and page are already in their own columns, so you can build any citation you need with a formula.
- Should I choose OpenDocument Spreadsheet or Excel?
- If you work in LibreOffice or care about an open standard, choose OpenDocument Spreadsheet. If you work in Excel or Numbers, choose Excel. The content is identical, and you can export both.
- Can I get one spreadsheet per book?
- Yes. Choose one document per book in the export options and the download is a zip with one .ods file per book.
- Can I export to OpenDocument Spreadsheet on the free plan?
- Yes. On the free plan each exported highlight is cut to its first 100 characters, which is enough to see how the export looks. The professional plan removes the limit, and your first export after upgrading resends everything in full.
Clippings.io also exports Kindle notes to Evernote and to Notion, Dropbox, Google Drive, OneDrive, OneNote, Word, Excel, PDF, Text, Markdown, EPUB, JSON and OpenDocument Text.
Wyrażasz gotowość na zanurzenie się?Zacznij od darmowego konta już dziś.
Podkreśl raz, zapamiętaj na zawsze. Zacznij w pełni korzystać z potencjału książek, które czytasz na swoim czytniku e-booków Kindle.
Zarejestruj się za darmo