Excel to Obsidian via .csv to YAML, then multiple files (bidirectional sync?)

Help
1

I was struggling to get my head about YAML and Dataview. Then I noticed that perhaps I could set things up with Excel data and then convert that Excel sheet into Obsidian.

Data like this:

image
image2502×334 64.9 KB

…converted using convertcsv.com or similar
…gives me data like this:

---
-
    Month: 7
    Week: 2
    Month-Week: 7-2
    Date: 2023-07-08
    Lesson name: Phonics
    Day: Saturday
    Time: 10-11am
    Student name: K
    Lesson update: blah blah, lesson notes
    Individual Update: 
    Plan for the next lesson: /U/
    Remark: Will be absent next week
    Link: 
    Row: 2
    FIELD15: 
    FIELD16: 
-
    Month: 7
    Week: 2
    Month-Week: 7-2
    Date: 2023-07-08
    Lesson name: Phonics
    Day: Saturday
    Time: 10-11am
    Student name: S
    Lesson update: reading a story, etc blah blah
    Individual Update: 
    Plan for the next lesson: /U/
    Remark: Will be absent next week
    Link: 
    Row: 3
    FIELD15: 
    FIELD16: 
-
    Month: 7
    Week: 2
    Month-Week: 7-2
    Date: 2023-07-08
    Lesson name: Phonics
    Day: Saturday
    Time: 10-11am
    Student name: J
    Lesson update: blah blah, lesson notes
    Individual Update: 
    Plan for the next lesson: /U/
    Remark: 
    Link: 
    Row: 4
    FIELD15: 
    FIELD16:

But then I don’t know what to do with that .yaml file to get it into Obsidian. If I rename to .md, that gives me one big file, which is then difficult to navigate. I guess I would then best separate it into STUDENT NAMES, which gives me files I can quickly get to with QUICK VIEW.

What I’m trying to do:

Ideally, I’d (1) love to be able to view the same data in Excel and also in Obsidian.
Failing this, I’d (2) like to be able to take an Excel spreadsheet and bring it into Obsidian.

The last option is what I’m doing now, which is where I use an Excel PIVOT TABLE navigate this textual data, then then use HOOKMARK to deeplink to more detailed class notes.

2

Would your usecase fits well with Projects plugin?

This plugin allows you to manage a set of markdown files from folder/tags/dataview sources, and manage the YAML frontmatters the notes.

User ckep1 · GitHub provides a python script to import your spread sheet rows to markdown files named after the first column value.

1 Like