Reshape and format your data
Flip rows into columns or columns into rows
Turn one column into multiple using a delimiter
Reorder data by one or more columns
Resize every column to match its content
Keep headers visible while scrolling
Normalize date formats across columns
Find and fix data issues
Delete repeated rows based on columns you pick
Strip leading, trailing, and repeated whitespace
Convert text to UPPER, lower, or Title Case
Bulk-edit values across all sheets with text or regex
Delete rows where every cell is blank
Find every missing value and get a detailed report
Find #REF!, #VALUE!, #DIV/0! and other errors
Check email formats and get a color-coded report
Join files and datasets
Combine multiple tabs into a single sheet
Stack rows from separate files into one sheet
Break files into smaller pieces
Break one sheet into smaller chunks
Extract each sheet as its own XLSX in a ZIP
Understand your data before acting on it
Preview sheets, columns, types, and quality stats
Count, mean, median, sum for every numeric column
Cell-by-cell diff between two versions of a file
Protect or unlock your files
Lock sheets to prevent accidental edits
Unlock editing without the original password
Change file formats
Export one or more sheets as CSV files
Turn a CSV into a proper Excel workbook
Export sheet data as structured JSON
Create an Excel workbook from JSON data
Export sheets as printable PDF documents
Extract tables from PDF into Excel
Generate CREATE and INSERT statements
Parse INSERT statements into a spreadsheet
Transform sheet rows into XML elements
Map XML nodes to rows and columns