Excel Power Query

Automating some tedious work. Using excel Power Query to take a list of URLs with different query strings and put the JSON that is returned from the website in the cell next to the URL.

First Row will have


B1= Results

All the URLs are the same expect for the query string.

The results are JSON but would like to have it stored as text in the the B column.

Taidot: Excel, tietojenkäsittely, Visual Basic

Näytä lisää: excel power query 2016, power query office 365, power query training, power query tutorial pdf, excel power query editor download, power query excel 2016 tutorial pdf, excel power query mac, power query excel 2019, department reports companies pakistan using excel work sheet, work roster using excel including breaks, using excel web query fill web form, using excel manage work allocation, web export using excel automation work, automating webpage entry using excel vba, using excel web query log secure sites, using excel macro refresh web query, Excel , Power Point work, excel power query, excel power query tutorial, excel power query macro

Tietoa työnantajasta:
( 1 arvostelu ) San Antonio, United States

Projektin tunnus: #21361164

Myönnetty käyttäjälle:


Hello, Would you share the list of the URLs so that i can check, assess and confirm the solution Looking forward working with you. Regards. Ahmad.

$80 USD 1 päivässä
(2 Arvostelua)

20 freelanceria on tarjonnut keskimäärin 109$ tähän työhön


Hello, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community (goo.g Lisää

$200 USD 2 päivässä
(728 arvostelua)

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$50 USD 1 päivässä
(317 arvostelua)

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje Lisää

$100 USD 5 päivässä
(233 arvostelua)

Hello? How are you? I am excited to work with you on this project. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom formula, etc... [login to view URL] Lisää

$155 USD 3 päivässä
(95 arvostelua)

Hey there, This can be easily done with python by sending requests to the website and you have more control over the results and output. Do you really need this in power query only? If not then ping me and we can dis Lisää

$50 USD 1 päivässä
(176 arvostelua)

Dear sir I will get the api from cell A use it in power query and then return the data to Cell B of its row in simple text. I have been in this industry for 1 year and such jobs are my daily practice. I can assure you Lisää

$150 USD 1 päivässä
(76 arvostelua)

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert VBA programmer on and I do not bid on Lisää

$155 USD 3 päivässä
(32 arvostelua)

⭐Hi! Thank you for the opportunity to bid on your project. I have read your details carefully. I have big experiences for Data processing and MS excel. I have huge experience for access vba forms and databases. So i ca Lisää

$200 USD 7 päivässä
(12 arvostelua)

Hello, How are you.. I have understood what you want and I'm very interested in your job post. I am a 100% completion Developer. I have experience of development like this. As an experienced developer, I am sure I can Lisää

$140 USD 1 päivässä
(6 arvostelua)

Dear Client, I can do this Job. I have excellent experience of Excel (VBA/MACROS/FORMULA'S),Data entry, Web Scrapping (Python and Selenium) and Web Research for more than 4 Year’s. Never ends up until you are 100% sa Lisää

$30 USD 1 päivässä
(24 arvostelua)

Hello, Hope you are doing well. I have gone through the project requirement and find my self in good position to complete this project using my expertise in excel vba. I would very much enjoy having the opportunity Lisää

$70 USD 2 päivässä
(5 arvostelua)

I can implement this task in python. Python is very powerful language for excel and json processing. You can see my portfolio for excel projects using python. The whole work will be automated using a single script. If Lisää

$50 USD 2 päivässä
(3 arvostelua)

I am hard working and always deliver my work on time with maximum accuracy. Bidding the least as i desperately need to start my first job on Relevant Skills and Experience I have worked on data entry j Lisää

$55 USD 2 päivässä
(0 arvostelua)

Hi, I do some work in excel work using excel formula and macro. Working with me will may save your money and time. I can start work just right now. I hope your kind contact on this project. Thanks!

$90 USD 2 päivässä
(0 arvostelua)

I  have more then 10 years of experience in SQL Server databse development and Administration. I have worked with medium to large mission critical databases. Worked for database design and performance tuning. I am Lisää

$35 USD 1 päivässä
(0 arvostelua)

Hi!, i can do for you it, i have much knowledge with PDF, Word, Excel and I can finish in a short time. I await more information. thank you

$140 USD 7 päivässä
(0 arvostelua)

i saw what you need it will be my luck to work with you i hope you will choose me and i am also expert in data entry.

$120 USD 7 päivässä
(0 arvostelua)

Hi I read your project in details and want to work for you. I am highly motivated person and believed in satisfaction of customer & delivered work. I am having 3 + years Experience in this type of job. If you want to h Lisää

$170 USD 2 päivässä
(0 arvostelua)

Hello. I have read your job description carefully. I have full experience in Excel macro and VBA and Web Scraping. So I can do your projet perfectly. I can start just now and I can deliver good result in time. I hope t Lisää

$140 USD 7 päivässä
(0 arvostelua)