Guides: CSV, JSON and iPhone video
Step-by-step guides to everyday file problems: open and clean big CSV files, fix and convert JSON, edit video on iPhone. Written by the person who builds the mygems apps.
- 30-day challenge ideas that survive day nineThirty 30-day challenge ideas for health, focus, skills, money and people, each with the small version that keeps a bad day from ending the month.Read the guide
- How to format JSON so you can read it (2026 guide)One command turns a 40,000-character line into readable JSON. Here is how in a terminal, an editor, a browser and on a phone, without pasting it into a website.Read the guide
- How to make a chart from a CSV fileMost CSV chart failures are data failures: a number stored as text, one N/A, the wrong column as labels. Here is how to chart a CSV in Excel, Sheets, Python or on a phone.Read the guide
- How to filter a CSV file and keep only the rows you needFilter a CSV by a value, a range or several conditions, then save just those rows. Excel, Sheets, the command line, and a phone, with the traps in each.Read the guide
- How to convert JSON to CSV without losing dataJSON is a tree and CSV is a rectangle, so every converter makes choices. Here is what they are, how to flatten nested JSON, and the tools that do it well.Read the guide
- How to flip or mirror a video on iPhone (2026 guide)The Photos app mirrors a video horizontally in three taps. Here is how, how to flip one upside down, and why a mirrored selfie video happens at all.Read the guide
- How to total a column in a CSV file without ExcelSum, average and count a CSV column, or total it per category, without opening Excel. One-liners for the terminal, Sheets, and a phone.Read the guide
- How to open a JSON file on iPhone and iPad (2026 guide)iOS shows a JSON file as one unreadable line of text. Here is how to read it properly on iPhone and iPad, from the free Files preview to a real editor.Read the guide
- How to stop Excel changing your CSV dataExcel strips leading zeros, turns IDs into 1.23E+15 and codes into dates the moment it opens a CSV. Here is how to import it so nothing changes.Read the guide
- How to reverse a video on iPhone (2026 guide)Neither Photos nor iMovie on iPhone can play a video backwards. Here are the routes that can, the one that's free, and what to check about the audio.Read the guide
- How to fix invalid JSON: every common error, explainedUnexpected token, trailing comma, single quotes, a comment where none is allowed. What each JSON error means, how to find the line, and how to fix it.Read the guide
- How to analyze a CSV file with AI, and what it sends (2026 guide)ChatGPT, Claude and Gemini can all read a CSV, but they read all of it. Here is how each one works, where they get numbers wrong, and a way to ask without uploading.Read the guide
- Paper habit tracker vs an app: which actually worksPaper wins on friction and visibility; an app wins on memory and evidence. Here is what each is better at, and how to make an app behave like paper.Read the guide
- How to make a decision with a mind mapMost stuck decisions are stuck on vague options and unstated criteria, not analysis. Map to find both, then leave the map and compare in a table.Read the guide
- How to track a habit you don't do every dayThree times a week on a daily grid means every off day reads as a miss. Here is how to pick between fixed days, a weekly quota and an interval, and fix the streak.Read the guide
- How to fix a mind map that has become unreadableToo wide, too deep or too tangled: three different failures that look identical. Here is how to tell which you have, and the five fixes in order of cost.Read the guide
- Habit tracker vs to-do list: which one holds whatA to-do list holds things that get finished; a tracker holds things that get repeated. Put a habit on a list and every missed day becomes a debt you cannot pay.Read the guide
- How to mind map a book you have readHighlights are a list of the author's sentences in the author's order. Here is a four-branch method that records what a book argues, and how to revisit it.Read the guide
- How many habits should you track at once?Fewer than you want to. The limit is on habits still in progress, not habits you have. Five tracked habits is how people lose four in one bad week.Read the guide
- How to outline an article with a mind mapA blank page asks you to find out what you think and put it in order at once. A map splits those apart: dump everything, find the shape, then export the outline.Read the guide
- Habit stacking: how to attach a new habit to one you already haveAfter I [existing habit], I will [new habit]. Here is what makes an anchor reliable, why one habit per anchor matters, and how to diagnose a stack that stopped.Read the guide
- Mind map vs concept map vs flowchartMind map: a tree. Concept map: a network with labelled links. Flowchart: steps in order. A side-by-side table, and how to pick by the question you have.Read the guide
- How to read a bank statement CSVPreamble rows, two amount columns, ambiguous dates and everything crammed into the description. Here is how to make a bank export answer a question.Read the guide
- How to plan a project with a mind mapA mind map is the right tool for the first two hours of a project and the wrong one for the rest. Here is how to scope, decompose and then hand over.Read the guide
- How to restart a habit after breaking itA missed day costs almost nothing; the response to it costs the habit. Here is how to tell resuming from restarting, and what actually broke.Read the guide
- How to turn a Markdown outline into a mind mapAny indented list is already a tree, so the conversion is a change of view. Here is how to write an outline that imports cleanly, and get one back out.Read the guide
- How to compare two CSV files and find what changeddiff compares lines, so a re-sorted export looks entirely rewritten. Here is how to compare by key instead: what is new, what is gone, what changed.Read the guide
- How long it actually takes to form a habitThe 21-day rule comes from a 1960 book about plastic surgery. The research says a median of 66 days, with a range of 18 to 254. The range is the useful part.Read the guide
- How to convert a CSV to PDFA CSV has no page and a PDF is nothing but pages, which is why columns fall off the edge. Here is how to decide what goes in before you convert.Read the guide
- How to use mind maps to studyBuilding a map helps; looking at one is re-reading. Here is how to make study maps you can test yourself against, and what to use flashcards for instead.Read the guide
- How to remove duplicate rows from a CSV fileMost duplicates are two records for one person rather than identical lines, and one of them is newer. Here is how to find them and keep the right one.Read the guide
- How to merge multiple CSV files into oneConcatenation matches columns by position, so one file with a different header order quietly ruins the result. Here is how to merge by name, and verify it.Read the guide
- Habit tracking without notifications: a quieter methodReminders stop working the moment you learn to swipe them away. Here is how to build habit tracking that runs on placement and review instead of alerts.Read the guide
- How to turn meeting notes into a mind mapLinear notes bury what a meeting actually produced: the decisions, the open questions, who owes what. Here is a repeatable way to restructure them into a map.Read the guide
- Free AI mind map generators, compared (2026 guide)Most free AI mind map tools cap you at three maps, watermark the export, or want an account first. Here is what each one actually gives away, and where it stops.Read the guide
- Why Excel crashes on large files, and what to do insteadNot responding, frozen on scroll, dead on save. The cause is usually memory, recalculation and formatting rather than the row count. Here is how to tell which one.Read the guide
- How to open a 1GB CSV file (2026 guide)A gigabyte is where most tools stop being honest about what they can do. Here is what opens a 1GB CSV, what it costs in RAM, and what quietly truncates.Read the guide
- How to run SQL queries on a CSV file without a database (2026 guide)You do not need Postgres to run a GROUP BY. Here is how to query a CSV in place with DuckDB, SQLite, q or your phone, and which one fits which situation.Read the guide
- How to open a large CSV file that Excel won't open (2026 guide)Excel stops at 1,048,576 rows, and sometimes truncates without telling you. Here is how to open, read and edit a huge CSV file on desktop, and on a phone.Read the guide
- How to fix a broken or malformed CSV fileEverything in one column, stray quotes, rows that split in half, mojibake in the names. Here is how to diagnose what is actually wrong with a CSV, and repair it.Read the guide
- How to convert a CSV to Excel on a phoneYou have a .csv on your phone and someone wants an .xlsx back. Here is how to convert it on iOS or Android, and how to avoid the ways the conversion mangles data.Read the guide
- CSV vs XLSX: which format to use, and whenCSV has no row limit and keeps values as written; XLSX keeps formulas and types but stops at 1,048,576 rows. When to use which, and how data gets lost.Read the guide
- The best free ways to view a CSV file on Android (2026 guide)Most free Android CSV apps are ad-heavy, truncate large files, or are Google Sheets in disguise. Here is what each option actually does, and where each one breaks.Read the guide
- How to open a CSV file on iPhone and iPad (2026 guide)Tapping a CSV in Files or Mail shows a wall of raw text, or nothing at all. Here is why that happens on iOS, and every route to actually reading the file.Read the guide