title: Using Excel to read and write data to a RESTful API
body: <p>I have data exposed by <a href="http://www.restapitutorial.com/lessons/restquicktips.html" rel="nofollow noreferrer">JSON RESTful API</a> with full CRUD operations.  I want to be able to load a set of records into Excel. Then I want to edit/add/remove the rows. Then I want to hit the "Refresh" button in Excel to push all the modifications back to the RESTful API.</p>
  
  <p>How can I do this?  Is there an add-in for Excel to do this? I see that Excel supports several "data connection" protocols,</p>
  
  <p><a href="https://i.stack.imgur.com/Pxifw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Pxifw.png" alt="excel data tab"></a></p>
  
  <p>The "Other Sources" has Wizards for OLEDB and ODBC. Is it reasonable to write a two-way adapter for one of those protocols that will read/write the REST api?</p>
  
  <p>If this is too hard I suppose I could ditch Excel and use a web-based table editor, like <a href="http://www.jtable.org/" rel="nofollow noreferrer">jtable</a>, or <a href="http://jquery-plugins.net/tag/table-editor" rel="nofollow noreferrer">jqgrid</a>. Any advice appreciated.</p>