/ › Blog › File system folders from text, via Excel
    Products · Sign in

    On this page

    • File system folders from text, via Excel
      • Excel sheet

    Info

    • Author: Johnny
    • Date: 2024-07-11
    • Link: jdcm.al/blog/0067

    Community

    • Forum
    • Discord (join server)

    Get organised today

    We spent hundreds of hours designing the perfect system, so you don't have to. Just download it and move in.

    Life Admin System

    File system folders from text, via Excel

    On the forum, Kelso asks:

    How do I change my MindNode into a folder structure onto my computer?

    Great question, best answered with a video.

    Excel sheet

    You can download the sheet from the video here.

    Formulas

    Fill the column

    =IF(C5<>"", C5, D4)

    Create a file path, 'escaping' spaces with a backslash

    =IF(G7="", "", SUBSTITUTE(CONCAT(D7, "/", F7, "/", G7), " ", "\ "))

    Create the mkdir -p command

    =IF(H7="", "", CONCAT("mkdir -p ", H7))

    Create the echo command to create text files

    =IF(G7="", "", CONCAT("echo # ", G7, " > ", SUBSTITUTE(G7, " ", "\ "), ".txt"))


    ā—€ Back The classes of to-do, p… Standard 'life admin' p… Next ā–¶ (Use the ← arrow keys →)

    Learn

    • Documentation
    • Blog
    • Search

    About

    • About us
    • Policies
    • Sitemap

    Support

    • Contact
    • Support
    • Community