Excel On The Web

In this article, I shall show you how to pull or extract data from a website into Excel automatically. This is one of the most used Excel features for those who use Excel for their data analysis job. If you are working for a financial analyst company, you might need to get or import daily stock prices from a website to your Excel workbook for analysis.

So, let’s learn the technique…

In.net 5 core web application wtih EF Core; my aim is to create a excel file from controller based on List and its achieved by using interop the next step is to download the same excel file so, below is my code. Here is my doubt, I have assigned the file path into a ViewBag then I dont know how dowload the file(FYI this file path is not in. Excel for the web gives you the power of Excel on any device, from almost anywhere. Here are some of the great features to try out: Sign in to Office.com for the best place to get started. Select Excel to see recent files and templates, or create a new blank workbook. The new Simplified Ribbon makes it easy to find and apply common Excel commands. Work just like you always have by adding data, creating. Excel keyboard shortcuts by default. Excel for the web now supports your keyboard shortcuts by default. Keyboard shortcuts like Alt, Ctrl-1, Ctrl-Shift-A, etc., go to Excel and not your browser. To see the list of Excel keyboard shortcuts, click on the Help tab and select Keyboard Shortcuts – Override browser shortcuts is checked by default.

Extracting data (data collection and update) automatically from a web page to your Excel worksheet might be important for some jobs. Excel gives you the opportunity to collect data from a web page.

Yes, Excel is awesome like that!!

Let’s dive into the process of helping you out.

But first, a word of caution: the web page must have data in collectible formats like Table or Pre-data format. Otherwise, it would be another battle to convert it to a readable or excel-able format. You see text to columns feature isn’t always your best friend.

So, we shall assume your life is easy like that and you have a website that has data in a compatible excel-able format.

Table of Contents

Extract Data from Google Finance Page to Excel Automatically

We will be using Excel’s From Web Command in the Data ribbon to collect data from the web. Say, I want to collect data from this page.

It is Google’s finance-related web page.

In the Excel worksheet, open the Data ribbon and click on the From Web command.

New Web Query dialog box appears.

In the address bar, I paste the address of Google’s finance web page: https://www.google.com/finance. Then I click on the Go button, placed right after the address bar.

The same web page comes in the query dialog box. Now spot the yellow arrows near the query box.

Move your mouse pointer over the yellow arrows. You see a zone is highlighted with a blue border and the yellow arrow becomes green.

[Click on the image to get a full view]

I have chosen World Markets data, Currency Data, and Sector Summary.

Now I click on the Import button. Import Data dialog box appears. It asks me about the location. Currently, I am planning to save it in cell A1, you can save it anywhere and everywhere.

Microsoft Excel For The Web

You might see a cryptic message or two when you hit OK. Relax those aren’t aliens trying to contact you, just your worksheet is populating data.

You see the data is inserted into the worksheet.

Now let me show you where Excel did the flip. I scroll down and find this column blank.

When I checked the website I found that there was a chart there which Excel was not able to pull. So, you have to be careful about what you are taking from a web page.

Now, you have got the data and can begin working and manipulating it.

The most important/interesting thing to note here is: you don’t have to pull the updated data from time to time.

How to Refresh Excel Data for Any Update

You can manually or automatically refresh the data. How? Say Abracadabra! No, am just kidding. (But it’s almost like magic).

Click on the drop-down part of the Refresh All command.

You can click on Refresh if you think you have only one data and you can click on Refresh All if you think you have more than one data to be refreshed.

You can even set a time period for refreshing data automatically. Click on this Connection Properties option from the list.

Connection Properties dialog box appears.

You can name the connection. Add a description to it.

Under Refresh Control, you get a command Refresh Every (by default 60 minutes), you can change it.

Or you can choose the option Refresh Data when opening the file. I click OK. So, the data of this worksheet will be updated when I will open the worksheet.

Read More:

So, this is how you can pull data from a web page, manipulate the data in your own way, and then you can set when the data will be updated automatically.

Cool, right? Now time for a coffee!!

Hello!
Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share here. Not only how to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned!

Turn Excel Spreadsheets into Applications

Use our new AI interface to create web application in a few clicks.

Turn Excel Spreadsheets into Applications

Use our new AI interface to create web application in a few clicks.

Turn Excel Spreadsheets into Applications

Use our new AI interface to create web application in a few clicks.

Turn Excel Spreadsheets into Applications

Use our new AI interface to create web application in a few clicks.

Turn Excel Spreadsheets into Applications

Use our new AI interface to create web application in a few clicks.

Turn Excel Spreadsheets into Applications

Use our new AI interface to create web application in a few clicks.

Turn Excel Spreadsheets into Applications

Use our new AI interface to create web application in a few clicks.

It was incredibly easy to convert the tool into a web application. The process was smooth beyond my expectation. I had a working application in the matter of a couple of days. It just blew me away. If I went with my original developer from my last product, it would have been in the range of tens of thousands of dollars to build the application.


I spent a few hours, and were able to get the application pretty close. Then, I had some help from the SpreadsheetWeb team to fix it up, and it all took a couple days. I was ready to go live within a week. I would have guessed that custom coding would have taken weeks or months, and thousands of dollars. Several to tens of thousands of dollars range.


We considered putting the tool online using Google Apps or Google Sheets and having certain parts of it hidden. We also considered putting it on SharePoint or some kind of online server. Our plan was to have some version of the spreadsheet, and the challenge was figuring out what the front-end would look like and how the user would interact with it. The reason why we choose SpreadsheetWeb was because the interface looked cleaner. It didn’t look like we just made a spreadsheet. From the perspective of the potential buyer, it appeared more like a tool and not like some spreadsheet which we would just give a copy of


We considered custom coding, but that would cost us several thousands of Euros. The initial model was going to be 6-7,000 Euros. We had to see whether the business model made sense. The custom code approach would have been too big of an investment for this. The license and fee structure of SpreadsheetWeb made this transition much easier, and save us money. Using SpreadsheetWeb, we were able to try out the tool, and avoid the initial development costs. Furthermore, the SpreadsheetWeb platform is very flexible. If we need to make any changes to the tool, it’s now in my hands to do just that. With custom coding, I would have to hire a web developer every time I needed to make an adjustment. In general, we are very happy with the solution and the service we have received.


Before deciding to go with SpreadsheetWeb, we compared it with other solutions. For creating our own custom coded app, we got a quote for around $80,000. There’s definitely a lot of savings there for going with SpreadsheetWeb. They did a really good job of making our tool look nice, and their team was very responsive.


I am not a programmer. We tried using various spreadsheet conversion tools, but couldn’t find the flexibility we were looking for. SpreadsheetWeb’s Designer module is very easy to use and flexible. At the beginning, I was a little concerned and I was trying to use the same concepts as in other tools we were using, where your file is moved completely to the web. We just needed to set it up at the beginning, but it’s much easier to use than other similar tools we’ve tried in the past. Moving the business logic was seamless.


I was impressed with how quickly and easily we could bring our reasonably sophisticated Excel models to a web format. I appreciated the samples that were demonstrated to us, and thought that they looked not only accurate, but also were aesthetically pleasing. This is very important to us, especially when we are delivering something to our clients. Looking at the quality of the work that we saw, that we would be comfortable working with Pagos to deliver a high quality, interactive application to our clients, and that our clients would be happy with the application that we gave to them. Just as care deeply about our own work that we build, we want to make sure that anything we are bringing them meets that high standard of quality. Given the research that we did, we thought we could deliver a customer-ready application in less than half the time and price with SpreadsheetWeb, versus doing it ourselves or hiring an interactive agency to build us a custom application.


We contacted several companies. When they saw our Excel workbook, they were intimidated by it. They wanted to take the challenge, but they were going to be learning on us. The lead time from the moment we would give them the project and going into production was going to be upwards of 6 to 8 months. Seeing what can be done on the SpreadsheetWeb website with robust Excel models – when translated into web applications – was eye-opening.

This was like going to the right doctor and getting prescribed the right medicine. The time value of money was the best return I’ve seen in terms of web development for this kind of a project. The Excel expertise, knowledge in web technologies, and flexibility of the SpreadsheetWeb team was extremely valuable. The speed at which the project was deployed and went live was impressive.

The


SpreadsheetWeb allowed us to create a web-based timesheet application with user management integration in a very short amount of time. Creating an application like this as a custom project from scratch would’ve taken months of development. The SpreadsheetWeb applications can export user data in the exact format we need to be able to push it into our payment system, while also allowing our managers to get their own special versions at the same time. We were also set everything up on our servers, keeping the data in-house.


SpreadsheetWeb Cloud

Excel For The Web Not Working

Achieve agility, lower costs, easy updates, reduced administration with SpreadsheetWeb cloud. We offer public and private (dedicated) options

AWS and Azure

Excel On The Web

Run SpreadsheetWeb on AWS or Azure. Go live in minutes with our machine images.

On Premise

Deploy SpreadsheetWeb on your internal IT infrastructure. Keep your sensitive spreadsheets and data in-house. Integrate with internal systems.