Move from Excel/CSV to Obsidian Bases

Disclaimer

Is this project open source? Yes
Is this project completely free? Yes
Is this project vibe-coded beyond the author’s ability to comprehend how it works? No

Should the mods use the ban hammer? No, I am sharing something that’s free, that I’ve used for a work project, and that isn’t for self-promotion.


Hi everyone,

I helped our Finance team move their log and deposits sheets from Excel to Obsidian bases. My pitch for Obsidian before Bases existed didn’t work out but one day earlier this year I remembered they exist after I still got requests to find a multiplayer solution for Excel, with Proton Drive being considered unacceptable. The ability to link to scanned documents helped seal the deal.

Anyway, after several hours, I had Claude Opus 4.6 vibe code a HTML/JS/CSS web app that exports each row of a CSV file into multiple Markdown files with the headings as frontmatter properties and the other cells as values that you can place into your Obsidian Vault.

Here are the links to the Repo and Netlify-hosted web app.

Another thing that helped is finding the Base formula equivalent of XLOOKUP in Excel, so that the Accounts files could be referenced for the bank name and account holder name.

Example for single word properties:

file1property.asFile().properties.file2property

Example for properties with spaces and symbols in their name:

note["Something Useful"].asFile().properties["A - B"]

Please let me know if you have any questions!

2 Likes