Automating Italian salary breakdowns in Excel using online calculation data

Dear @Giuseppina rinaldi

Welcome to Microsoft Q&A Forum! 

Please understand that our forum is a public platform, and we will modify your question to cover data link in the description. Please remember to hide these personal or organization information next time you post error or some information to protect personal data. 

Thank you for your inquiry regarding automating payroll calculations in Excel for Italian employees using external data sources such as IRPEF and INPS rates.  It is technically feasible to link Excel to external data sources using Power Query, ODC files, or web connectors, allowing automatic updates of tax rates and contributions. Below are official Microsoft resources that explain how to do this, you can try to see if they can help you: 

1.You can learn how to manage data connections in Excel using Power Query and connection files. It helps to create, edit, and manage connections to External Data. Please see this link for more details: Create, edit, and manage connections to external data - Microsoft Support 

2.These links may help you to know how to connect to (import) external data with step-by-step instructions for importing and refreshing external data in Excel. Kindly see here: 

• Connect to (Import) external data - Microsoft Support 
• Import data from the web - Microsoft Support 
• Power Query Web connector - Power Query | Microsoft Learn 

3.You also may import data from data sources (Power Query), here is comprehensive guide on importing data from web, databases, and APIs using Power Query: Import data from data sources (Power Query) - Microsoft Support 

Besides that, I found this link that may be related to your case and it may help you to have a better practice for this feature, you can consult here: Integrating External APIs in Excel: Fetching Live Data with Power Query - ExcelDemy 

Note: Please note that our support is limited to providing guidance based on official Microsoft documentation. Any third-party resources or references shared are intended solely for informational or consultative purposes. Microsoft does not guarantee the accuracy, reliability, or continued availability of third-party content, and we recommend exercising discretion when referring to such materials. 

Besides that, to help you get started with designing your payroll and HR dashboards, here are some free and customizable Excel templates that I found, you can consult them and please understand that as a Microsoft Q&A moderator, my role is to guide discussions and connect users with helpful resources. While I don’t have the right to access to individual account or your environment in order to help you further. However, I still try my best to support you using the resources available. So, please take a look in here: 

• Payroll Templates | Microsoft Create 

For HR dashboard but it uses Power BI in Excel, you may consult for the structure: 

• HR Analytics Dashboard | HR Template - Microsoft Fabric Community 
• Human Resources sample: Take a tour - Power BI | Microsoft Learn 

I hope this information can help you. Wish you a pleasant day! 

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.