13Topic 13 of 15
Everyday tasks
Practical jobs: spreadsheets, transcripts, summaries, data analysis with AI.
- 13.01 Clean Up Messy Spreadsheet Data with ChatGPT Upload the CSV to ChatGPT data analysis, describe the mess once, and get back a cleaned file plus a repeatable formula or script. Limits and traps. 3 min
- 13.02 How to Analyze a CSV with ChatGPT Data Analysis Upload a spreadsheet, get it cleaned, charted, and summarized — plus the limits worth knowing before you trust the numbers. 3 min
- 13.03 How to Summarize a PDF Locally with Ollama Extract PDF text with pypdf, chunk it, summarize each chunk through the local Ollama API, and merge — about 30 lines, nothing uploaded. 3 min
- 13.04 How to Summarize a YouTube Video with AI Pull the transcript with yt-dlp --convert-subs srt, then hand the .srt file to Claude or ChatGPT with a prompt that gives you timestamps, not mush. 3 min
- 13.05 How to Generate Speech Locally with Piper TTS Turn a text file into a WAV on your own machine — install Piper, download a voice, and choose between quality tiers and languages. 3 min
- 13.06 How to Translate an SRT Subtitle File with AI Translate subtitles without breaking timestamps — a copy-paste Python script, the prompt that keeps line counts, and the checks that catch drift. 4 min
- 13.07 How to Transcribe Audio Locally with Whisper Install OpenAI Whisper and ffmpeg, run whisper file.mp3 --model turbo, and get SRT and TXT subtitle files with timestamps out on your own machine. 3 min
Keep going