How to Convert Excel to CSV Without Losing Data
Everything you need to convert Excel to CSV properly: delimiters, UTF-8 encoding, dates, decimals and workbooks with several sheets.
5 min read
Blog
Guides, tips and tricks to work better with Excel, CSV and spreadsheets.
-
-
How to Convert CSV to Excel Without Losing Leading Zeros or Dates
Opening a CSV with a double click can damage your data. Learn how to convert CSV to Excel while keeping leading zeros, dates, accents…
5 min read -
XLS vs XLSX: Differences and When to Convert Your Files
What is the difference between XLS and XLSX, which one is smaller, which one is safer and when you should convert from one format…
5 min read -
How to Convert PDF to Excel and Extract Tables Correctly
A practical guide to moving tables from a PDF into Excel: types of PDF, choosing the right tool, checking the result and cleaning the…
5 min read -
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.
5 min read -
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…
5 min read -
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…
5 min read -
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…
5 min read -
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…
5 min read
