How to export Kindle highlights to Markdown, text or a spreadsheet on a Mac

By

Your Kindle highlights are in My Clippings.txt, all books mixed together. Here's how to pull one book's highlights out by hand in TextEdit, and how to save them all by book as Markdown, plain text or CSV.

You want the passages you highlighted in a book on your Kindle in your notes app, or in a spreadsheet. They’re in My Clippings.txt on the Kindle, a plain text file with every highlight, note and bookmark of every book, in the order you made them. The tutorial about My Clippings.txt explains where it is and what each line means.

Getting one book out of it by hand is copy and paste in TextEdit. Getting all of them out, by book, in a format another app understands, is where it gets long.

One book by hand, in TextEdit

I tried this on a stand-in Kindle: an 8 GB disk image formatted FAT32 like a Kindle that shows up as a disk, named Kindle, with a documents folder. On the Mac it behaves like an older Kindle plugged in by cable. Its My Clippings.txt is one I made, 14 entries from 5 public-domain books in the layout a Kindle writes. The passages are real lines from those books, and the notes, locations and dates are made up.

  1. Open My Clippings.txt in TextEdit. I’d copy it to the Desktop first and open the copy.
  2. Choose Edit > Find > Find… (Command-F) and type part of the book’s title.
  3. Press Return to go from one entry to the next.

For Walden, TextEdit found 3 matches, one per entry: two highlights and a note.

TextEdit with the Find bar showing Walden and 3 matches, and the file scrolled to the two Walden entries, the first match outlined and the second highlighted in yellow

  1. Choose File > New for an empty document, then Format > Make Plain Text.
  2. Copy each passage from My Clippings.txt and paste it into the new document.
  3. Save it with a name ending in .txt, or in .md for a Markdown file.

For a spreadsheet, it’s the same copying, one cell at a time: the book, the type, the location, the date, the passage.

Where it stops

Three Walden entries is a minute of work. My made-up file has 14. A Kindle used for a few years can have thousands, and each one is four lines to look at and one passage to copy.

The location and the date stay behind unless you copy them too, and a note ends up wherever you paste it, not under its passage.

By hand in TextEditTransfer for Kindle
One bookFind, then copy each passageClick the book, Export This Book…
Every bookRepeat for each titleExport All…, one file
MarkdownFormat it yourselfA heading per book, passages as quotes
SpreadsheetOne cell at a timeA CSV with a row per highlight
Location and dateCopied by hand, if you want themUnder each passage, or in their own column

Export them by book

Transfer for Kindle is a Mac app I made that reads My Clippings.txt from the Kindle and saves the highlights by book. It’s my own app, not made by, affiliated with or endorsed by Amazon. It costs $20, paid once.

Click Highlights, pick a format at the bottom, and click Export This Book… for the selected book, or Export All… for every book. The app asks for a folder, starting in Downloads, and saves the file there. I picked a folder named Kindle highlights:

Transfer for Kindle on the Highlights tab, with Format Markdown, Export This Book… and Export All… at the bottom, and Saved “Kindle Highlights.md” in Kindle highlights next to them

Markdown

Here’s the start of Kindle Highlights.md. Each book is a heading, each passage a quote with its location and date, and the note sits under the passage it’s on:

# Pride and Prejudice

by Jane Austen

> It is a truth universally acknowledged, that a single man in possession of a good fortune must be in want of a wife.

*Location 112-113 · October 3, 2026*

**Note:** The opening everyone quotes. It reads like a joke on the reader.

Within a book, the highlights are in the order they appear in the book. Walden’s “The mass of men lead lives of quiet desperation”, at location 154, comes before “I went to the woods”, at 1288, though I made it later.

Plain text

Kindle Highlights.txt is the same, without the Markdown signs:

Pride and Prejudice
by Jane Austen

It is a truth universally acknowledged, that a single man in possession of a good fortune must be in want of a wife.
(Location 112-113 · October 3, 2026)
Note: The opening everyone quotes. It reads like a joke on the reader.

CSV, for a spreadsheet

Kindle Highlights.csv has a row for each highlight, note and bookmark, with these columns: Book, Author, Type, Page, Location, Added, Text. A CSV opens in Numbers, Excel or Google Sheets as a table. Here it is in TextEdit, so you can see what’s inside:

TextEdit showing Kindle Highlights.csv: the header Book,Author,Type,Page,Location,Added,Text, then one row per entry, like Pride and Prejudice,Jane Austen,Highlight,,112-113,2026-10-03 21:14:22, and the passage in quotes, with titles that contain commas in quotes too

The Page column is empty in my file, because my made-up entries only have locations.

The app never replaces a file. When I exported CSV a second time into the same folder, the new file became Kindle Highlights 2.csv:

The Finder showing the Kindle highlights folder: Kindle Highlights 2.csv and Kindle Highlights.csv, Plain Text, Kindle Highlights.md, Markdown document, and Kindle Highlights.txt, Plain Text, each 2 KB

FileSizeGood for
Kindle Highlights.md1,716 bytesA notes app that reads Markdown
Kindle Highlights.txt1,661 bytesAnything that opens text
Kindle Highlights.csv2,177 bytesNumbers, Excel, Google Sheets

I also exported the highlights of my own Kindle this way, an older one that shows up as a disk.

Get Transfer for Kindle

Plug your Kindle into your Mac and see its books, send your own EPUB, PDF and other books to it by cable, copy books back, and save your highlights. An EPUB is turned into a book the Kindle opens, on your Mac, with nothing uploaded.

See Transfer for Kindle → · Read the docs · $20. See the app page for tax details.

More tutorials for my apps →

Want me to talk about your product? You can sponsor this site.