Guides
Practical guides to the problems the mygems apps were built for — big CSV files, mind maps, habits that stick. Written by the person who builds them.
- 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 is a text file with commas in it. XLSX is a compressed application file. That difference decides everything — size, formulas, dates, and who can open it.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