KO | EN

GitLite

Minimalist Open Source Repository Search Engine

gitlite — search

#dsh #dsh-plugin #developer-tools #ai-agent #claude-code #codex #typescript #ai-agents #deepseek-harness #mcp #cli #rust

csv2logseq_block

★ 44 Open GitHub ↗

Python script that can read csv file and output a markdown file containing logseq block and block properties (from csv data), and a basic query script to generate a table query (like the format in csv file). The goal is to simulate notion table database in logseq. Also come with a script to reverse!

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# csv2logseq_block
Hello everone, I like notion database that can create from csv, I also like logseq. But I don't like that notion put my data online. So I try to do something with my basic python knowledge to make a "notion-like table database" in logseq. Feel free to try.

This is a Python script that can read csv file and output a markdown file containing logseq block and block properties (from csv data), and a basic query script to generate a table query (like the format in csv file). The goal is to simulate notion table database in logseq.

Also come with a script to reverse!

I try to fix some problem, also make the usage a little bit easier... maybe not?

# What you need to prepare
- python3
    > which python

> python -V
- make sure you have pandas installed, use follow command to check
    > pip list
- or install pandas
    > pip install pandas
- find your logseq vault

# quick start
- convert '.csv' to '.md' with logseq block structures and a query table with "Table name".

- download and put 'csv2logseq.py' in the same folder as '.csv' file you want to convert, use shell and 'cd' to that folder.
    - type the command, you need to change to your '.csv' filename and your "Table name". Please note that: the "" is necessary for the table name of query table.
        > python csv2logseq.py filename.csv "Table name"
    - it will read the '.csv', and output a '.md' file with logseq block/block properties structrue in the same folder. 
    - then you can copy the output '.md' file to your logseq vault (ie. in "pages" folder).

- convert '.md' with logseq block structures to '.csv'.

- if you want to reverse the process, ie, read '.md' file with logseq block/block properties structrue and output a '.csv' file, please use 'logseq_block2csv.py'. 
    - just download and put it in the same folder as the '.md' file you want to convert, use shell and 'cd' to that folder.
    - type the command, you need to change to your '.md' filename.
        > python logseq_block2csv.py filename.md
    - the script will output the '.csv' file in the same folder as well. 
    - but please note that: the script is very sensitve to the format in '.md' file, you'd better make the '.md' file as neat as possible.

# Image
- expand the major block

- collapse the major block

- click one block from query table, you can create new page from \[\[block title]].

# Video

- csv2md

https://user-images.githubusercontent.com/85311840/152845713-166aa24a-fed2-4745-aca5-2953d6388783.mp4

- md2csv

https://user-images.githubusercontent.com/85311840/152845754-997651d8-8bad-4fc9-9ad4-b3eba06d5c48.mp4

# Advanced use 
- go to the 'advanced' folder and download a little bit different 'csv2logseq.py'
- add this script into your $PATH (or put it in a folder that already in your $PATH)
- change a little bit in the script
  - 1st line: path to your python
  - 22th line: path to your logseq vault folder
- now you can use the follow command in any folder that contains csv files and the output file will directly appear in your logseq vault folder
    > csv2logseq.py filename.csv "Table name"

csv2logseq_block

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README