Forum Discussion

Copper Contributor

Mar 18, 2024

Move columns with excel office script

I have a table with a number of columns, and I want to use the column names to reorganize them. Specifically moving the "Property Class" column to position 0 in the table, and the "Property Descripti...

excel

Office Scripts

ahhmoh

Copper Contributor

Jul 18, 2025

As of July 2025, moving columns' values only with office script can be done by:

Saving the target column values
Deleting the target column
Inserting it back into the table at the desired index

Here is a sample showing how it works:

function main(workbook: ExcelScript.Workbook) {
    const selectedSheet = workbook.getActiveWorksheet();

    const table = selectedSheet.getTable("yourTableName");

    moveColumn(table, "Property Class", 0);
    moveColumn(table, "Property Description", 1);
}

function moveColumn(table: ExcelScript.Table, colName: string, index: number): void {
    const column = table.getColumn(colName);

    if(!column) {
        return;
    }

    const values = column.getRange().getValues().map(row => row[0]);
    column.delete();
    table.addColumn(index, values);
}

SergeiBaklan

Diamond Contributor

Jul 19, 2025

The only, it moves values, not formulae.

As variant

function main(workbook: ExcelScript.Workbook) {
	const table = workbook.getTable("Table1")
	moveColumn( table, "Property Class", 0)
	moveColumn( table, "Property Description", 1)

}

const moveColumn = ( table: ExcelScript.Table, colName: string, index: number): void => {
	
	const column = table.getColumn(colName)
	if (!column || index >= table.getColumns().length ) { return }

	const n = index + +(index > table.getColumnByName("C").getIndex())

	table.addColumn(n)
	const source = table.getColumnByName(colName)
	source.getRange().moveTo(table.getColumns()[n].getRange())
	source.delete()

}