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.

Evner: Excel, Databehandling, Visual Basic

Se mere: 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

Om arbejdsgiveren:
( 1 bedømmelse ) San Antonio, United States

Projekt ID: #21361164

Tildelt til:


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 på 1 dag
(2 bedømmelser)

20 freelancere byder i gennemsnit $109 på dette job


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 freelancer.com and have been featured by the freelancer community (goo.g Flere

$200 USD in 2 dage
(728 bedømmelser)

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 på 1 dag
(317 bedømmelser)

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 Flere

$100 USD in 5 dage
(233 bedømmelser)

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] Flere

$155 USD in 3 dage
(95 bedømmelser)

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 Flere

$50 USD på 1 dag
(176 bedømmelser)

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 Flere

$150 USD på 1 dag
(76 bedømmelser)

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 freelancer.com and I do not bid on Flere

$155 USD in 3 dage
(32 bedømmelser)

⭐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 Flere

$200 USD in 7 dage
(12 bedømmelser)

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 Flere

$140 USD på 1 dag
(6 bedømmelser)

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 Flere

$30 USD på 1 dag
(24 bedømmelser)

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 Flere

$70 USD in 2 dage
(5 bedømmelser)

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 Flere

$50 USD in 2 dage
(3 bedømmelser)

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 freelancer.com. Relevant Skills and Experience I have worked on data entry j Flere

$55 USD in 2 dage
(0 bedømmelser)

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 in 2 dage
(0 bedømmelser)

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 Flere

$35 USD på 1 dag
(0 bedømmelser)

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 in 7 dage
(0 bedømmelser)

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 in 7 dage
(0 bedømmelser)

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 Flere

$170 USD in 2 dage
(0 bedømmelser)

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 Flere

$140 USD in 7 dage
(0 bedømmelser)