Excel and CSV guides
Why spreadsheets go wrong and how to put them right: step-by-step fixes in Excel, plus the free SheetTidy tool for each job when you would rather not do it by hand.
3guides
CSV Opens in One Column in Excel — Here's the Fix
Every value crammed into column A, separated by commas or semicolons? Here is why Excel does that, how to see which separator your file uses, and five ways to split it properly.
· 8 min read
Why Are My Excel Dates Showing as Numbers? How to Fix It
A date that shows as 45366 is not broken. Excel is showing the number it stores behind every date. Here is why it happens, how to turn it back into a date, and how to fix the opposite problem too.
· 9 min read
How to Remove Duplicates in Excel (4 Easy Ways)
Four reliable ways to find and remove duplicate rows in Excel, when to use each one, and what to check when Excel misses duplicates you can clearly see.
· 8 min read