I wrote a Python script that converts every row of all CSV files in the working directory and subdirectories into markdown files according to the formatting settings you choose per column.
You can:
- add everything as YAML frontmatter
- choose the delimiter of your CSV files
- the maximum file name length
- from which column the file name should be generated
- choose the markdown formatting for each column
- write the chosen settings to
saved_settings.py - or read settings you set before.
It will let you choose the settings for the first file in the list of CSV files it creates, so all the CSV files you run it on have to have the same columns if you want the settings to be applied consistently/if you want it not to fail. (This means that you should only run the script on CSV files with the same number of rows/formatting at once and choose different settings for the next batch.)
This script may be helpful if you want to transfer your data from programs that can export to CSV. The script should give you the best of both worlds. Markdown with its linking, tags and graph view (from Obsidian) and, optionally, all the info as YAML which you can query with dataview to preserve the advantages of a database.
Please consult the Readme for information on installation and updates to the script.
This post will most likely not be updated. To get an up-to-date overview of the features, please follow the link to the repo and read the Readme.
If you find any bugs/have feature requests, please open an issue in the repo.