Skip to main content
To homepage To homepage
Solved

Merging excel files located on a sharepoint folder to one table in TX

  • December 10, 2025
  • 2 replies
  • 110 views
H
Starter

Hi,

i've got a couple of spreadsheets in a sharepoint folder that is would like to merge into one table in TX.

I’m running TX V20.10.66.64

i've setup a connection to the folder using provider TimeXtender Excel Data Source (16.4.20.0) and can see the files when i choose None for the aggragation option.
When i select Files or Files & Sheets, no files are shown after running the sync or Transfer job.

All files have just on sheet called 'Blad1’, the same amount of columns with identical names across the files. No tables are defined.


What's misconfigured or going wrong?

kind regards,

Hans Zuijderwijk

Best answer by Thomas Lind

Hi ​@HansZZV 

I recently added a Excel guide

I can see that it isn’t very specific of how the merging feature works.

So if I have this file setup.

With merging set to none, I get this result.

With None, you can see that I have some files in lvl2, lvl3, lvl4, lvl5 and in the main Merge level.

I deliberately made it like this for it to be more complicated for the system to find it all.

If I set it to Files, it returns one table called Sheet1. Its content is what is in all files.

If I set it to Sheets, it returns to show each file as the fieldnames are different.

And finally if I set it to Files & Sheets. I get the same look as I did with the aggregation set to Files. 

Try the same and see if your results differ. 

2 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • Answer
  • December 12, 2025

Hi ​@HansZZV 

I recently added a Excel guide

I can see that it isn’t very specific of how the merging feature works.

So if I have this file setup.

With merging set to none, I get this result.

With None, you can see that I have some files in lvl2, lvl3, lvl4, lvl5 and in the main Merge level.

I deliberately made it like this for it to be more complicated for the system to find it all.

If I set it to Files, it returns one table called Sheet1. Its content is what is in all files.

If I set it to Sheets, it returns to show each file as the fieldnames are different.

And finally if I set it to Files & Sheets. I get the same look as I did with the aggregation set to Files. 

Try the same and see if your results differ. 

H
Starter
  • HansZZV
  • Author
  • Starter
  • December 15, 2025

Hi ​@Thomas Lind ,

 

i configured it like you described and it worked.

Thanks for you support!

 

kind regards

Hans

    Terms and ConditionsCookie settingsAccessibility statement