Kindle My Clippings.txt to CSV
Turn the My Clippings.txt file from your Kindle into a tidy spreadsheet of every highlight and note, with the book, author, location and date for each.
or click to choose one
No file handy? Try it with the sample My Clippings.txt.
How to export your Kindle highlights to a spreadsheet
- Plug your Kindle into your computer with its USB cable.
- Open the Kindle drive, then the documents folder, and copy My Clippings.txt to your computer.
- Drop the file into the box above.
- Pick all books or just one, check the preview, and download the .csv file.
What My Clippings.txt looks like
Every highlight, note and bookmark from every book goes into this one file, in the order you made them:
Walden (Henry David Thoreau) - Your Highlight on page 89 | Location 1316-1317 | Added on Monday, April 6, 2026 7:49:01 AM Our life is frittered away by detail. Simplify, simplify. ==========
The converter splits it into columns: Book, Author, Type, Page, Location, Date added, Highlight and Note. Within each book, rows are sorted by location so they read in the order of the book.
What the converter tidies up
- Duplicate highlights. Extending a highlight leaves the shorter version behind in the file. Only the longest version is kept.
- Notes. A note is saved as its own entry. It is moved into the Note column of the highlight at the same location.
- Bookmarks have no text, so they are left out unless you ask for them.
- Older Kindles write locations like "Loc. 1234-36". These are expanded to 1234-1236.
Ideas for your highlights spreadsheet
- Filter by author or book to build a reading journal.
- Sort by date to see what you were reading when.
- Import the CSV into Notion, Airtable or a spaced-repetition app to review your favorite passages.
Sample file
The sample My Clippings.txt has highlights from three public-domain books, including an extended highlight, a note and a bookmark. Drop it in the box above to try the converter.
Frequently asked questions
- Are my highlights uploaded anywhere?
- No. The conversion runs in your web browser. Your reading notes never leave your computer.
- Where is My Clippings.txt?
- Connect your Kindle e-reader to a computer with its USB cable. It shows up like a USB drive. Open the documents folder and copy My Clippings.txt to your computer.
- Why does the file have the same highlight twice?
- When you extend or redo a highlight, the Kindle adds the new version but keeps the old one. The converter spots overlapping highlights in the same place and keeps only the longest version.
- Does this work with the Kindle app on my phone?
- No. My Clippings.txt is only created by Kindle e-readers. Highlights made in the Kindle phone or tablet app are stored in your Amazon account instead, and don't appear in this file.
- Some highlights are cut off. Why?
- Publishers can limit how much of a book can be clipped. Once the limit is reached, the Kindle stops saving the full text, and the file may contain a message about the clipping limit instead.
- Can I convert just one book?
- Yes. After loading the file, choose the book from the Books list in step 2.