Four boring Excel jobs, done in seconds
Some spreadsheet tasks are not hard, just slow: copying each region into its own file, pasting twelve monthly reports into one, turning a table with months across the top into a list, or cleaning a date column where every row is written differently. This free toolkit does all four in your browser. Your files are never uploaded; they are read by your own computer and the result is downloaded straight back.
① Split one sheet into many
Use this when you need one file per person, region, branch or month. Choose a column and the tool makes one part for each different value. For example, a sales list with a Region column becomes East, West and North. Every part keeps the header row.
- One Excel file, one sheet per part is best when you want to keep everything together.
- Separate Excel or CSV files (ZIP) is best when each part goes to a different person.
- Every N rows cuts very long lists into chunks, for example to fit an upload limit of 1,000 rows.
② Merge many files into one
Add monthly or branch reports and get one combined table. Columns are matched by their header name, so it does not matter if the columns are in a different order in each file. If a column exists in only some files, the other rows are left blank and the tool tells you which columns those are. The optional Source file column shows where each row came from, which makes checking much easier.
③ Reshape: wide to long, long to wide
Many reports are “wide”: one row per product and one column per month. Charts, pivot tables and databases usually want them “long”: one row per product per month. Wide → long (also called unpivot) does that. Tick the columns that should stay, such as Product, and the rest are turned into rows.
Long → wide (pivot) goes the other way. Choose what each row should be, which column provides the new headers, and which column has the values. If two rows land in the same cell you choose what happens: keep the first, add them up, count them or list them.
④ Fix messy dates
Dates from different systems arrive as 03/04/2026, 4-Mar-26, 2026.3.4, 20260304, March 4, 2026 or the Chinese and Japanese year-month-day style, often in the same column. Excel treats many of them as text, so sorting and filtering break. The date fixer reads all these styles and writes them back in one format, or as real Excel dates.
The tricky one is 03/04/2026: is it 3 April or March 4? The tool looks at the whole column. If any row has a first number above 12 (like 25/04/2026), the column must be day/month. If any row has a second number above 12, it must be month/day. If it cannot tell, those cells are marked in orange and you choose the order yourself. Nothing is guessed silently.
Tips
- The first row of each sheet is used as the header row. Remove title rows above the header first.
- Numbers and real Excel dates stay numbers and dates in the Excel download. Long ID numbers with leading zeros in CSV files stay as text.
- Very large files (hundreds of thousands of rows) work, but can take a few seconds. Close other heavy tabs if the browser is slow.
How this tool was tested
Before it went live, I ran 59 automated checks on the publish version of this page, at phone width in a Chromium-based browser. Last full test run: 17 October 2026.
- The logic: 32 checks on reading files, splitting, merging, reshaping (wide to long and back) and fixing dates, using test spreadsheets with known answers.
- The page: the four tabs, the buttons, the language switch, and opening the downloaded files to check what is really inside.
- Problems found and fixed during testing: six. For example, in "long to wide" a column could land in the wrong place when one month had no value ("Mar" ended up after "Jun"). That is fixed and now has its own test.
What to keep in mind: the tests use small example spreadsheets, so very large files may be slow, and closing other heavy tabs helps. Dates like 03/04/2026 can mean March 4 or April 3 depending on the date order you choose, so check a few results by eye. Found a problem? Tell me on the Contact page.
FAQ
Are my files uploaded anywhere?
No. Everything happens inside your browser. Closing the tab removes the data.
Does it keep formulas and formatting?
It keeps the values that the formulas show, and keeps dates as dates. Colours, fonts and formulas are not copied, because the output is a clean data table.
What about Google Sheets?
Download your sheet as .xlsx or .csv (File → Download), use the tool, then import the result back.
Is there a row limit?
There is no fixed limit. Excel itself allows 1,048,576 rows per sheet, which is the practical limit for the Excel download.