Spreadsheet & data tools
Prepare data for reports, imports and migrations: merge exports, remove duplicates, compare two versions, fix broken characters, split huge files and convert calendars, contacts, XML and JSON into tables. Every tool keeps cells exactly as written, so IDs, ZIP codes and phone numbers keep their leading zeros, and your files are processed on your own device.
Every tool runs in your browser. Files stay on your device; results can be saved straight into your free workstand.
Convert CSV and Excel
Move tables between CSV, TSV, Excel and fixed-width text.
Merge, split and reshape
Combine files and sheets, split big exports, reorder columns and flip tables.
Clean and check
Duplicates, differences, replacements, phone numbers, names and data quality.
Analyse, sample and protect
Pivot tables, random samples, masking personal data and test data.
Calendars and contacts
Calendar (.ics) and contact (.vcf) files to and from spreadsheets.
Data formats and code
XML and JSON to tables, and tables to SQL, HTML and Markdown.
Archives
Open and create ZIP files, and unpack TAR and TAR.GZ archives.
Step-by-step guides
Combining many CSV and Excel files into one table without copy and paste
Combine CSV and Excel files into one.
Dedupe CSVFinding and removing duplicate rows in CSV and Excel files
Find and remove duplicate rows.
Compare CSV FilesComparing two CSV or Excel files to see what was added, removed or changed
See what changed between two files.
ZIP ExtractorOpening and creating ZIP files in the browser
Open and create ZIP archives.
ICS to CSVExporting calendar events from an .ics file to CSV or Excel
Calendar events as a spreadsheet.
vCard to CSVConverting vCard (.vcf) contacts into a spreadsheet
Contacts from .vcf to a spreadsheet.
CSV to SQLGenerating CREATE TABLE and INSERT statements from a CSV
SQL INSERT scripts from a CSV.
JSON to ExcelConverting JSON and API responses into Excel sheets
JSON records as a spreadsheet.
Excel Formula ExplainerUnderstanding and translating Excel formulas, one function at a time
Understand and translate formulas.
Questions about spreadsheet & data tools
Are my files uploaded?
No. Your files are processed on your own device by your browser and are never uploaded to openWorkstand or anyone else. There is no file size limit other than your device’s memory; very large files work best on a computer.
Is it really free?
Yes. There is no sign-up, no watermark, no daily limit and no paid plan. To cover running costs, public pages like this one may show ads; the private workspace never does.
Do these tools change my numbers or dates?
No. Cells are read and written as text, exactly as they are in the file. Only when you save to Excel are plain numbers and ISO dates stored as real values, and that option can be switched off; codes with leading zeros always stay text.
Which spreadsheet formats are supported?
CSV with any separator, TSV and TXT, and Excel workbooks (.xlsx and .xlsm). Old binary .xls files must be saved as .xlsx first. Calendar (.ics), contact (.vcf), XML, JSON, ZIP and TAR files have their own converters.