Link Microsoft Excel with Google Spreadsheets

[udoy120]

And why not do it directly in Excel?

We may find ourselves in the case of having an Adwords Script that automates a report of our accounts and exports it to a Google Drive Spreadsheet. So if we want to automate it in Excel we would not be able to, unless we link iceland phone number libraryit to the Spreadsheet.


Table of contents
Steps to follow
1. Publish our Google Spreadsheet
2. Link Excel
2.1 Link for Windows
2.2 Link with Mac OS
3. Update data
Steps to follow
1. Publish our Google Spreadsheet
The first thing we need to do is publish our spreadsheet on the web. This generates a URL that allows us to access the data in different formats. There are different data formats that we can access (csv, tsv, xlsx…).

To start, we will go to our Spreadsheet in Google Drive, in the top menu we access File – Publish on the web.