Blog

Export Highlights to CSV: A Workflow That Keeps the Source

Updated · 15 min read

Export Highlights to CSV: A Workflow That Keeps the Source

Listen to this post

0:000:00

Share this post

Contents

To export highlights to CSV, use the export function of the app where you made them, then check the file before you trust it. A good export has one row per highlight, with the passage, your note, the source title and a location in separate columns. If a tool gives you only the quoted sentence, you will have a spreadsheet of orphans within a month. We built Omphalis around the opposite idea: a highlight should stay attached to the passage it came from. Its notebooks and export features are made for that.

This guide covers the steps for ebooks, notes apps and saved articles. It also gives a column layout that works, a Markdown route for notes, and a short check that catches the quiet failures.

TL;DR

  • Kindle can email you highlights as CSV and PDF. Apple Notes exports single notes as Markdown on a Mac.
  • Design the columns before you export: passage, your note, source title, author, location or page, date, tag.
  • A CSV that downloads is not necessarily correct. Check encoding, row shape and a few known highlights.
  • Use CSV for sorting and filtering, and Markdown for reading and linking. Keep both tied to the original source.
  • Omphalis keeps your notes attached to the original passages, and you can export your notes and what you save on any plan, including the free one.

Table of Contents

What a highlights CSV is good for

CSV is plain text with one record per line and fields separated by commas. Every spreadsheet and most databases open it. That makes it the right format when you want to do something to your highlights as a set: sort by book, filter by tag, count how many you made per chapter, or paste a column into a flashcard tool.

It is the wrong format for reading. A long passage inside a spreadsheet cell is hard to scan, and formatting such as bold text, lists and links does not survive. If your goal is to read your notes again in a week, Markdown is usually better. If your goal is to analyze or move them, use CSV. Plenty of people need both, and the sections below show how to get each.

Decide the columns before you export

Most frustration with exported highlights comes from missing context, not from the file format. A line like "the effect disappeared after the second trial" tells you nothing six months later unless you know which paper it came from. Here is a layout that holds up:

Column What it holds Why it matters
highlight The exact passage you marked The raw evidence
note Your own comment on it Your thinking, kept apart from the quote
title Book, paper, article or episode Lets you group and cite
author Writer or speaker Needed for citations
location Page, chapter, timestamp or paragraph Lets you find the passage again
date When you made the highlight Shows what you read when
tag A topic or project label Makes filtering possible

Not every tool produces every column. When one leaves out location or title, add them before the data gets mixed with other sources. Doing it later means guessing which book each row came from.

Keep the highlight and the note in separate columns. If they are merged, you can no longer tell the author's words from yours, and that is how paraphrase turns into accidental misquotation.

Export highlights from an ebook reader

The Kindle route is the one most people search for, and it is built into the device. According to a walkthrough of Kindle export methods, you open the book, tap the top edge of the screen, press the three-bar icon, go to Notes & highlights and tap Export notes. Amazon then emails the highlights as PDF and CSV files to the address linked to your Amazon account.

Things to watch for:

  1. One book at a time. The export is per book, so a library of fifty titles means fifty emails. Plan to merge the CSVs, and add a title column first if the files do not carry one.
  2. Check the inbox, then the spam folder. The file goes to the Amazon account address, which may not be the address you read daily.
  3. Clean before merging. Delete empty rows and header rows that repeat once files are combined.

If you want the reverse, bringing Kindle highlights into a reading space where you can annotate them further, we cover it in our guide to importing Kindle highlights.

Other ebook apps differ. Some offer an export button inside a notebook view. Others store annotations in a local database that you have to open separately. The pattern is the same everywhere: find where the app keeps annotations, export per book, and compare the first rows with what you remember marking.

Export notes to Markdown

Markdown suits notes you want to read and link. It keeps headings, lists, bold text and block quotes in a plain file that any editor opens.

On a Mac, Apple Support explains the steps for Apple Notes: open the note, choose File > Export To, select Markdown and save. You can also copy part of a note as Markdown with Edit > Copy as Markdown, which is handy when you want one section and not the whole note.

That covers notes you typed. Highlights from books and articles are a different case, because the quote and your comment need to appear together with their source. A Markdown file for a reading session should look like this:

# Title of the source
Author, year, link

> Exact passage you highlighted

Your note: why it matters, what it connects to.

The block quote marks the author's words and the plain line below marks yours. That separation is the same one the CSV columns give you, in a form made for reading.

A Markdown export workflow for study or research

A workflow only works if you will actually repeat it. This one takes about ten minutes a week.

  1. Capture in one place. Read and highlight inside one environment as far as you can. Scattering highlights across five apps means five exports to run.
  2. Write the note while the passage is fresh. One sentence on why you marked it is worth more than a hundred untagged highlights.
  3. Tag by project, not by topic. "Thesis chapter 3" is easier to act on than "memory."
  4. Export weekly in both formats. CSV goes to your master spreadsheet. Markdown goes to your notes folder, one file per source.
  5. Name files predictably. Something like 2026-11-author-short-title.md sorts well and is easy to search.
  6. Link back to the source. Put the URL, DOI or file name at the top of each file so you can reopen the original.

For students, the highlights themselves are only half the job. Our piece on a PDF highlighting strategy that turns highlights into flashcards shows how to mark selectively, so your export is a short list of what matters instead of a copy of the whole page.

Check the export before you trust it

A CSV can download without errors and still be wrong. One guide on validating CSV files suggests checking in layers: first the bytes (valid UTF-8, whether a byte order mark is present), then the structure (header names and row shape), then the schema (what type or pattern each column should have), and finally the values and keys. Each layer can fail on its own, so a file that looks fine in a spreadsheet may still be broken underneath.

A developer write-up on testing CSV exports makes a related point. A successful download proves little. Lost time zones, dropped leading zeros and the difference between a missing note and an empty one can all slip through. Its answer is to check the exported text and the values you recover from it.

For a highlights file, here is a five-minute version:

  • Open it in a plain text editor first. You should see a header row and one record per line. Quoted passages containing commas should be wrapped in quotation marks.
  • Look for garbled characters. Curly quotes, accents and non-Latin text that appear as odd symbols point to an encoding problem. Re-import the file and choose UTF-8 explicitly.
  • Count the rows. Compare the number of rows with the number of highlights in the source.
  • Spot-check three highlights. Pick one from the start, one from the middle and one from the end. Confirm the text, note and location match.
  • Check the notes column. Make sure highlights you did not annotate show a blank note, and that annotated ones did not lose their comment.
  • Check dates. Confirm the date column was not silently reformatted by the spreadsheet.

Do this once per source type. After that you only need to repeat it when an app updates or you switch tools.

When highlights are missing or the file is hard to use

Missing highlights usually have one of a few causes.

The highlight never synced. Highlights made offline may not have reached the account you exported from. Open the app online, let it sync, and export again.

The source is a scanned document. A PDF that is really an image has no selectable text, so there is nothing for a highlighter to attach to. Our guide on making scanned text selectable with OCR covers how to fix that before you start marking.

The highlight was made in a different copy. Two versions of the same book or paper, for example a publisher PDF and a downloaded preprint, keep separate annotations. Export from the copy you actually used.

The file opens as one long column. The spreadsheet did not split the fields. Use its import function, pick comma as the delimiter and set the encoding to UTF-8, instead of double-clicking the file.

Passages are cut off. Some spreadsheets display only the first part of a long cell. The full text is usually still there. Widen the column or check in a text editor before you assume data was lost.

When highlights are missing or the file is hard to use

How export differs for ebooks, PDFs and web articles

The source type decides how much context you get back.

Source Typical export What tends to be missing
Ebook Per-book file by email or in a notebook view Page numbers that match the print edition
PDF Annotation list or extracted text Surrounding paragraph, unless you save it
Web article Often nothing built in The page itself if it changes or disappears
Podcast or video Notes with timestamps, if the app supports them The spoken context around the moment

Web articles are the weakest link. Pages get edited, moved behind paywalls or deleted. If you highlight on the open web, save a clean copy along with the highlight. We walk through that in how to annotate web articles in your browser. For PDFs, our walkthrough of annotating on Windows, Mac and mobile explains how structured notes carry over.

Keep the source and context with every highlight

A highlight without context is the main reason exported notes go unused. Four habits fix most of it.

  1. Store a locator, not just a title. Page, chapter, paragraph or timestamp. "Chapter 4" gets you back in a minute. A title alone sends you through the whole book.
  2. Keep a few words either side. When the highlight is a fragment, add the sentence before it. Meaning often sits in the previous line.
  3. Record the version. Edition, publication date or retrieval date. This matters for web pages and preprints.
  4. Separate quote from comment. Never merge them in one cell or one paragraph.

The same logic applies when you move notes out of a reading space into a document. If you are writing a paper or sharing notes with a group, you may want a format people can open without a spreadsheet. We cover that in exporting notes to DOCX and in exporting notes to PDF without losing multipage attachments.

Where Omphalis fits

Exporting is the last step of reading, and it only works as well as what you captured earlier. Omphalis is a platform for saving, reading and annotating articles, papers, podcasts and videos. Your notes stay attached to the original passages, so each highlight keeps its source. It imports PDFs, EPUBs, Word documents and feeds, organizes work into notebooks and has export features.

You can export your notes and what you save on any plan, including the free one. On the pricing page, Pro is 9 USD per month or 90 USD per year, Premium is 19 USD per month or 190 USD per year, and Scholar is 39 USD per month or 390 USD per year. One-off unit packs start from 10 USD.

Omphalis

If your highlights currently live in five places, see how highlights and notes that reopen the passage work in Omphalis.

Our perspective

Highlighting feels like learning, and often it is only collecting. The export is where that shows. A spreadsheet with four hundred quotes and no notes is a pile, not knowledge.

We built Omphalis around a different order of work. You read the full source, ask for an explanation of a hard passage when you need one, and write your own note next to the exact words that prompted it. The note and the passage stay together, so when you come back, you return to the source and not to a loose sentence.

We think the export should be a by-product of understanding, not a rescue operation. That is why notes live in notebooks, tied to the originals, and why we care about connecting related material and keeping citations to the source. Speed-focused summaries can leave you with a feeling of having read something. Keeping the whole source in view helps you know what you read.

Whatever tool you use, apply the same test to your export: could you find the original passage in under a minute? If so, your workflow works.

Omphalis Team

CSV or Markdown: choosing the format

Pick by what you will do next.

  • Sorting, filtering, counting or merging many sources: CSV. Spreadsheets handle this well, and you can paste a column elsewhere.
  • Reading, linking and writing from your notes: Markdown. Block quotes keep the author's words visible, and the files work with any text editor.
  • Sharing with someone who just wants to read: DOCX or PDF.
  • Archiving: keep both CSV and Markdown, plus the original source files.

Because the export step is cheap once your notes are structured, you do not need to decide upfront. Capture well, and the format becomes a choice you make at the end.

FAQ

How do I export Kindle highlights to CSV?

Open the book on your Kindle, tap the top edge, press the three-bar icon, go to Notes & highlights and tap Export notes, as described here. Amazon emails PDF and CSV files to the address on your Amazon account. The export is per book, so repeat it for each title.

Why does my exported CSV look wrong in a spreadsheet?

Usually the spreadsheet guessed the delimiter or encoding. Use its import function instead of double-clicking, choose comma as the delimiter and UTF-8 as the encoding. Then compare the row count and a few known highlights with your source.

What should a highlights file include besides the highlight?

At minimum: your note, the source title, the author, a location such as a page or timestamp, and the date. A tag helps with filtering. Without a location, finding the original passage later means rereading.

Can I export a note as Markdown on a Mac?

Yes. In Apple Notes, open the note, choose File > Export To, select Markdown and save. You can also use Edit > Copy as Markdown to copy only part of a note, according to Apple Support.

Should I keep highlights and my own comments in separate columns?

Yes. Separate columns keep the author's words apart from yours, which prevents misquoting and lets you filter for passages you annotated. It also makes later checks easier, because a blank note then clearly means you wrote none.

Sources