Phone: 1-415-230-0560 Contact Us

Load Data from the Web

The SaveToDB add-in allows connecting to web pages and web services. SaveToDB converts HTML, XML, JSON, XML, plain text and CSV data into Excel tables.

So you may load financial reports, stock and option quotes, fundamental data, social contacts, etc. in Excel.

Use Data Connection Wizard for the first connection.
Then change query parameters using the ribbon.
SaveToDB preserves formulas and formatting.

Load Data from Web

Connect to Tables and Views

SaveToDB allows connecting to database tables & views.

You may select SELECT & WHERE fields and change filter values using the ribbon or named cells.

Use Data Connection Wizard for the first connection.
Then you may select the query object using Query List.

You may have fewer worksheets and refresh query lists to get new tables and views from a database.

Connect to Database Tables and Views

Connect to Stored Procedures

SaveToDB allows connecting to stored procedures.

SaveToDB places stored procedure parameters on the ribbon, and you may change parameter values.

Developers may specify value lists for parameters.
The value lists may contain ID and value pairs.

You may use Query List to change the active procedure.

Connect to Stored Procedures

Create Different Table Views

You may save multiple views of underlying tables.

Apply auto filters, sort data, hide columns, add subtotals, and save the view with a clear name.

Then activate the view when you need from the view list.

This feature works for all Excel tables.

Create Different Table Views

Distribute Formatted Data

Developers may install SaveToDB Framework in a db.

And you may save Excel formats for database objects in a database, including saved table views.

Your colleagues will load the formatted data.

Use Table Format Wizard to manage formats.

Distribute Excel Table Formats from Databases

Save Changes using Save Button

SaveToDB allows saving data changes to database tables.

Yes, you may use Excel as a database table editor.
Use Search & Replace or formulas, and save the data.

Developers may configure saving changes for data loaded from views and stored procedures.

Developers may specify SQL codes or stored procedures for INSERT, UPDATE and DELETE operations.

Connect to Database Tables and Views

Save Changes on Change Event

Another way to save changes is using SQL codes or stored procedures as cell Change event handlers.

So the database is updated immediately after the change.

To add handlers, install SaveToDB Framework and add configuration records to the EventHandlers table.

Handlers may use values from table columns.

    INSERT dbo.Companies (CompanyName)
        VALUES (@CompanyName)
    UPDATE dbo.Companies
        CompanyName = @CompanyName
        ID = @ID

Publish Data to Databases

SaveToDB allows designing database tables and inserting data from Excel using the Data Publish Wizard.

After publishing your team may edit database table data from multiple workbooks connected to the table.

This is the easiest way to share data with your colleagues without sharing workbooks.

Create Database Tables and Publish Data from Excel

Translate DB Names in Excel

Developers may install SaveToDB Framework in a db.

The ColumnTranslation table may be used to translate column and parameter names to a business language.

The ObjectTranslation table is used to translate database object and event handler names.

SaveToDB performs translating in Excel.

Translate Database Object Names in Excel to Business Language

Run Queries from Actions Menu

Developers may define stored procedures for the SaveToDB Actions menu for every database object.

SaveToDB shows items related to the active Excel table.
The add-in requests parameter values before calls.

Use the object translation feature to show user-friendly names in the menu.

Run Queries from SaveToDB Actions Menu

Run Queries from Context Menu

Developers may add queries to the Excel context menu.

The queries may use values from the active row.

SaveToDB allows using tables, views, stored procedures, HTTP requests, macros, batch files, and CMD commands.

Outputs: a worksheet, popup window, or a browser.

-- SQL context query
SELECT * FROM dbo.Payments
    WHERE CompanyName = @CompanyName
-- HTTP context query
Search {CompanyName} in Google{CompanyName}

Define Excel Formulas in Views

SaveToDB allows defining Excel formulas in database views and stored procedures.

For example, line totals can be calculated in Excel.

You may use different formulas for every row like DDE.

Formula results can be saved back to a database.

    , Name
    , Price
    , Qty
    , '=[@Price]*[@Qty]' AS Total

Use SaveToDB from VBA Macros

The SaveToDB add-in has a lot of features.

And you may use it from VBA as a database or web layer.

Just connect a workbook to the web or a database, implement server-side logic and call add-in methods.

Dim addIn As COMAddIn
Dim addInObj As Object
Set addIn = Application.COMAddIns("SaveToDB")
Set addInObj = addIn.Object
Range("Account").Value = 123
Range("Company").Value = "ABC"

Call VBA Macros from SaveToDB

SaveToDB allows executing VBA macros from the Actions menu and from the Excel context menu.

Macros are shown for related objects only and can use context values.

VBA macros can be placed in separate workbooks.
So you may update the macro workbooks only.

Call VBA Macros from SaveToDB

SaveToDB Framework

SaveToDB Framework contains tables, views, and stored procedures to support advanced SaveToDB features.

You may install it in your database using the Framework Installer wizard and edit configuration tables using Excel.
Use Configuration Workbook Generator for this.

SaveToDB Framework Allows Customizing Excel Applications

Use Excel as Client Platform

Microsoft Excel is the best app for working with tables.
Users know and like it.

The SaveToDB add-in allows implementing most client applications with Excel using Excel & SQL only.

You may create amazing applications, step-by-step,
using database development skills only.

Use Excel as Client Platform

SaveToDB Editions

Personal Enterprise
Loading data from database tables, views, and stored procedures Yes Yes
Loading data from web pages, web services, and text files (HTML, CSV, XML, JSON, plain text) Yes Yes
Automatic loading multiples web pages (HTML, XML, JSON) Yes Yes
Saving data from any data source to a database except using custom stored procedures Yes Yes
Saving data from any data source to a database using custom stored procedures Yes Yes
Saving data from any data source to a text file (CSV, HTML) Yes Yes
Saving data to OData web services No Yes
All user interface features Yes Yes
All application development features Yes Yes
SQL Server, SQL Azure, SQL CE, Oracle Database, IBM DB2, MySQL, MariaDB, NuoDB Yes Yes
Commercial use No Yes
Price per copy, one time $49.95 $149.95

How to Start

  1. Download and unzip the SaveToDB Suite package to a local drive folder.
  2. Close Microsoft Excel.
  3. Run setup.exe and complete installation steps.
  4. Open Microsoft Excel. You should see the SaveToDB tabs.
  5. Try examples from the SaveToDB Suite package.

You may be asked to download and install required components from the Microsoft website. Please confirm this without worry.

Subscribe to Updates, Tips, and Tricks

You will receive the confirmation letter. Please check your inbox and confirm the subscription.

We never share any user email address with third party companies, and we do not spam.
If you do not want to receive our emails, you may unsubscribe anytime.

Get SaveToDB Tips & Tricks

Thank you for download!
You may subscribe now for tips & tricks.

You will receive several useful emails to learn SaveToDB step by step.