Excel to Database Uploader

Warning: Database credentials are stored in browser localStorage with hashed passwords for improved security. Use in a trusted environment and avoid storing sensitive credentials in production.

How to Use This Tool

  1. Enter database credentials (host, username, database name) and save.
  2. Edit or delete saved credentials using the buttons below the dropdown.
  3. Select saved credentials and a table (password required).
  4. Upload an Excel file (.xlsx/.xls) and select a sheet to preview data.
  5. Choose an operation (e.g., INSERT, UPDATE, TRUNCATE) and click "Process Data" (password required).
  6. Check database results or errors in the red box below.

For developers: Use "Show Query Only" to debug SQL. Check browser console or Scriptcase logs for errors.

Step 1: Manage Database Credentials

Step 2: Upload Excel File

Step 3: Preview Data