How to Implement a Hardware Asset Management System in ServiceNow?

I want to set up a system in ServiceNow to manage hardware assets like mobile phones. Here's what I need to accomplish:

1. Importing Hardware Assets:

   • I have an Excel sheet with details about the hardware (e.g., name, model, quantity, barcode, etc.).
   • How can I import this data into ServiceNow's asset management system (e.g., alm_asset table or a custom table)?

2. Creating a Customized Form:

   • I need a form to track inventory and add new hardware.
   • The form should allow me to input details like asset name, model, quantity, and barcode.
   • If I input a quantity (e.g., 10), it should create 10 individual asset records in the database. How can I achieve this?

3. Barcode Scanning Integration:

   • I want to add new assets using barcode scanning via the ServiceNow mobile app.
   • The system should:
     • Check if an asset with the scanned barcode already exists and update it if found.
     • Create a new record if no matching barcode exists.
       
       

4. Automating Inventory Updates Based on Asset State:

   • Each hardware asset will have a state (e.g., "Available," "In Use," "Damaged").
   • If the state changes (e.g., an asset is set to "In Use" or "Damaged"), the system should automatically deduct it from the inventory count.
   • How can I configure ServiceNow to do this automatically?
     Notes : I am quiet new to ServiceNow administration and Dev so please more details if possible would be very helpful