Guides

Free Excel Guides: Fix Errors and Clean Your Lists

Short, practical Excel guides for the problems that cost the most time. Is VLOOKUP showing #N/A although the value is in your list? Did Excel remove the zero from your ZIP codes? Do your dates refuse to sort, does your list have double rows, or does Excel freeze? Each guide gives you up to three fixes in plain words, with formulas you can copy. Where one of our free tools saves you the work, the guide links to it. The tools run on your own computer, and your file is never uploaded. Pick your problem below.

Fix Excel errors and formulas

Clean and format your Excel data

Prepare Excel lists for mailings

Extra tip: show your Excel list on Google Maps

Free Excel tools that clean your list

Prefer to skip the formulas? The free tools clean the whole sheet on your own computer. Your file is never uploaded.

→ See all free Excel tools