SharePoint Export to Excel not working iqy

Can not open the Sharepoint List (

I am at my wits end. I am working on a project where we are managing multiple sharepoint lists and we need to export them to excel. I can open the list on the sharepoint site, I can export the file, but I get stuck in a continuous loop trying to to the site. I am on office 365 working on a Microsoft surface. I have colleagues who do not. Hello guys, I have a survey done on the sharepoint services. It was quite successful, I had some answers But a button Export survey results to a spreadsheet produced me nothing in Excel. 1. I pressed the Export... button in WSS. 2. It warned me: To export a list, you must have a Windows · My workaround to this was i emptied my temp files and. Try Excel in the Safe Mode to determine whether background programs are interfering with Excel. If safe mode is unuseful, try create a new user profile and test opening iqy in new account. If the iqy could be opened in new account which approve your old account has been corrupted by something

Error with owssvr.iqy when exporting to Exce

  1. Export to Excel is a useful SharePoint feature. Once in a while you may run into a situation where the feature just won't work. There are several reasons why this feature may not work. I have listed a few of them in this article. Problem #1 You are using a non-32-bit Internet Explorer. Solution #1 [
  2. When Export to Excel function on a list from SharePoint 2010 it will not download the owssvr.iqy file and names it below. Using IE11 and Excel 2013
  3. Opening the .iqy directly with excels works by giving me a new excel sheet, but what I want to archive here is containing 3 different categories into 1 excel sheet and also have them automatically update whenever the sharepoint site receives any updates for the 3 categories(or when I click refresh)

Cannot Open iqy in excel - Microsoft Communit

  1. Export the Microsoft SharePoint list items shown in the current view to Excel to work with the data in a spreadsheet. From the command bar of the SharePoint list, select Export to Excel . Important: Export to Excel is available only when list items are not selected. The classic SharePoint experience shows a ribbon above the list, not a command bar
  2. Save As an Excel Workbook, if you need a static copy of the data. The workbook will NOT refresh new data. Only the web query (.iqy) file can. Document libraries can also be exported to Excel, however, the export will not contain the document. In it's place a link to the document is available. Next Steps. Check out these other SharePoint tips
  3. d: Exporting from SharePoint using IE allows you to export a view. Importing from SharePoint using Excel imports every single list item and column, regardless of view
  4. can download the specific list to Excel. When I click on Download to excel I see the message box that states DO YOU WANT TO OPEN OR SAVE. I click on open. The file name is owssvr.iqy. When I click on OPEN, nothing happens. If Excel is closed, Excel opens. If Excel is open, no additional file is opened. Thanks for your assistance
  5. @MauriceV I am not aware of any updates on this. What I have noticed though is that this happens to our users when they access the list from the left hand navigation links on pages that are not in modern format. If they access the list directly through it's url or site contents or from a page in modern format the export works
  6. I have a SharePoint 2013 list that is working just fine in the web browser--I'm trying to get the Export To Excel function to work but am running into issues. When I click the button in the SharePoint ribbon, it allows me to download an OWSSVR.iqy file

Export to Excel Not Working in SharePoint Online and

  1. Unfortunately the default SharePoint Export to Excel behavior will only export a .iqy file that ignores any filters applied. As mentioned in the comments, there are a lot of 3rd party solutions to achieve this functionality that you might want to look into - for instance, Export Selected Items to Excel could do the trick (create a view with no pagination and select all to export)
  2. This is correct. The .iqy file is a connection to the SharePoint list. When you open it in Excel, Excel automatically downloads the list data into a new worksheet, and retains a connection to the list through the query file. Otherwise it is not possible to export directly to XLSX format. - Chris Odegard Nov 15 '18 at 16:1
  3. To increase the Excel timeout value, follow these steps: Open Registry Editor. Locate and select the following registry subkey: On the Edit menu, point to New, and then select DWORD Value. Type DataFetchTimeout, and then press Enter. Right-click DataFetchTimeout, and then select Modify. Select Decimal for Base, type 90000 in the Value data box.

Export to Excel function from SharePoint 2010 list not

When you click Export to Excel to export a SharePoint list on a Mac, it doesn't open the file in Excel for Mac and instead downloads the query.iqy file. This is working as expected as the internet query connection is not supported by Excel for Mac. WORKAROUND. If you have Excel for Windows, you can save the file as XLSX and then open it in. From the command bar of the SharePoint list, select Export to Excel . Important: Export to Excel is available only when list items are not selected. The classic SharePoint experience shows a ribbon above the list, not a command bar. Select the List tab on the ribbon, and then select Export to Excel. Depending on your browser, you can save and. SharePoint List - Export to Excel only downloads owssvr.dll not .iqy. 1. Office 2016 SharePoint 2013. For any SharePoint list, when I click on the 'Export to Excel' button on the 'List' ribbon, I am prompted to download the owssvr.dll file. When it download it will download as owssvr.dll instead of owssvr.dll.iqy I have made a .iqy file by using Actions/Export to Spreadsheet from the view menu, and then uploaded this .iqy file back into SharePoint. When users click on it, it does bring up the data in Excel - but without the headings repeated each page, with the columns spilling onto a second page (width-wise), etc How to Export SharePoint List to Excel. You can export a SharePoint list to an Excel table with a few clicks by using a web interface of SharePoint Online. Open your team site in SharePoint Online, then open the SharePoint list you want to export. Click Export to Excel. A window notifies you that query.iqy must be opened in Excel

sharepoint - How to load

I have done a test in my SharePoint 2013, the issue is not reproduced with Windows 10, Office 2016 and SharePoint 2013. Make sure that you don't have old office versions beside office 2016. if you have, try to remove old versions. Or you can install office 2013 instead of office 2016. Per my research, here is a similar issue post for your. So Export to Excel may work abnormally. Per my understanding, you want to export items in the last 7 days to an Excel file every day and save it as a record. 1) Connect Excel to a SharePoint list data source. 3) Save the Excel file as a template file. Then you can open the template file every day and click Refresh, the items. You just have to extend the duration of the Excel export or request timeout by doing the following: Click Manage service applications under Service Applications. Click Excel Services Application next to Excel Services Application Web Service Application Note: not the item in grey under this.. You want the blue item The issue here ended up being with authentication to the Office application, in this case Excel. To resolve the issue I performed the following simple steps: Open Excel. Click the account link. At the top, click the sign out link. Close Excel. Go back to your SharePoint list and click the Export to Excel button

Export to Excel from SharePoint - SharePoin

  1. 1.Open the iqy file with Notepad and copy the URL address, which includes names of list and view. 2.Open Web connector in Power BI Desktop. 3.Paste the URL link in web connector and then choose your table to import. After creating reports in Power BI Desktop, you can publish the report to Power BI Service, and set schedule refresh for the dataset
  2. Excel cannot connect to the SharePoint list. This issue is happening to everyone on our production web application. Our quality assurance SharePoint farm and web application works perfectly. I've tried the following: No <soapExtensionTypes> type parameters exist in the web.config files as other forums might suggest
  3. Export a Folder to Excel. If you click on the Export to Excel button found in the SharePoint folder this will download a query.iqy file. When you open this file it launches Excel and creates a read-only connection to the list of files in the folder. You can refresh this just like when exporting a SharePoint List to an Excel Table
  4. So after a ton of research and trying to figure out how to make this work, I've finally gotten frustrated enough to post here. I have to create a button that can export a list in SharePoint 2010 to Excel (I know that there's a feature that does this, I'm trying to make it easier for people by just having this button displayed above the list)

I am experiencing the same issue in Sharepoint 2007. Thanks for the information you provided. I cant seem to find a solution. I am using a RadGrid inside a user control that is my web part in the Sharepoint page. I have an export to excel button which exports the grid items to excel using the following code Sharepoint 2010 - Exporting list to excel doesn't export all fields. Get answers from your peers along with millions of IT pros who visit Spiceworks. I exported an already populated list on SharePoint 2010 to Excel using Export to Excel utility but it didn't export the whole spreadsheet. It missed a number of fields Looking for some help. Trying to update sharepoint document file properties using excel list. I already have the excel export iqy file now in a xslx / table. hosted in a sharepoint document lib. cannot seem to get 'ID' from excel list as an option to config on the update file properties action- as ID Hi @dmistry ,. I am afraid that it might be not possible to export a SharePoint list to Excel using Flow. I have figured a workaround for your reference. I the following scenario, I am going to generate an HTML table, then create a word document in OneDrive for Business, then send an email with the word document as an attachment I have a excel vba script that imports SharePoint 2010 list items to Excel 2010. Initially I used to do 'export to excel' in SharePoint list ribbon, that generates .iqy file but there's a need to automate the process. The weird/strange thing is that when you do 'export to excel' in ribbon, the generated .iqy file even shows the values.

First, export to Excel by going to the Library tab, click Export to Excel and take the defaults. You'll see the resulting table will look like something like this. All of the folders are displayed. Insert a Content Editor webpart and link it to the file you saved in your SharePoint document library (Site Assets). Click Apply and then OK and Save your page. Now that you have created your custom-Export-To-Excel SharePoint List button, once your Click it, two popups will appear. Click Open, Excel will open up on your desktop and another. I can actually download the .iqy file successfully on Mac, but then Excel needs to be able to connect back to SharePoint to query that external data source. That doesn't work. This is an important feature to support for people on the Mac to be able to make use of SharePoint lists

Understanding SharePoint Exports to Exce

Here I am explaining how to implement the OOB 'Export to Excel' feature of SharePoint list using RPC (Remote Procedure Calls) with Javascript CSOM code. What is RPC : This is a protocol from Windows SharePoint Services(WSS) , helps in exchanging the data between client and the server which runs with WSS There may come a time when you may need to export your user list to excel. It's not that difficult. it's work.. great article.., now i can get all email address from all user on AD and sharepoint great tips. but actually i was looking for a solution how to export a sharepoint list to excel including email addresses (site column is. This means that any changes you make to the list in SharePoint will be applied to your export file. This is not done automatically. In order to see the changes made to the SharePoint list, in Excel, you have to refresh your Excel export file. Here's how you do this: 1. Looking at your Excel export file click on the Data Tab, then Connections 13. Feb 6, 2015. #1. Export to Excel column not formatting correctly, need HTML Tags removed help. Good afternoon, I have a process that is getting data from sharepoint page, containing 2 list. Both list contain one field I am having issues in my export, a 'Multiple Lines of Text' type field which is Rich Text in sharepoint

It is quite easy. Here are detailed instructions: Make sure you use Internet Explorer Browser. Export to Excel does not work from Google Chrome. Go to the list you want to export to Excel (i.e. Calendar) Navigate to the view you would like to export. The way it works with export to Excel, what you see in SharePoint is what you get in Excel That's not to say that the browsers listed in the table above, such as Firefox and Chrome won't work with SharePoint Server 2016 at all, it's just that it will confuse the users why some features won't work in these so-called supported browsers and they won't remember to switch to a fully supported browser for certain features SharePoint Excel Data Refresh - Common Issues. Version: 1.0. SharePoint Excel Services requires different bits and pieces to work correctly in order for it to deliver your BI Reports correctly. There are times when you have to review and update the configurations in order to make it work In Excel, right click on a cell in your list, select the Table menu and click Synchronize with SharePoint to synchronize your Excel file with SharePoint. Yes, it's so easy! Note: To retain this functionality, should you want to save your file as an Excel file, you need to save the workbook as Excel 2003 .XLS file format, not .XLSX 1.Please browse to the Excel file in SharePoint Online -> Click on the 3 dots beside the file name -> Open the excel in App as shown in below screenshot: - 2. After the File opens on your local Excel App -> Click on 'File' on top left -> Info -> Click on 'Copy Path' as shown in below screensho

Workaround: Export to Excel not working in Safari, Chrome

It's not always going to be better, and it's not always going to work, but it's worth a try, especially since a simple web query could boost your productivity! Excel Web Query .iqy Files. The real key to creating a dynamic excel web query is to create your own .iqy file. In it's basic form, the .iqy file is simply a TEXT file with three. Open SharePoint list in excel. Now, let us see how to Open SharePoint list in excel.Here, we will connect with the SharePoint Online site from excel. In my SharePoint Online site, I have created a custom list as Employees. And the list looks like below with some data

Sharepoint Export to Excel not workin

www.tanhacomputer.wordpress.comExport an external list to ExcelYou can synchronize data between an external list and Microsoft Excel, and keep both sets of d.. “Edit in Word” (or Excel) not SharePoint Librarian. Understanding SharePoint Exports to Excel. By: The iqy file is not a static file. The SharePoint data is not stored in the .iqy Save As an Excel Workbook 13/03/2012 · When saving the file we get a message Document not saved Workaround to export a list. After clicking OK, specially in Chrome, SharePoint will redirect you to a document that specifies when Excel is going to download and synchronize the data in SharePoint. It present information about the current list name and folder, formatting options, the SharePoint URL and other information If you do not have an excel file on the server, upload an excel sheet to any of the document library. 3) It will be opened in browser. 4) Use Open in excel link on the page to open it in excel. 5) open it in read only or edit mode 6) Provide credential on the log- in popup 7) Now go to the SharePoint list and try exporting the list to excel option If any problem occurs, the Export Tables to SharePoint Wizard immediately reports an issue and save it in your Access database like a log table. Note: If you are an access 2007 user, then Export Tables to SharePoint Wizard is known as Move to SharePoint Site Wizard. It doesn't make any referential integrity on SharePoint lists

Export to Excel - An Unexpected Error Has Occurred

SharePoint 2013 Export To Excel - An unexpected error has

1. First, we need to export our list to Excel via List>Export to Excel. 2. Open the iqy file in excel. This creates the necessary data connection in Excel which we will examine next. 3. Because this is an external data source we need to Enable the connection. 4 Export to Excel does not work: Win 10 and Office 365 Hello community, we use Qlik 11 plug-in on our Clients. The Clients have Win 10 / IE 11 / Office 365 (32 bit). When trying to Export to Excel or CSV, nothing happens. Doesn't matter if you open to Excel or you want to save it as a file. Another Client has Win 10/ IE 11 / Office 2016 and the. Export to Excel not working, button does not download the Excel spreadsheet kbt151057 PRODUCT K2 Five 5.1BASED ON K2 Five 5.1 This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice. This..

Filtered SharePoint List for Export to Excel - SharePoint

Furthermore I did not want to write a SharePoint app and wanted the Excel export to work using JavaScript. My initial research quickly led me to this article with supporting code here . This code shows using custom JavaScript in a custom display template With the group open in SharePoint, copy the URL and note the ID number at the end of the URL. Open a new excel workbook. From the Data tab, select New Query -> From Other Sources -> From OData Feed . Paste the group URL in the prompt but delete everything after the site address and replace with the following. Export SharePoint List Data to CSV. July 10, 2011. My 2nd open source contribution to Codeplex. This project is provide the feature for exporting the SharePoint list data to CSV. This can be used for SharePoint 2007 also. But needs to create separate project for MOSS 2007. OOB Export to excel not work if some services is not enable on your.

In a recent CRM Online project, I had a challenge that the users were not able to export all approx. 108,000 account records to Excel using the standard Export to Excel feature - nothing happened after they click Export. We tried the dynamic worksheet option, but similar issue: Excel froze for a few minutes as i I've confirmed the export and web part work as expected when I create a classic page and add the SPFx web part to it. The classic page does not use the sp-pages-assembly as referenced earlier. The primary issue I'm experiencing appears to be related in a recent update to the following file within the tenant (or in general) and how it interacts. Hi Think this may have more to do with Sharepoint than excel, but not sure where this post should sit? I have a master excel sheet (on sharepint) that is linked to around 30 excel files in different folders on sharepoint. When I update the data on the master spreadsheet, it updates all the other excel workbooks when they are opened and the update links button is chosen Next, Lets export SharePoint Online users and groups to excel using PowerShell. Export Users and Groups of All SharePoint Online Site Collections to CSV: Here is the PowerShell to export all groups and users to a CSV file

Conclusion. To be able to import Excel file into SharePoint list without facing this issue The specified file is not a valid spreadsheet or contains no data to import, you should first make sure that the SharePoint Site URL is added to the Trusted Sites in your Browser, also, you should ensure that the excel file has at least one row to be imported and the excel file is not corrupted Steps. Open SharePoint Designer, Create a new web part page. Add a new Data View Web Part from the database connection as a data source. From the above ribbon, Click Paging > Display All Items. Save and Browse the page in Internet Explorer. Right-click on the data view > Select Export to Microsoft Excel. Export Data View to Excel In Excel and in SharePoint, there is a copy link option, which will copy a link to the workbook so you can share it with others. It always feels like this should work, that I should be able to paste this URL into the Get Data experience in Power Query, and if it's been more than a few months since the last time I tried, I expect it to work The Export to SharePoint button in Excel gives a quick an easy way of transferring data from Excel to SharePoint, but the method has some issues. In the demo below Peter Kalmström, CEO and Systems Designer of kalmstrom.com Business Solutions, explains what you should be aware of when exporting from Excel to SharePoint using that Export button

Using JQuery we can export SharePoint list to Excel, Word, JSON, XML, SQL, CSV, TXT or PDF. Here I'm going to explain step by step explanation to implement this same in your environment. This will work for SharePoint 2013, 2016 and SharePoint online Users with the appropriate permissions can also create and upload files in the library from within the web part, sync files, and export to Excel. And when a file is selected, users can download, rename, or delete the file, or pin it to the top. This gives a fairly robust experience on the page This is done by exporting a SharePoint list to Excel and saving the Web Query. Upon opening the saved Web Query, the current data is pulled from SharePoint automatically. Once the list is in Excel, it will not update when SharePoint is updated without adjusting the connection settings that allow a background refresh. 1

Ensure that the Excel file is hosted on an on-premise Sharepoint site (rather than a cloud based site such as Office 365) and that the file is stored on the SharePoint local file system. Verify that Tableau Desktop uses the UNC path to connect to the data source. Note: A UNC path is the full name of a resource, directory, or file on a network Export List Template 1. I've a User Demo List in my SharePoint Site for which I will create a list template. 2. Click on List tab under SharePoint ribbon. 3. Go to SharePoint list Settings by click on List Settings. 4. Next, click on Save list as template as shown. 5. Fill the File name and Template name. Template description is optional.

With the tool installed, go to your favorite SharePoint site and go to a SharePoint List. Click on Export to Excel . Click on Open , and Excel will open the list however this time with the Synchronize with SharePoint option activated! Note: In order to retain the functionality for this table across saves, you need to save the workbook. export power bi to excel. Select the Summarized data and select the File format as .xlsx (Excel) from the drop-down. Click on Export. Once you will click on the Export option, then the file will be downloaded and saved as per the name of the visualization. export power bi to excel An Excel Web query allows you to bring data from a Web site into an Excel worksheet. It will find any tables on the Web page and let you select the ones containing data you want to put into your. But this was not the reason in our case. We had the same issue and solution was to enable Spe.IdentityServer.config at \inetpub\wwwroot\website\App_Config\Include\Spe . OOTB this file comes with Sitecore Powershell module as disabled

Click on the Export button under the Table Design tab and select 'Export Table to SharePoint List'. Enter the URL to the SharePoint site where you want to import the Excel table. Check the box for read-only connection. Enter a name for the new SharePoint list. Click Next and then Finish Once created, the print-out can be sent to the printer, converted to PDF, emailed and, since recently, exported to Microsoft Excel. Now we are also adding the ability to export to Microsoft Word. You can use this feature to generate and even email Word documents based on your list data Version history is available in Sharepoint for all files in the Document Library — including Word documents, Excel spreadsheets, PowerPoints, and OneNotes — as well as custom lists. It only takes a few minutes to enable version control for both lists and libraries; however, version control is typically enabled by default for libraries

I have been successfully exporting a gridview to Excel on an .aspx page without any problems using the following code. If grdStudent.Rows.Count.ToString + 1 < 65536 Then Response.ClearConten.. First, we will connect the site URL with the user's credentials. To connect the SharePoint site with PNP refer to this article. So for this, we will use the Add-PnPField method. We will import the CSV using the Import-Csv method. Then we will add the records to the list using the Add-PnPListItem method

Step 1 - Copy and transport the Excel Customizations.exportedUI XML file to the destination computer. Step 2 - Open Excel Options window's Customize Ribbon panel by following the first and second steps from the beginning of this lesson. Step 3 - Click Import/Export button and then select Import customization file, as shown in below image How to setup hyperlink to open report in Excel or in PDF from SSRS in SharePoint Integrated Mode with two parameter value I tried with this url but it doesn't work. Do I need to pass parameter to. Solution 1: Open Excel in Safe Mode. If Excel is not working as intended and frequently stops responding, you may try to start Excel in Safe Mode. It is a common DIY way to fix 'Excel is not responding' problem With Excel open, click the Power Query tab, select From Other Sources and the select From SharePoint List. Next, enter the URL for the SharePoint site (or subsite) that contains the list you wish to query. If it is the first time accessing this site, you will be prompted for credentials. If your site is Office365, be sure to enter. In my last post I have show you how to retrieve current user profile in Sharepoint 2007, before that I have also posted on how to display custom list items in SPGridView. Today I am going to work on how to export SPGridView items into Excel spreadsheet in Sharepoint 2007. Most of the code I have used form Matt Berseth blog article Export GridView to Excel so thanks to Matt and also thanks to.

Everything you need to know about working with SharePoint Server using VBA. Most importantly teaches you in layman's term how to use ADO, SQL in your VBA Pro.. Separate your Excel file into different workbooks: Here, you can split up the large Excel file you are working with into different separate workbooks before going ahead to open each one in a different instance of Excel from the other to avoid complications that come from working with large files. By implication, each of these workbooks you open. Press Ctrl-V to paste the values from your Excel Spreadsheet. Click on Allow access button when you see the below popup on screen. The Excel data gets pasted to the bottom of your List. Now, SharePoint validates the data and if the values do not match the data type, it shows a warning icon next to the items Here's the step-by-step to save a list as a list template: Navigate and enter the list you want to save as a template. Click on List on the ribbon and then List Settings. Under Permissions and Management in the center column of settings, find and click Save list as Template. Note: that not all lists types are exportable Day 350 - Using Gantt Charts in SharePoint Task Lists. #Office365Challenge Task lists are one of my favourites to show business the value of SharePoint. So much time is wasted taking notes in meetings, then capturing it in Excel, distributing it and trying our best to manage and update them. Thanks to Task Lists, this can be a less painful task

As in the first exercise of this chapter, you can maintain a link between the SharePoint list and the Excel data, but any changes in the Excel spreadsheet are not reflected in the SharePoint list. You can only synchronize changes in the SharePoint list to the Excel spreadsheet. The export to SharePoint process uses a two-step wizard The PBIX file connected to Excel files in SharePoint online using a Web connection. Once the reports were created, we stored the PBIX files in a separate SharePoint Online folder. Next, we opened the Power BI Service and connected to the reports directly from Power BI to a SharePoint team site, if you aren't familiar with that process you can.

In most of the projects we may need to present the reports / dashboards in graphic format for better understanding. If the version of SharePoint that you are using does not have Chart web part / Performance Point (BI Feature), then the below steps will help you to create reports/ dashboards using excel and REST API. Step 1-Create an excel workbook and in the worksheet fill the data for report Summary: Guest blogger, Doug Finke talks about his PowerShell Excel module.. The PowerShell Excel Module is a brand new, exciting, and better way to interact with Microsoft Excel from Windows PowerShell. Plus for bonus points, you don't need Excel installed on the target machine to create the spreadsheet. Many users of this module generate Excel spreadsheets on servers, and then others in.

SSRS has the option of exporting reports to many formats and Microsoft Excel is the most common format that users use. However, since Microsoft Excel has the Sheet feature, users would like exporting SSRS Reports to multiple sheets of excel. We looked at two options for creating multiple sheets in Microsoft Excel Running the Import Wizard: Open the file you would like to import the data into or create a blank file. File → Open → Files of type → Excel workbook - Locate the file and click on it, Click on Open. The Import Wizard will start. Click. If you have previously created a map, you can use the existing map Find the right app for your business needs. Get solutions tailored to your industry: Agriculture, Education, Distribution, Financial services, Government, Healthcare, Manufacturing, Professional services, Retail and consumer goods The Excel Web Access Web Part makes it easier than ever to access spreadsheets and collaborate with team members and colleagues even if you do not have Excel installed on your computer. With this feature, you are able to open Excel directly into a Web browser, as well as add spreadsheets to your SharePoint 2013 site.. In this article, we'll introduce you to the Excel Web Access Web Part in.

HarePoint Analytics for Microsoft SharePoint is a web analytics solution that provides usage reports at all levels of your farm; it is a source for full information on the performance and utilization of SharePoint-based portals and websites. Product reports are covering such aspects as users and their behavior; usage of content, documents, list items and search services VBA Script to Scrape website with Excel (Not Data Entry) - inputs in excel, scrape based on excel inputs 6 days left Need an excel file in which I can add up to 500 IDs, and then a script enters one specific website, inputs one by one the IDs, and retrieves data as instructed in the attached file