Export and Import Easy Digital Downloads with Google Sheets

In this tutorial, we will show you how to export and import Easy Digital Downloads with Google Sheets. You’ll be able to export your EDD products to Google Sheets, and import EDD products from Google Sheets into WordPress.

For this, we will use the WP Sheet Editor – Easy Digital Downloads plugin. It allows you to view and manage your EDD products using an intuitive spreadsheet on WordPress. This plugin accepts advanced search, bulk edit, export and import using CSV files.

Besides, we will use the Google Sheets Sync service. It allows you to connect your WordPress site to your Google Sheets account to export and import content easily.

Some of the great advantages of using this method to export/import EDD products with Google Sheets:

• No browser extensions needed
• You can use any browser
• No scripts needed
• No programming knowledge needed
• All is done from the WordPress admin dashboard

You need to follow the steps in the sections below.

Connect WordPress and Easy Digital Downloads to Google Sheets

When you sign up for the Google Sheets Sync service, you will receive a helper plugin that will allow you to connect your WordPress site with your Google Sheets account, the Google API, and the WP Sheet Editor API.

We have prepared a tutorial to show you how to set up the helper plugin. You can read it by clicking here.

Besides, here’s a guide on how to set up the Easy Digital Downloads spreadsheet.

After setting everything up, you will see your EDD products in a spreadsheet.

Now you can proceed to export and import EDD data with Google Sheets.

How to export Easy Digital Downloads to Google Sheets

First, let’s see how to export Easy Digital Downloads data from WordPress to Google Sheets.

Exporting EDD downloads from WordPress to Google Sheets directly is a convenient way to create a backup of your Easy Digital Downloads or Easy Digital Downloads product data. It can also be useful if you want to ask someone in your team to apply price changes or any other data from Google Sheets, without having to give them access to the WordPress site.

You need to start by opening the Export tool.

Now you need to select these values to export your products’ data to Google Sheets:

1. Select the columns you want to export. You can select specific columns by typing the name, select all the active columns (all the columns that are visible in the spreadsheet), or all the columns (including both visible and hidden columns).
2. Select the rows you want to export. You can export all your EDD downloads, all the EDD downloads from a specific search, or all the downloads you have manually selected.
3. Select the Google Sheets app.
4. Add a name for this export, and the Google Sheet will inherit that name.
5. Click on Start new export.

Optional – Update an existing Google Sheet

If you have previously exported your EDD downloads to Google Sheets, you can select a previously exported Google Sheet to add the data to instead of creating a new Google Sheet.

You just have to tick the Advanced Google Sheets options and choose the Google Sheet in Select an existing Google Sheet below.

After the export is completed, you will see the View Google Sheet link to open the Google Sheet that has been created on your Google account. You can click on that link to view your Easy Digital Downloads on Google Sheets.

Create and edit Easy Digital Downloads in Google Sheets

After exporting your content to Google Sheets, you will see a spreadsheet like the one shown below:

You can start creating new downloads or editing existing downloads using Google Sheets.

Important:

If you want to import Easy Digital Downloads data from Google Sheets to WordPress, you need to export even one row first, because our Google Sheets Sync service only recognizes files that have been exported first with our service. This is important because we protect your privacy by not having access to other files in your Google account. Not even to other Google Sheets files.

Import Easy Digital Downloads from Google Sheets

To import EDD products from Google Sheets into WordPress, you need to first prepare the Google Sheet you will import. Remember that the file must first be exported to Google Sheets, and then you can add new information and/or edit existing information.

Once you have your Google Sheet ready, you need to start by opening the Import tool.

Now you need to select the Google Sheet you want to import into WordPress:

1. Select the Google Sheets option as the Source from which you want to get the data.
2. Select the Google Sheets file you want to import. If you don’t find it, you can click on the refresh button.
3. Click on Next.

You can Import all the columns or Select individual columns to import. If you don’t want to import a given column, select Ignore this column.

You need to select how you want to import your Easy Digital Downloads data.

In this example, we will Create new items and update existing items.

Since we will update existing items, we need to match the rows in the Google Sheet with the rows in WordPress. For this, we will use the ID column.

Finally, you’ll see a preview. If everything is OK, you need to click on The preview is fine, start import to start importing your Easy Digital Downloads data.

As you see, the WP Sheet Editor – Easy Digital Downloads plugin and the Google Sheets Sync service allow you to export and import Easy Digital Downloads data between your WordPress site and your Google Sheets account with a few clicks.