Skip to main content

HOW to bring MULTIPLE *.xlsx template into 1 standard *.xlsx Template ?

  • September 18, 2026
  • 2 replies
  • 31 views
vimva679
Enthusiast
Forum|alt.badge.img+11

Hello All 

I have Building Room information Excel data, due to multiple stakeholder, contractors , sub-contractors generating data, several Excel template were created and it rolled for several years like this. 

Now the challenge is to take into consideration ALL excel files and output them in 1 standard template. The challenge is 

  1. Several TABS in 1 excel sheet (I am interested only for certain TABS)
  2. Spell Errors in TAB Names (Although TABS name may be same but between 2 excel there are spell mistake for the same TAB like with s or _ letter missing etc.)
  3. Different Headers title among each TABS and EXCEL FILE
  4. Headers start at different rows 
  5. Headers have spell error
  6. Striked rows / cells

 

2 replies

vimva679
Enthusiast
Forum|alt.badge.img+11
  • vimva679Enthusiast
  • Author
  • Enthusiast
  • September 18, 2026

I am trying to solve problem using FME 2026.1 

debbiatsafe
Safer
Forum|alt.badge.img+24
  • debbiatsafeSafer
  • Safer
  • September 24, 2026

Hello ​@vimva679,

Tabs are represented as feature types within FME. When you read the template Excel files, you should be able to use the Tester or TestFilter to filter only the ones you want to keep and then use an AttributeManager to change any typos. 

The schema (header title) being different can be managed by not reading any field names. You can do this by going into the Excel reader’s Parameters and then setting the Field Names Row as 0. This changes the attribute names to generic columns (A-Z, etc.). When writing the data back to Excel, change the following Excel writer feature type parameters: Use Attribute Names As Column Positions to ‘Yes’, and Output Field Names to ‘No’.

The headers having spelling errors will have to be edited using AttributeManagers or StringReplacers.

Here’s our tutorial series on Getting Started with Excel in case you find it helpful https://support.safe.com/hc/en-us/articles/25407401015949-Tutorial-Getting-Started-with-Excel

Community Stats

32,945
Posts
124,890
Replies
41,813
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.