Skip to main content

Guides & Tutorials

Learn how to master file management, markdown editing, data processing, and more. Expert guides for busy professionals.

📊 Data & Files

Handle large datasets, convert formats, and optimize file management

📊

CSV, Excel & Parquet Guide

Master data file formats and choose the right one for your needs

Convert Excel to Parquet

Process large Excel files 10x faster with Parquet format

🔄

CSV to JSON Converter Guide

Convert CSV to JSON offline — output shapes, streaming, and privacy explained

📈

Excel to CSV Converter Guide

Convert .xlsx, .xls, .xlsb, and .ods to CSV offline — multi-sheet, encoding, and date pitfalls explained

📋

CSV to Excel Converter Guide

Convert .csv to .xlsx offline — Excel 1M-row cap, leading zeros, and multi-sheet rollup pitfalls explained

🧹

Data Cleaning for Beginners

Learn to clean and prepare data files for analysis

💾

Work with Large Files

Handle massive datasets without crashing your computer

📤

File Upload Size Limits by Platform

GitHub, Gmail, Discord, WhatsApp & more — and how to compress to fit

🐙

GitHub File Size Limit

Every GitHub upload limit and how to compress a file to fit

📁

Windows 11 File Explorer 2026 Update

What's new in Windows 11 File Explorer and better alternatives

🗂️

Best Finder Alternatives for Mac

Seven Mac file managers compared — dual-pane power tools, free options, and a local-first browser with built-in convert and compress tools

🗂️

Best File Explorer Alternatives for Windows 11

Seven Windows 11 file managers compared — dual-pane power tools, free open-source options, and a local-first browser with built-in convert and compress tools

🔍

Spotlight Not Finding Files on Mac

Rebuild the Spotlight index, fix the common causes, and search inside file contents (PDF, DOCX, code) with a live tool that does not depend on the index

🔎

Windows Search Not Finding Files

Rebuild the Windows index, fix the search service, stop SearchIndexer high CPU, and search inside file contents (PDF, DOCX, code) with a tool that does not depend on the index

🔒

Are Online File Converters Safe?

The FBI-documented risk of free converters, and how to convert PDFs, images, and video locally instead

🔄

Best Offline File Converter (No Upload)

Eight offline file converters compared for Mac and Windows — single-purpose champions, all-in-one apps, and a local converter for images, video, documents and data that never uploads

📄

Compress a PDF on Mac and Windows

The exact Mac Preview steps, the honest Windows options (zip-trick myth debunked), and a free offline app that works the same on both

📄

Remove Pages from a PDF on Mac and Windows

The exact Mac Preview steps, the honest Windows options (browser print-to-PDF caveats), password-protected PDFs, and a free offline app that works the same on both

📄

Split a PDF on Mac and Windows

The Mac Preview and Automator paths, the honest Windows browser print-to-PDF caveats, password-protected PDFs, and a free offline app that splits every page, by range, or every N pages

📊

Open a Parquet File (No Code)

View, search, and filter .parquet files without Python or pandas

💾

Open a Large CSV or Excel File

Open files too big for Excel — millions of rows, without crashing

🗄️

Open a SQLite Database File

Browse tables and rows in a .db / .sqlite file without writing SQL

🔄

Transpose a CSV or Excel File

Swap rows and columns to read a wide spreadsheet — no formulas

📌

Freeze or Pin Columns in a CSV

Keep key columns visible while scrolling a wide CSV or spreadsheet

📓

View a Jupyter Notebook (.ipynb)

Read a notebook's code and outputs without installing Jupyter

🎬 Media Optimization

Compress videos and images without sacrificing quality

Ready to Work Faster?

Put these guides into action with FileHop. Free download for Mac and Windows.

Download Free