Excel to PDF: How to Get Sheets That Print and Look Great
Tips to convert Excel to PDF without cut-off columns, blank pages or tiny text: print area, orientation, scaling and repeated headers.
ODS vs XLSX: Compatibility Between LibreOffice and Excel
Differences between LibreOffice’s ODS format and Excel’s XLSX, what can be lost when moving from one to the other and how to share files without trouble.
UTF-8 Encoding in CSV Files: No More Broken Accents
Why strange characters like é or ’ show up in your CSV files, what UTF-8 and the BOM are, and how to avoid encoding problems for good.
Spreadsheet File Formats Explained: XLS, XLSX, XLSM, CSV, ODS and More
A quick guide to the most common spreadsheet formats, what each one is for, their limits and which one to choose for what you need to do.
How to Remove Duplicates in Excel: 4 Methods Explained
Learn to find and remove duplicates in Excel with the built-in feature, conditional formatting, formulas and online tools, and how to decide which record to keep.
How to Delete Blank Rows in Excel Quickly and Safely
Ways to delete blank rows in Excel without losing data: Go To Special, filters, sorting, formulas and online tools for large files.
Data Cleaning in Excel: A 10-Step Checklist
A practical checklist to clean any spreadsheet before analyzing, importing or sharing it: from duplicates to dates.
How to Merge Multiple Excel Files into One
A guide to joining several Excel workbooks or sheets into a single file: copy and paste, Power Query, online tools and how to prepare the data before merging.
Normalizing Data in Excel: Spaces, Case, Dates and Phone Numbers
Techniques and formulas to normalize data in Excel: trim spaces, standardize case, convert text dates, standardize phone numbers and codes.
How to Prepare a Customer List in Excel for CRM Import
Steps to clean, standardize and export your customer list from Excel before importing it into a CRM or email marketing tool without errors.