Comma or semicolon: the CSV separator and regional settings explained
Why Excel sometimes saves CSV files with semicolons, why everything can end up in a single column, and how to control the separator and decimals.
Guides to convert between XLS, XLSX, CSV, ODS and PDF without losing data.
Why Excel sometimes saves CSV files with semicolons, why everything can end up in a single column, and how to control the separator and decimals.
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 step by step without breaking formulas or formatting.
If your CSV opens in a single column, with broken accented characters or missing leading zeros, here is how to import it properly and fix it if you already opened it.
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 and long numbers.
What is the difference between XLS and XLSX, which one is smaller, which one is safer and when you should convert from one format to the other.
A practical guide to moving tables from a PDF into Excel: types of PDF, choosing the right tool, checking the result and cleaning the extracted data.
Tips to convert Excel to PDF without cut-off columns, blank pages or tiny text: print area, orientation, scaling and repeated headers.
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.