Guides

Short practical guides from Wataru Watanabe, the maker of c0depad. Scratch workflows for a Mac, written out so they can be found later.

• Edit nested Google Sheets formulas outside the formula barCopy a long Sheets formula into a scratch pad, break it onto lines with ⇧⌥F, fix the logic, and paste it back into the cell.October 9, 2026
• Fix a CSV in bulk without opening a spreadsheetPaste CSV rows into a text pad, replace every pending status with ready, and keep leading zeros such as 02139 intact.October 9, 2026
• Make a one-line JSON API response readablePaste a single-line JSON payload, format it onto lines, scan the keys or find a field, and copy the result back.October 9, 2026
• Mac developer tips I keep usingpbcopy and pbpaste, cd - and git switch -, screenshot shortcuts, caffeinate, Finder from the terminal, and VS Code multi-cursor.October 9, 2026