Results 1 to 8 of 8

Convert JSON to .CSV

Threaded View

eltel2910 Convert JSON to .CSV 06-27-2024, 08:27 AM
JohnTopley Re: Convert JSON to .CSV 06-27-2024, 08:51 AM
TMS Re: Convert JSON to .CSV 06-27-2024, 09:05 AM
TMS Re: Convert JSON to .CSV 06-27-2024, 09:20 AM
eltel2910 Re: Convert JSON to .CSV 06-27-2024, 11:12 AM
alansidman Re: Convert JSON to .CSV 06-27-2024, 01:28 PM
JohnTopley Re: Convert JSON to .CSV 06-27-2024, 02:34 PM
TMS Re: Convert JSON to .CSV 06-27-2024, 02:44 PM
  1. #1
    Registered User
    Join Date
    12-13-2023
    Location
    Michigan, USA
    MS-Off Ver
    Microsoft 365 MSO (Version 2311 Build 16.0.17029.20028) 64-bit
    Posts
    13

    Convert JSON to .CSV

    Added spreadsheet showing my desired output from the JSON input. Mostly I need the X and Y data to plot the point data, but the other attributes are important as well.

    I have recovered database information that I am trying to reconnstruct, the data was given in JSON format like this:

    {"layerServerGens":[{"id":0,"serverGen":234091}],"transportType":"esriTransportTypeUrl","responseType":"esriDataChangesResponseTypeEdits","edits":[{"id":0,"features":{"adds":[],"updates":[],"deletes":[{"geometry":{"x":434757.92663790932,"y":2329162.1516300468},"attributes":{"FID":781,"GlobalID_3":"7786EC58-1FDD-448A-9F11-22A52D67FC70","Long":null,"Lat":null,"OWNER":null,"INSTALLATI":null,"COMMENTS":null,"HEIGHT":null,"MATERIAL":null,"STYLE":null,"GLOBALID":null,"NAME":null,"BUILD":null,"STATUS":null,"GlobalID_2":null,"CreationDa":null,"Creator":null,"EditDate":null,"Editor":null,"layer":null,"path":null,"CreationDate":1664812533657,"Creator_1":"admin.wideband","EditDate_1":1664812533657,"Editor_1":"admin.wideband","NODE":null}},{"geometry":{"x":1059115.5835527368,"y":2865797.5113765462},"attributes":{"FID":782,"GlobalID_3":"F83F39EF-F428-4A3A-B494-4FBB9EA5B542","Long":null,"Lat":null,"OWNER":"AMERICAN TOWER","INSTALLATI":null,"COMMENTS":null,"HEIGHT":null,"MATERIAL":null,"STYLE":null,"GLOBALID":null,"NAME":"TOWER-AT","BUILD":null,"STATUS":null,"GlobalID_2":null,"CreationDa":null,"Creator":null,"EditDate":null,"Editor":null,"layer":null,"path":null,"CreationDate":1677264270803,"Creator_1":"rsigns.wideband","EditDate_1":1677264316967,"Editor_1":"rsigns.wideband","NODE":null}}, ...... format repeats and continues on for a long time ....

    I just need to get it into a .CSV format and Excel seems to be a bit confused when I import it. I am wondering if the structure is confusing excel?

    I really only need the "geometry" data (x,y) and in the "attributes" data (FID,GlobalID, etc)

    So something formatted like this:

    geometry_x geometry_y attributes_FID attributes_GlobalID_3 attributes_CreationDate attributes_Creator_1 attributes_EditDate_1 attributes_Editor_1


    Any help or clues would be greatly appreciated.
    Attached Files Attached Files
    Last edited by eltel2910; 06-27-2024 at 11:14 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. convert json file to excel
    By MaartenRo in forum Excel General
    Replies: 5
    Last Post: 07-26-2023, 02:59 AM
  2. convert json file to excel
    By MaartenRo in forum Access Tables & Databases
    Replies: 5
    Last Post: 07-26-2023, 02:59 AM
  3. [SOLVED] Convert json to csv
    By hartwith in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-06-2022, 04:02 AM
  4. Convert short VBA code to google sheet Json
    By tagazou in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-14-2020, 07:44 AM
  5. [SOLVED] Vba convert excel to json with additional text
    By chhiew in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-24-2019, 10:14 PM
  6. [SOLVED] Convert jscript JSON flattener to work with VBA ScriptControl
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-03-2018, 11:49 AM
  7. Convert Object to JSON String
    By amartinez988 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-01-2016, 03:41 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1