How to reorder excel columns without power query — browser-based
- Step 1Decide: one-off or repeatable? — If you will re-run this on refreshed data every month, Power Query's saved step is the better fit. For a single file you just need reordered now, continue here.
- Step 2Upload the file — Drop the
.xlsx,.xls,.ods, or.csv. The tool reads the first sheet and uses row 1 as headers, listing each column as a numbered, reorderable row — no editor, no preview pane to load. - Step 3Reorder with the arrows — Move each column up or down one slot at a time until the list matches the order you want. This replaces Power Query's drag-in-the-Query-Editor with explicit single-step controls.
- Step 4Apply the order — Click
Apply order. The sheet is rebuilt instantly in the browser — no model refresh — and the first 10 rows preview so you can confirm the layout. - Step 5Download — no query embedded — You get a plain file back: an
.xlsxfrom an Excel upload (singleSheet1, values only) or a.reordered.csvfrom a CSV. There is no Power Query connection or workbook query inside it. - Step 6Open anywhere — The result opens in Excel, Google Sheets, LibreOffice, or any importer with no add-in or refresh requirement. Because there is no embedded query, it is safe to share.
This tool vs. Power Query's Reorder Columns step
Pick the tool by whether the reorder needs to repeat on refresh. Both reorder columns; the workflow and output differ.
| Aspect | This browser tool | Power Query |
|---|---|---|
| Best for | One-off reorder of a single file | Repeatable reorder on refreshed data |
| Requires desktop Excel | No — any browser | Yes (limited/absent on Mac and web) |
| Refresh step | None — instant rebuild | Close & Load + model refresh |
| Output | Plain file, no embedded query, values only | Loads into the workbook with a live query |
| Formulas | Resolved to values | Preserved as the query reloads source |
| Multi-sheet | First sheet only | Each query targets a chosen source |
Where this tool runs
Because it is browser-side JavaScript (SheetJS), it works on platforms where Power Query is limited or unavailable.
| Platform | Power Query availability | This tool |
|---|---|---|
| Windows desktop Excel | Full | Works |
| Mac desktop Excel | Limited (no full editor historically) | Works |
| Excel for the web | Limited | Works |
| Chromebook / Chrome OS | Not available | Works |
| iPad / tablet browser | Not available | Works |
| Linux (no Excel) | Not available | Works |
Tier limits for this tool
Excel-family limits. Column Reorder is Pro-gated. All processing is browser-side.
| Tier | Max file size | Max rows | Files per run |
|---|---|---|---|
| Free | 5 MB | 10,000 | Tool is Pro-gated |
| Pro | 50 MB | 100,000 | 5 |
| Pro + Media | 200 MB | 500,000 | 20 |
| Developer | 500 MB | Unlimited | Unlimited |
Cookbook
One-off reorder workflows that would otherwise mean opening the Power Query editor. Output is a plain file with no embedded query.
Quick reorder on a Chromebook — no Excel at all
You only have a Chromebook, so Power Query is off the table. Open the tool in Chrome, drop the file, reorder, download.
Upload report.xlsx (in Chrome on Chrome OS) Reorder list: 1. region 2. month 3. revenue 4. units Apply order -> report.reordered.xlsx downloads Opens in Google Sheets with columns in the new order.
Skip the Close & Load refresh for a single file
In Power Query you would add a Reorder Columns step then wait for the refresh. Here the rebuild is instant and the output has no query attached.
Power Query path: Get Data > Transform > Reorder Columns > Close & Load (refresh) This tool: drop file > arrows > Apply order > download Result: same column order, no embedded query, no refresh.
Hand off a file without a query inside it
A Power-Query-loaded sheet carries a live connection that can break or prompt on someone else's machine. Reorder here to produce a clean, query-free file for sharing.
Before (Power Query output): contains a workbook query/connection After (this tool): plain values, no connection Safe to email or upload to a shared importer — no 'Enable Content' / refresh prompts for the recipient.
Reorder a CSV without touching Excel
Power Query needs Excel; a CSV can be reordered directly here and stays a CSV.
Upload data.csv Reorder to: id, name, email Apply order -> data.reordered.csv No .xlsx intermediate, no Excel, no query.
Move the first sheet to the front first
Power Query lets you pick any source sheet; this tool always uses the first. If your data is on a later tab, move it forward in Excel before uploading.
Workbook tabs: Summary | Data | Notes This tool would read 'Summary' (first sheet). In Excel: drag the 'Data' tab to first position, save, then upload -> 'Data' is reordered and downloaded as Sheet1.
Edge cases and what actually happens
No saved, refreshable step
By designThis is a manual one-shot reorder — there is no Power Query-style step that re-applies on the next data refresh. For a recurring monthly transform, use Power Query's Reorder Columns step; for a single file, this tool is faster.
Output is values-only, unlike a live query
Values onlyPower Query keeps formulas because it reloads from source on refresh. This tool flattens the sheet to values during the CSV round-trip, so formulas become their results. Good for a clean static export; not a substitute for a live query model.
Only the first sheet is processed
First sheet onlyPower Query can target any sheet as its source; this tool always reads the first. Move the sheet you want to the front in Excel before uploading, or the wrong tab will be reordered and the rest dropped.
No embedded query in the output
By designThe download is a plain file with no workbook query or connection — which is usually a feature (no refresh prompts for recipients). If you specifically wanted a refreshable query in the file, that is a Power Query job, not this tool.
Every column is kept
By designPower Query's Choose Columns can drop columns in the same step; this tool only reorders and keeps every column. Use csv-column-remover to drop columns before or after reordering.
Headers are not renamed
By designReorder moves columns but never renames them. Power Query's Rename Columns step is a separate action; here, rename with csv-header-rename if needed.
Cell formatting and types are not preserved
Values onlyNumber formats, types, and styling do not survive the CSV round-trip — only cell text. Power Query carries column types through its model; this tool returns plain values that the next app re-interprets on open.
Free tier cannot run this tool
Upgrade requiredColumn Reorder is Pro-gated; the free tier shows an upgrade prompt. Pro allows 50 MB / 100,000 rows, Pro + Media 200 MB / 500,000 rows, and Developer 500 MB with no row cap.
First row must be the header
Check inputRow 1 is read as the header to name the reorder list. A leading title or blank row makes the labels wrong and consumes a data row. Strip leading rows before uploading so row 1 is the genuine header.
Frequently asked questions
When should I use Power Query instead of this tool?
Use Power Query when the reorder must repeat automatically on refreshed data — for example a monthly report where new data flows in and the same transform should re-apply. The saved Reorder Columns step is built for that. For a one-off reorder of a single file, this browser tool is faster and needs no Excel.
Does the output contain a Power Query connection?
No. The download is a plain file with no workbook query or connection embedded. That means no 'Enable Content' or refresh prompts when someone else opens it — handy for sharing.
Can I delete unwanted columns like Power Query's Choose Columns?
Not in this tool — it only reorders, and every column is kept. Use csv-column-remover to drop columns, then reorder the rest here. Power Query's Choose Columns combines both in one step if you need that.
Will my formulas survive like they do in a Power Query model?
No. Power Query reloads from source so formulas effectively persist; this tool flattens the sheet to values, so formulas become their last-calculated results. The reordered file is a static data export, not a live model.
Does it work on a Mac, Chromebook, or iPad?
Yes — it runs in any modern browser, including platforms where Power Query is limited or unavailable (Mac Excel, Excel for the web, Chrome OS, iPad). No desktop Excel and no add-in are required.
What file types can I reorder?
.xlsx, .xls, .ods (first sheet only) and .csv. The output mirrors the input type, suffixed .reordered.
Can it reorder a specific worksheet other than the first?
No — it always reads the first sheet. Power Query lets you choose the source sheet; here, move the tab you want to the front in Excel before uploading, then the tool reorders it and drops the others.
Is the reorder really drag-and-drop?
The controls are up/down arrow buttons on a numbered list, giving precise one-slot moves. That is faster and less error-prone than dragging columns in the Power Query editor on a wide table.
Does my file get uploaded to a server?
No. Everything runs in your browser with SheetJS, so no add-in install and no upload. Only an anonymous processed-file counter is recorded for signed-in dashboard stats.
Is there a preview before download?
Yes — after Apply order the first 10 rows show in the new order, so you can confirm the layout without loading a full Power Query preview pane.
Can I rename columns like Power Query's Rename step?
No. Reorder only moves columns. Use csv-header-rename to rename headers, then reorder the result here.
Which tier do I need?
Pro or above — the free tier shows an upgrade prompt. Pro allows 50 MB / 100,000 rows, Pro + Media 200 MB / 500,000 rows, and Developer removes the row cap at a 500 MB file ceiling.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.