Your highlights file
Connect your Kindle with USB and take documents/My Clippings.txt, or use a notebook export from the Kindle app —
how to export Kindle highlights. A spreadsheet is the easiest way to search years of highlights or move them to another app.
Convert to a spreadsheet
- Drop
My Clippings.txton the box above. Excel is selected. - Pick the books, then click Convert and download. Choose CSV for Google Sheets or Numbers.
Columns
| Column | Example |
|---|---|
| Book, Author | The Great Gatsby, F. Scott Fitzgerald |
| Type | highlight or note |
| Highlight, Note | The passage and the note you typed on it |
| Page, Location | 12, 170-172 |
| Date added | 2026-10-18 21:15 |
The Excel file has a second sheet with each book, its number of highlights and when you last highlighted in it.
Importing into Readwise
Choose Readwise CSV: it uses Readwise's column names (Highlight, Title, Author, Note, Location, Date), so you can upload it under Import → CSV. Handy for highlights from sideloaded books that Readwise's Kindle sync misses.
Cleaned up for you
- Clean rows: extended highlights are saved again by your Kindle; the sheet keeps only the longest version.
- Notes in their own column, on the row of the highlight they belong to.
- Sorted by book and reading order, with columns for page, location and date.
Private by design
Your highlights are converted in your browser. Nothing is uploaded and there is no account to create.
Free Forever Converter is not affiliated with Amazon. Kindle is a trademark of Amazon.com, Inc.
Frequently asked questions
How do I convert My Clippings.txt to Excel?
Drop the file here and download Excel; every highlight becomes a row with book, author, page, location and date.
Can I import Kindle highlights into Readwise with CSV?
Yes. Choose Readwise CSV and upload it in Readwise under Import → CSV.
My Kindle is in German / Dutch / French — does it work?
Yes. It understands My Clippings.txt in the Kindle’s main languages, including dates.
Is my file uploaded?
No. The conversion runs in your browser.