/weread-notion

Convert notes from Weread into a csv that can be merged with notion table.

Primary LanguagePythonMIT LicenseMIT

微信读书笔记 Notion 转换器

这是一个由椒盐豆豉开发的简单微信读书笔记转换为 Notion table 的小工具。 因为最近开始做读书笔记剪报 channel,因此需要一些排序、过滤功能,以前偷懒直接纯文本粘贴的微信读书笔记就不好使了。索性写了个 script.

*** 本 script 仅在 MacOS 上测试过,Windows 不知道有没有问题,就算有我猜轻微改一下能用,如果有试了的朋友欢迎告诉我。 ***

Notion 最终效果:

Name Highlight Note No.
章节名 你的高亮/划线 你的笔记/想法 用来排序的序号

变成在 notion 的表格之后后续可以导出、自己加新 field 排序、filter 等,配合其他工具使用参见之前这篇中的效果:读书笔记 workflow。

如何使用

  1. 用 git clone 下载基本代码到你的 Mac 上
  2. 进入微信读书->笔记,点击“导出”
  3. 点击底部的“复制到剪切板”
  4. 把剪贴板内容粘贴进一个 txt 文件
  5. 在 Mac terminal 里 python3 weread.py [txt 文件地址]来运行本工具,生成一个 csv 文件
  6. 在 Notion 里创建一个数据库
  7. 点击数据库右上角的'...',选择'Merge with CSV'
  8. 等待导入结束并刷新 Notion 页面
  9. 再次点击'...' -> 'Sort', 对'No.' field 添加一个 Ascending sort
  10. 如果笔记很少的话 Notion 可能会把你的笔记变成单选类型。点击数据库表头的'Note'部分将 property type 改成'Text'即可
  11. 去掉无用的 Notion 默认生成的列,如 'Tags'

weread-notion

This is a simple script created by Mt Front that converts Weread notes export to a csv, so it can be import to Notion into a table. Made for my reading notes channel because filtering and sorting is just much more easier this way.

*** Warning: This script has only been tested on MacOS. If you're using Windows please let me know if it works. ***

Output table format in Notion:

Name Highlight Note No.
Chapter Underlined highlights Notes/thoughts Index used to sort

How to use:

  1. run git clone of this reopo on your Mac
  2. In Weread, go into your notes, click "export"
  3. Click "Copy to clipboard” on the bottom
  4. Paste the copied notes into a txt file.
  5. Run this script by typing 'python3 weread.py [txt file path]' in termincal, the script will create a csv file
  6. In Notion, create a table (can be either inline or entire page)
  7. Click the '...' on right top cornor of your table, chose "Merge with CSV"
  8. Wait for import to complete and refresh the notion page
  9. Click the '...'->sort, add an ascending sort on 'No.' (why does stupid notion import in random order?)
  10. Notion may convert your 'Note' column to 'Type'. Simply click on the header and change property type to 'Text'
  11. Remove default unsed fields like "tags"