Format JSON data via API call and format in Excel spreadsheet

Need to take a JSON feed from an API and then format nicely in an Excel sheet. I have tested and I am able to issue the API call via [url removed, login to view] and capture the returning JSON response. I’d like have someone write some Excel VBA to automate this. It should work as follows: #1. ASK FOR DATE: When I open the xlsm file, it should show a dialogue asking for the date of the data that I want, and default to the current system date. This date string needs to get inserted into the API URL call. #2. CREATE NEW SHEET: Then when I hit enter on the date dialog box, the program will create a sheet/tab with the date as the sheet/tab name. If there is an existing sheet/tab with that name, it should delete the existing sheet/tab and create a new one. #3. ISSUE API/GET DATA: Then the program will issue the URL to API call. (see API call at end) The data returned is in the format as in the [url removed, login to view] file (attached). There are just 3 fields/columns from the JSON response that I need. The program you write should be able to handle a response anywhere from 0-100 lines/rows, depending on the JSON data returned. #4. FORMATTING: Then there needs to be a bit of formatting in the sheet. I have provided a sample of what I’d like the ending sheet to look like. Here are the things that need to be done: Change the name of the column headings (from the JSON response), add 4 other column headings. Add a new row 1 and insert the date that this data is for. Format the Row 2 column headings, highlight all the data and put border lines around. Format the “Start Time” column to turn the “date/time” string from the JSON response into just a 12-hr time.

Evner: Excel, VB.NET

Se mere: excel change data format, format data entry excel spreadsheet, mt4 excel data format, google api json data mysql, facebook api data format, clean data format excel, excel common data format, excel form data format, data format macro excel, excel data format add net, excel macro paste clipboard data format, excel format input work data staff months, copy format excel spreadsheet, html format cut data excel spreadsheet web page, excel check data format, excel macro check data format, fnma data format excel, vb6 format excel spreadsheet, access vba open format excel spreadsheet, format excel spreadsheet track artist submissions

Om arbejdsgiveren:
( 33 bedømmelser ) Southeast, United States

Projekt ID: #12113273

Tildelt til:


Hi, I will be able to make all the requested changes.

$80 USD in 2 dage
(1 bedømmelse)

14 freelancere byder i gennemsnit $107 på dette job


Hello, Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and .net for Applications (vba) inside out; writing Microsoft Excel Macros. LET'S DISCUSS before starting the ta Flere

$250 USD in 4 dage
(105 bedømmelser)

I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, Flere

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

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. I have completed more than 290 projects. Please look at the feedback left by my employers to know more about my work. Wai Flere

$80 USD in 3 dage
(102 bedømmelser)

Hi, i can help in this project, please let me know more about it.

$50 USD in 0 dage
(17 bedømmelser)

Hi Hope you well ! I am Vinod Kumar. I am working as Senior Software Developer in IT company. I have 6 + years experience in .NET with C#,VB,ASP.NET MVC, Web Service, WCF, Javascript, JQuery, SQL, XML ,XSLT and Flere

$222 USD in 3 dage
(12 bedømmelser)

Good day I have over 20 years experience with Excel, macros and VBA and believe I can complete this project for you in 2 days. I would be using the VBA-JSON converter to make handling the JSON easier (https://git Flere

$50 USD in 2 dage
(1 bedømmelse)

Hi, I have more than 8 years of experience in wide range of web & mobile designing and development services. I have expertise in all aspects of website design and development (including mobile) and have been involve Flere

$35 USD på 1 dag
(1 bedømmelse)
$10 USD på 1 dag
(2 bedømmelser)
$50 USD på 1 dag
(4 bedømmelser)

Hi there.. I have read your project details completely and willing to do it for you... Check my recent reviews for our quality work on on time delivery Please inbox and we can discuss about project...

$100 USD på 1 dag
(0 bedømmelser)
$222 USD in 3 dage
(0 bedømmelser)
$50 USD in 2 dage
(0 bedømmelser)

Hi, I have extensive experience in working with excel macros with skills rating as Expert. I believe, if given an opportunity, I would be able to complete your project in stipulated time with no compromise on quality. Flere

$100 USD in 3 dage
(0 bedømmelser)

A proposal has not yet been provided

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