What do ye want t' do with yer Excel scroll, cap'n?

Organize & Structure

Reshape an' format yer data

Flip a sheet on its head

Flip rows into columns or columns into rows

1Upload yer scroll
2Select th' sheet t' transpose
3Plunder th' flipped scroll

Cleave a column in two

Turn one column into multiple usin' a delimiter

1Upload yer scroll
2Choose delimiter (comma, space, custom)
3Plunder processed scroll

Whip rows into line

Reorder data by one or more columns

1Upload yer scroll
2Pick columns an' sort direction
3Plunder sorted scroll

Auto-fit column widths

Resize every column t' match its content

1Upload yer scroll
2Columns arr auto-sized across all sheets
3Plunder th' formatted scroll

Nail down th' header row

Keep headers visible while scrollin'

1Upload yer scroll
2Set how many rows t' freeze
3Plunder th' updated scroll

Tame unruly dates

Normalize date formats across columns

1Upload yer scroll
2Choose th' target date format
3Plunder th' formatted scroll

On th' horizon

Swab & Fix

Find an' fix data troubles

Keel-haul duplicate rows

Delete repeated rows based on columns ye pick

1Upload yer scroll
2Select columns that define a duplicate
3Plunder th' swabbed scroll

Swab extra spaces

Strip leadin', trailin', an' repeated whitespace

1Upload yer scroll
2Choose sheets an' strictness level
3Plunder th' trimmed scroll

Whip text case into shape

Convert text t' UPPER, lower, or Title Case

1Upload yer scroll
2Pick target case an' columns
3Plunder th' normalized scroll

Hunt an' swap text

Bulk-edit values across all sheets with text or regex

1Upload yer scroll
2Enter find/replace terms
3Plunder th' updated scroll

Banish empty rows

Delete rows where every cell be blank

1Upload yer scroll
2Select sheets t' swab
3Plunder th' swabbed scroll

Spot blank cells

Find every missin' value an' get a detailed report

1Upload yer scroll
2All sheets arr scanned automatically
3Plunder th' blanks report

Scan fer formula errors

Find #REF!, #VALUE!, #DIV/0! an' other scallywag errors

1Upload yer scroll
2Every cell be scanned fer errors
3Plunder th' error report

Inspect pigeon addresses

Check pigeon address formats an' get a color-coded report

1Upload yer scroll
2Select th' pigeon address column
3Plunder th' validation report

Merge & Combine

Join scrolls an' datasets

Smash sheets into one

Combine multiple tabs into a single sheet

1Upload yer workbook
2Select an' order th' sheets t' merge
3Plunder th' merged scroll

Stack multiple workbooks

Stack rows from separate scrolls into one sheet

1Upload two or more scrolls
2Arrange scroll order
3Plunder th' combined scroll

Split & Extract

Break scrolls into smaller pieces

Chop a sheet by rows

Break one sheet into smaller chunks

1Upload yer scroll
2Set rows per chunk an' namin' style
3Plunder th' split workbook

Carve workbook into scrolls

Extract each sheet as its own XLSX in a ZIP

1Upload yer workbook
2Select sheets t' include
3Plunder th' ZIP archive

Analyze & Inspect

Understand yer data before actin' on it

Inspect a workbook in th' sandbox

Preview sheets, columns, types, an' quality stats

1Upload yer scroll
2Browse sheets with filters an' sortin'
3Spot troubles before processin'

Fresh off th' press

Tally th' treasure

Count, mean, median, sum fer every numeric column

1Upload yer scroll
2All numeric columns arr analyzed
3Plunder th' stats report

Duel two workbooks

Cell-by-cell diff between two versions o' a scroll

1Upload original an' modified scrolls
2Differences arr detected automatically
3Plunder th' comparison report

Security

Protect or unlock yer scrolls

Lock th' treasure chest

Lock sheets t' prevent accidental edits

1Upload yer scroll
2Set a passphrase an' protection options
3Plunder th' protected scroll

Pick th' lock off sheets

Unlock editin' without th' original passphrase

1Upload th' protected scroll
2Protection be removed from all sheets
3Plunder th' unlocked scroll

Convert

Change scroll formats

Fire XLSX into CSV

Export one or more sheets as CSV scrolls

1Upload yer Excel scroll
2Select sheets t' export
3Plunder CSV or ZIP o' CSVs

Forge CSV into XLSX

Turn a CSV into a proper Excel workbook

1Upload yer CSV scroll
2Set delimiter an' sheet name
3Plunder th' XLSX workbook

Fire XLSX into JSON

Export sheet data as structured JSON

1Upload yer Excel scroll
2Select sheets t' export
3Plunder th' JSON scroll

Forge JSON into XLSX

Create an Excel workbook from JSON data

1Upload yer JSON scroll
2Structure be auto-detected
3Plunder th' XLSX workbook

Fire XLSX into PDF

Export sheets as printable PDF scrolls

1Upload yer Excel scroll
2Choose sheets an' page orientation
3Plunder th' PDF

Salvage PDF into XLSX

Extract tables from PDF into Excel

1Upload yer PDF scroll
2Tables arr detected automatically
3Plunder th' XLSX workbook

On th' horizon

Fire XLSX into SQL

Generate CREATE an' INSERT statements

1Upload yer Excel scroll
2Select sheets an' set table prefix
3Plunder th' SQL scroll

Salvage SQL into XLSX

Parse INSERT statements into a spreadsheet

1Upload yer SQL scroll
2Tables arr extracted automatically
3Plunder th' XLSX workbook

Fire XLSX into XML

Transform sheet rows into XML elements

1Upload yer Excel scroll
2Set root an' row tag names
3Plunder th' XML scroll

Salvage XML into XLSX

Map XML nodes t' rows an' columns

1Upload yer XML scroll
2Structure be auto-detected
3Plunder th' XLSX workbook