@SimonW We have a similar way of getting the info into Obsidian. I exported my existing info into csv from a database I had, transferred to google sheets, added a bunch of columns (including the yaml — type separators) and then I use a script that converts each row into an md file just the way I like it, with headers and all. Most of the data with never change; I mean the film info like runtime and director, etc, doesn’t change so I’m good with that. The things that will change are my personal details, like viewing date, and reviews.
My most recent way around that (still testing) is to keep two film folders: one for the Film Titles (e.g., Die Hard, with the runtime, director, etc) and another for the Personal Details (e.g., Die Hard - Personal with stuff like my rating, viewing dates, reviews). The title page would include the personal details page via ![[ ]] (which is included in my Google Sheets).
That way if I ever have to re-import or change the format of the yaml for the main title page I can do it without interfering with all my other data.
The issue, of course, is getting that into html in the future. Pretty sure an md file with an internal link to the personal details wouldn’t display the personal details, which is what I want thte most, so I have to think on that. Nor am I particularly enchanted with having two pages for each film, but at least it seems like a workable solution, assuming I can get all the info into a webpage.
Edit → I forgot to ask: what do you use to " export the notes out when required back into CSV"?