Robotic Process Automation (RPA) Software Resources

The best way to have configuration file is that to bring the data available in configuration into Dictionary. This way you can easily accessible to data present in configuration file and can make changes frequently in configuration File.

The proper way is really what is best for your needs. If your team is used to working with XML, then use that. If your users that may be manipulating the config file to achieve the results they need and are used to excel, that may be the way to go. However, if your users are comfortable with xml and how to edit a file and adjust/not-adjust etc... the data then go with that one.

I would suggest to use sql database table instead of XML or Excel, however if your team is comfortable with XML than XML always better than Excel. AA RPA XML command extract the configuration data without opening any UI and RPA excel command first open the excel file UI and read the data. I hope this will help.

While SQL is a great answer most of the time, the purpose of a config file is for people to be able to change the values easily. Most of the time, not that many people have access to SQL. If this is a good answer for you, then that is the best answer. You have to decide. The better way to go than Excel would be a .csv file. Your users can open is 'like' and Excel file so it can be familiar, but contrary to having to OPEN and xlsx, AA can read from a csv without opening it. It is MUCH faster to work with. I think what you are seeing here is that there is NOT a 'BEST' way to do anything, because what is best for my company may not work at all for your company. Good idea to see what others are doing, but be open to ideas and try them out and see what works for you. Good luck.