Guides, tips and tricks to work better with Excel, CSV and spreadsheets.
12 articles Clear filters
Why Excel sometimes saves CSV files with semicolons, why everything can end up in a single column, and how to control the separator and…
Export transactions, orders or invoices from any system and turn them into a clean Excel table: amounts, dates, text and duplicates sorted out.
What is kept and what is lost when you move a spreadsheet from Excel to Google Sheets and back, and how to do it…
If your CSV opens in a single column, with broken accented characters or missing leading zeros, here is how to import it properly and…
Everything you need to convert Excel to CSV properly: delimiters, UTF-8 encoding, dates, decimals and workbooks with several sheets.
Opening a CSV with a double click can damage your data. Learn how to convert CSV to Excel while keeping leading zeros, dates, accents…
What is the difference between XLS and XLSX, which one is smaller, which one is safer and when you should convert from one format…
A practical guide to moving tables from a PDF into Excel: types of PDF, choosing the right tool, checking the result and cleaning the…
Tips to convert Excel to PDF without cut-off columns, blank pages or tiny text: print area, orientation, scaling and repeated headers.
