SmartQueryTools

Rename Columns in Excel Files Online

Rename columns in Excel files instantly in your browser. No upload, no server — your data stays on your device.

How to rename Columns in Excel files

  1. Drop your file onto the upload area. Every column is listed with its current name on the left and an editable box on the right.
  2. Type a new name into the box for each column you want to change. Edited boxes are highlighted. Leave the others as they are.
  3. Click Apply Renames. The button stays disabled until at least one name differs from the original.
  4. Check the preview, then click Download to save the file with the new headers in the same format.

Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.

Worked example

A customer survey tool exports question text as column headers. The analyst wants short snake_case names before loading the results into a database.

Input (Excel)

Excel workbook, first sheet (Sheet1)

Respondent IDQ1: How satisfied are you?Q2: Would you recommend us?Submitted At
14true2026-06-02
22false2026-06-02
35true2026-06-03

Settings

  • Respondent ID → respondent_id
  • Q1: How satisfied are you? → satisfaction
  • Q2: Would you recommend us? → would_recommend
  • Submitted At → submitted_at

Result

respondent_idsatisfactionwould_recommendsubmitted_at
14true2026-06-02
22false2026-06-02
35true2026-06-03

Only the headers change. Every value, the row order and the column order stay exactly as they were, and each column keeps its type: the scores remain integers and the recommend answers remain booleans. Names without spaces or punctuation can be used in SQL without quoting.

Working with Excel files

The tool treats row 1 of the first sheet as the header. Merged title cells or a report banner above the real header will throw this off, because those cells become column names. Delete them in Excel first. Empty header cells are given generated names such as column3, which are easy to spot and rename here. Headers entered across several lines with Alt+Enter contain a line break, which you can remove here by typing a new name.

The downloaded workbook has one sheet, Sheet1, with the new names in row 1 and the data below. Renaming here does not touch formulas elsewhere in the original workbook, and the download contains values only. Excel itself accepts long headers with spaces and symbols, so the naming rules that matter are those of the tool you will load the data into next. The new names are written as plain text cells in row 1, without the original header formatting.

Frequently Asked Questions

Which row does the tool use as the Excel header?

Row 1 of the first sheet. Remove any title or banner rows above the header in Excel before renaming.

Will renaming headers break formulas in my workbook?

Your original workbook is not changed. The download holds values only, so there are no formulas in it to break.

What happens if I give two columns the same name?

Column names must be unique, so the engine adds a numeric suffix to the repeated name, for example total and total_1. Check the preview before downloading.

What if I clear a name box completely?

An empty box is ignored and that column keeps its original name. Leading and trailing spaces in a typed name are also removed.

Does renaming change any data?

No. Only the headers change. Values, types and the order of rows and columns stay the same.

Related Tools