Excel to CSV
Export the first or every XLSX worksheet to formula-protected UTF-8 CSV without executing formulas.
BUILT AROUND THE TASK
Move a spreadsheet export into the format your next system expects. Check duplicate records, align columns, and convert between CSV, Excel, and JSON while keeping field meanings intact.
USE WITH CONTEXT
Work on a sample first. Pay attention to leading zeros, date formats, decimal separators, blank cells, and quoted line breaks. Keep identifiers as text when converting them to numbers would change their meaning.
A PRACTICAL ROUTE THROUGH THE SHELF
Check the header row and a few representative records. Decide which fields identify duplicates before removing any records.
Map columns to the required names and order, then choose the delimiter or file format expected by the receiving system.
Compare record counts and spot-check dates, identifiers, and empty values. Test a small import before processing the complete dataset.
Export the first or every XLSX worksheet to formula-protected UTF-8 CSV without executing formulas.
Find duplicate CSV records by selected columns and preserve source row numbers.
Rename selected CSV columns with an explicit source-to-target mapping.
Convert bounded CSV between comma, semicolon, tab, and pipe delimiters safely.
Convert header-based CSV to a formatted JSON record array without uploading it.
Convert a bounded UTF-8 CSV table into a styled, filterable XLSX worksheet in the browser.
Spreadsheet software may interpret an identifier as a number. Treat account codes, postcodes, and similar fields as text, then check both the converted file and the import settings of the destination application.