Import Excel - Import all ranges

Hi Nicolas and welcome to the Community!

Yes, it is possible. You will need to use a loop, or as we call it, iterations. It works as follows:

  1. Create a module (A) that imports one range which name is specified using a parameter.
  2. Create another module (B) that lists all ranges using the “Excel command” action.
  3. Use the “Iterate” action in module B to run module A as many times as there are ranges. In each iteration, pass a range name to module A by assigning its parameter.

This topic has a bit more complex scenario than just loading multiple ranges, but it has detailed explanations and examples: Multiple files, small variation in sheet name, import with parameter