Proposal for automated table naming (Excel)

We are requesting the development of an automated function to apply sequential, padded naming to tables created within Excel workbooks. 

Problem:

When using Power Query to append tables, the default naming convention (e.g., Table1, Table2) causes an incorrect append order for any table count over nine due to alphanumeric sorting. This leads to Power Query listing tables in the wrong sequence (e.g., Table1, Table10, Table2, Table3) rather than the intended order. 

Proposed Solutions:

1. Automated Padding Function: Implement a function that automatically names new tables using a padded numerical format (e.g., Table_001). This would eliminate the need for manual renaming and ensure tables are consistently sorted and appended correctly.
   
   
2. Account-Level Naming Convention: Introduce an account option that allows users to select a specified format for table names. This would provide flexibility and enable users to enforce a custom naming convention (e.g., Prefix_000) for all tables created under their account. 

Thank you,

George Newell
email address removed for privacy reasons