Guides
Fix the file problems that waste your afternoon.
Short, practical answers — including the free built-in fixes — with a private tool when you need one.
Your CSV is too large for Excel? Here's why — and 4 ways to open it
Excel stops at 1,048,576 rows. Learn why big CSV files get cut off, how to tell if you lost data, and four practical ways to open or split them.
4 min read
How to remove GPS location and hidden data from photos before sharing
Photos can reveal where you live. Here is how to check a photo for location data and remove it on iPhone, Android, Windows and Mac — before you share it.
3 min read
How to merge PDF files without uploading them anywhere
Most online PDF mergers upload your files to their servers. Here are private ways to combine PDFs on Mac, Windows and in the browser — with nothing uploaded.
3 min read
How to split a large CSV file into smaller files (no code needed)
Split a huge CSV into Excel-sized parts while keeping the header in every file. Compare the command-line method with a no-code option that runs in your browser.
3 min read
Opening a CSV in Excel without losing leading zeros
Excel turns 02134 into 2134 and long IDs into 1.23E+15 when it opens a CSV. Here is why, and three ways to keep your codes and numbers intact.
3 min read
How to remove duplicates from a CSV or mailing list
Clean duplicate rows and repeated emails from a CSV. How Excel's Remove Duplicates works, where it falls short, and a faster way for big lists.
2 min read
How to convert HEIC photos to JPG on Windows, Mac and iPhone
iPhone photos arrive as .HEIC files many apps refuse. How to convert them to JPG on every device — and make your iPhone save JPGs.
2 min read
How to sign a PDF without printing it (Windows, Mac, iPhone)
No printer, no scanner: add your signature to a PDF on Mac, iPhone, Windows or in any browser. Plus what an electronic signature is — and isn't — legally.
3 min read
How to password-protect a PDF (free, on Windows and Mac)
Lock a PDF so only people with the password can open it. Free methods for Mac, Windows and the browser — and how to choose a password that actually protects it.
2 min read
How to remove a password from a PDF (when you know it)
Tired of typing the same password? Save an unlocked copy of a PDF on Mac, Windows or in the browser — and lift printing restrictions.
2 min read
How to delete pages from a PDF (and make sure they're really gone)
Remove blank, duplicate or confidential pages from a PDF on Mac, Windows or in the browser — and make sure deleted pages are really gone.
2 min read
How to rearrange pages in a PDF (drag and drop, free)
Pages scanned in the wrong order, or a document assembled from several files? Here is how to reorder PDF pages on Mac, Windows or in the browser.
2 min read
How to make photos smaller for email (without losing quality)
Email bouncing because the photos are too big? Here is how to shrink photos on iPhone, Mac, Windows or in the browser — and the settings that keep them sharp.
2 min read
CSV shows é instead of é in Excel? How to fix the accents
Excel shows é or ’ when you open a CSV? Why it happens (UTF-8 vs. ANSI) and how to open or save CSV files with the right accents.
2 min read
How to convert JSON to Excel (with nested data)
Need a JSON export from an API or app in a spreadsheet? Convert JSON to Excel with Power Query or in the browser — nested fields included.
2 min read
How to add page numbers to a PDF (free, without Acrobat)
Number the pages of a PDF without Adobe Acrobat: choose the position and format, start at any number, and keep the original layout. Free methods explained.
2 min read
“This data set is too large for the Excel grid”: what it means and how to fix it
Excel warns that the data set is too large for the grid and that you'll lose data if you save. What happened to your rows, and four ways to get all of them back.
3 min read
Excel's row limit (1,048,576): how to check it and work with more rows
Every Excel sheet stops at 1,048,576 rows and 16,384 columns. How to tell whether a file is over the limit, and the practical ways to work with bigger data.
3 min read
How to convert Excel (XLSX or XLS) to CSV — every sheet, accents intact
Save an Excel sheet as CSV without broken accents, export every sheet at once, and pick a comma or semicolon. Methods for Excel, Google Sheets and the browser.
2 min read
How to make a large CSV file smaller — to upload, email or share it
A CSV too big for an upload form, an email or an AI chat? Zip it, drop duplicate rows and unused columns, or split it into parts — without losing data you need.
3 min read
How to check whether an online file tool uploads your files
Many “free online” PDF and image tools send your files to their servers. Three ways to check what a website really does with your documents — in about a minute.
3 min read