Data Import and Export to Google Sheets

Data Pump is an SSMS add-in that helps populate SQL databases with external source data and allows migrating data between systems.

Now you can use Data Pump to exchange data between your SQL databases and Google Sheets, the world's most popular free collaborative spreadsheet application.

  • Select the required sheet from documents with multiple sheets
  • Speed up your operations with automated mapping and auto-defined data types
  • Configure header settings and data range effortlessly
  • Use import and export templates for recurring scenarios

Exporting data to Google Sheets using Data Export Wizard

Invoking the wizard

Your first step is to invoke the Data Export Wizard from the required database in the SSMS Object Explorer.

Data export to Google Sheets - Invoking the wizard

Export format

The wizard opens on the Export format tab, where you can find and select the Google Sheets format.

Data export to Google Sheets - Export format

Source

On the Source tab, select the server connection, database, its schema, as well as the required table or view.

Data export to Google Sheets - Source

Output settings

On the Output settings tab, specify the required Google Spreadsheet ID/URL.

After you insert the required URL and click Next, Data Pump opens the browser for you to select the required Google account and allow dbForge to access your Google spreadsheets.

If you do so, you will receive an email confirming that dbForge was granted access to your linked Google account.

Data export to Google Sheets - Output settings

Options

Specify the start cell and the required sheet. Optionally, select the check box to show the table header.

Data export to Google Sheets - Options

Data formats

Select columns for export and check their aliases and data types. Additionally, you can go to the Formats tab, where you can modify the default data format settings.

Data export to Google Sheets - Data formats

Exported rows

Select to export all rows, export the rows selected on the Data formats tab, or export a specified range of rows.

Data export to Google Sheets - Exported rows

Errors handling

Specify the error processing behavior and, optionally, select the check box to write reports to a log file with a specified path.

Data export to Google Sheets - Errors handling

Save export templates

Once you have configured your export settings, you can click Save Template to save them for later use.

Data export to Google Sheets - Save export templates

Export results

When the export is completed, you can view the exported file or folder, perform another export operation, check the log file, or simply exit the wizard.

Data export to Google Sheets - Export results
Importing data from Google Sheets using Data Import Wizard
Data import from Google Sheets - Invoking the wizard

Invoking the wizard

Similarly, your first step is to invoke the Data Import Wizard from the required database in the SSMS Object Explorer.

Data import from Google Sheets - Source file

Source file

Select the Google Sheets format and specify the required Google Spreadsheet ID/URL.

After you insert the required URL and click Next, Data Pump opens the browser for you to select the required Google account and allow dbForge to access your Google spreadsheets.

If you do so, you will receive an email confirming that dbForge was granted access to your linked Google account.

Data import from Google Sheets - Destination

Destination

Select the required server connection, database, and its schema. Indicate whether the data should be imported into a new or existing table.

Data import from Google Sheets - Options

Options

Configure the formatting options for imported data: specify the sheet and the data range to be imported, and configure header settings. You can see the results of your configuration in the Preview section.

Data import from Google Sheets - Data formats

Data formats

Here you can specify the formats for null strings, thousand and decimal separators, boolean variables, date and time. You can also configure the format settings for separate columns.

Data import from Google Sheets - Mapping

Mapping

Configure the mapping of the source columns to the target ones. If you are importing data into a new table, Data Pump will automatically create and map all the columns. You can click Edit to specify the column names and the corresponding data types. In the Preview section, you can see the results of your configuration.

Data import from Google Sheets - Modes

Modes

Select one of the available import modes:

  • Append
  • Update
  • Append/Update
  • Delete
  • Repopulate

Note that their availability may vary according to your settings.

Data import from Google Sheets - Output

Output

Select one of the available options:

  • Open the data import script in the internal editor
  • Save the data import script to a file
  • Import data directly to the database
Data import from Google Sheets - Errors handling

Errors handling

Specify the error processing behavior and, optionally, select the check box to write reports to a log file with a specified path.

Data import from Google Sheets - Save import templates

Save import templates

Once you have configured your import settings, you can click Save Template to save them for later use.

Data import from Google Sheets - Import results

Import results

When the import is completed, you can view the results, check the log file, or simply exit the wizard.

dbForge SQL Tools

15 essential SQL Server development tools in one bundle

Download

We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.