switch·Esc back

Python

You might say

What's the language everyone recommends for automating spreadsheets and files with a script?

A programming language often used to automate work on a computer or serverA Python script can read three Markdown notes and write their titles into summary.csv. It runs on a local machine or server; an ordinary web page does not execute a local Python script by itself.
Know first
Py
Turn three notes into one summary file
notes▤ product-plan.md▤ user-interviews.md▤ launch-checklist.md
summarize.py
1for file in Path("notes").glob("*.md"):
2 title = file.read_text().splitlines()[0]
3 rows.append([file.name, title])
4write_csv("summary.csv", rows)
Terminal
$ python summarize.py
Waiting to run…
How a script organizes several files

Choose the filesThe script finds the .md files and reads their text.

Apply one ruleFor example, it can use the first line of each note as a title.

Write the resultIt creates summary.csv on the machine or server that ran it.

Learn next
Further reading