How to find tables in a excel

Hi, I have multiple tables in a excel. I would like to find a table then get the values as I want to compare the values with another excel. From reading the forum, I understood there is a get table range activity. From the exampple below, I understand how it works. However for input, I have to put in tablename. Not sure what to do put in… Pls guide me


Above, is one of a table in the excel file. I tried putting tablename as “KHAZ IES Pricing” but it says table does not exist.

Thank you xoxo

@sangasangasanga Get Table Range activity only works with ‘Table’ inserted in excel, not just a group of excel cells formatted to look like a table. To be clear, try Insert -> Table to insert a sample table. You can then find the Table Name here :
image

1 Like