Skip to content


Excel Column Order

Pieter du Toit asked 5 years ago
HiI am planning to build a map that uses an Excel spreadsheet as the source from a watched folder and upload the data to a SQL table.� I will reference the Excel columns as Source Columns under Column Type in the mapping window.� My question is this – does the order of the columns in the spreadsheet matter since I am referencing them by name? In other words, if I have two spreadsheets that have the same column names and number of columns but the order of the columns between the two differ, will it still upload both or will it upload one and throw an error on the other one?
Mark Anderson Staff answered 5 years ago
In a Folder Data source the column header names need to be the same, but the order does not matter. We do recommend having the columns in the same order if possible.

If you would like to submit an answer or comment, please sign in to the eOne portal.