Skip to content
AREM Labs

EN TR

Excel & CSV

Convert Excel and CSV spreadsheets, repair delimiters, and clean data.

Popular conversions

Formats in this category

All file formats → From the blog →

What you should know

CSV and Excel store tabular data in fundamentally different ways. CSV is raw plain text that relies on exact delimiters like commas, semicolons, or tabs and strict character encoding. When software uses mismatched regional defaults, entire rows collapse into single cells, and special characters render as corrupted symbols. Spreadsheet programs also tend to auto-convert numeric text, stripping essential leading zeros from barcodes, stock keeping units (SKUs), and international phone numbers. At the same time, platforms like Shopify, WooCommerce, and backend database APIs reject native workbook files, requiring properly formatted and delimited plain text instead.

These utilities handle conversions between workbook formats and plain text, standardize mismatched delimiters, combine multiple tables, and deduplicate rows while preserving text-formatted numbers. Every operation runs entirely inside your web browser using local system memory, so your datasets remain completely private on your device without file size paywalls or account requirements. The tools output clean UTF-8 text with optional byte order markers for spreadsheet compatibility. Because execution depends on your device CPU and available browser memory, files with tens of thousands of rows process reliably, though extremely large gigabyte-sized files may encounter browser memory limits.

Frequently asked questions

Why do special characters or accents appear corrupted when opening a CSV in a spreadsheet?

Spreadsheet software often defaults to legacy regional encodings unless a file contains a UTF-8 byte order mark, causing international characters to display as garbled symbols. Converting your file or adding proper headers ensures your application reads the UTF-8 text correctly.

Should I format my CSV with commas or semicolons?

Use commas if you are uploading the file to e-commerce platforms like Shopify, WooCommerce, or web APIs. Use semicolons if you intend to open the file directly in desktop spreadsheet programs configured for European regional number formats.

How large of a file can I process with these tools?

You can process datasets containing tens of thousands of rows because processing takes place directly in your browser. Processing speed and capacity depend on your computer hardware, meaning multi-gigabyte files might exceed browser tab memory limits.