Withdata Software

Category: use

  • Convert XML to Table

    Want to convert XML to table? Here are some tools you can try: Use Data File Converter to Convert XML to CSV table, Convert XML to Excel table and Convert XML to HTML table. If you want to import XML to database table, you can try File To DB: Import XML to Access table Import XML…

  • Format multiple JSON files into one CSV for NTFS on OpenSea

    If you want to format multiple JSON files into one CSV for NTFS on OpenSea, you can try Data File Converter, just in a few mouse clicks. 1. Open Data File Converter, select “Files” – “JSON”, “File” – “CSV”. 2. Choose OpenSea JSON metadata files folder. Config JSON options. Custom JSON columns. 3. Set CSV…

  • Convert nested JSON to CSV

    I see a post Convert nested JSON to CSV or table, the poster have JSON data like this: menu1.json {“menu”: { “id”: “file”, “value”: “File”, “popup”: { “menuitem”: [ {“value”: “New”, “onclick”: “CreateNewDoc()”}, {“value”: “Open”, “onclick”: “OpenDoc()”}, {“value”: “Close”, “onclick”: “CloseDoc()”} ] } }} He want to convert it to CSV or table like this:…

  • Convert XML attributes to CSV columns

    I see a post How to convert XML into CSV using XSL, the poster has a test XML like this: <Tester author=”Name” id=”16384543″> <insert tableName=”sampletable”> <column name=”id” valueNumeric=”2″/> <column name=”name” value=”kathy”/> <column name=”active” valueBoolean=”true”/> <column name=”age” valueNumeric=”2″/> </insert> <insert tableName=”sampletable”> <column name=”id” valueNumeric=”23″/> <column name=”name” value=”Queen”/> <column name=”active” valueBoolean=”true”/> <column name=”age” valueNumeric=”29″/> </insert> <insert tableName=”sampletable”>…

  • Convert KML to CSV

    If you want to convert KML files to CSV files, you can try Data File Converter. An sample KML (Keyhole Markup Language) file like this: <?xml version=”1.0″ encoding=”UTF-8″?> <kml xmlns=”http://www.opengis.net/kml/2.2″> <Placemark> <name>Simple placemark</name> <description>Attached to the ground. Intelligently places itself at the height of the underlying terrain.</description> <Point> <coordinates>-122.0822035425683,37.42228990140251,0</coordinates> </Point> </Placemark> </kml> 1. Open KML…

  • Convert JSON with attributes to CSV

    I want to convert some NFT metadata JSON files to CSV for opensea. JSON data like this: { “name”: “5”, “description”: “”, “external_url”: “”, “image”: “5.png”, “attributes”: [ { “trait_type”: “Background”, “value”: “DOT-6” }, { “trait_type”: “Luckbox”, “value”: “3” } ], “properties”: { “files”: [ { “uri”: “5.png”, “type”: “image/png” } ], “category”: “image”, “creators”: []…

  • Convert XML (mixed nodes and attributes) to CSV file

    I see a post Convert xml (mixed nodes and attributes) to csv file using c#, the poster has an XML which has mix of nodes and nodes with attributes: <?xml version=”1.0″ encoding=”utf-8″?> <Root> <StudentRequestList count=”3″> <StudentRequest> <StudentFirstName>Test1</StudentFirstName> <StudentLastName>TestLastName</StudentLastName> <StudentGrade>3</StudentGrade> <StudentHomeroomTeacher>WhiteTest1</StudentHomeroomTeacher> <VariableData> <Variable name=”Email”>test@email.com</Variable> <Variable name=”Hobby1″>TestHobby1</Variable> <Variable name=”Hobby2″>TestHobby2</Variable> <Variable name=”Hobby3″>TestHobby3</Variable> <Variable name=”satscore”>satscoreTest1</Variable> <Variable name=”kprepscore”>krepscore1</Variable> </VariableData> </StudentRequest>…

  • Convert XML to CSV with node path as header

    I see a post Convert XML to CSV (with node path as header) using XSLT, the poster have this XML data: <tXML> <Header> <Source>XPTO</Source> <User_ID>127</User_ID> <Message_Type>Ship</Message_Type> <Company_ID>105</Company_ID> <Msg_Locale>English (United States)</Msg_Locale> <Version>2017</Version> </Header> <Message> <Ship> <ShipSummary> <ComName>XPTO 123</ComName> <FacName>6</FacName> </ShipSummary> </Ship> </Message> </tXML> He want to convert to CSV like this: tXML/Header/Source,tXML/Header/User_ID,tXML/Header/Message_Type,tXML/Header/Company_ID,tXML/Header/Msg_Locale,tXML/Header/Version,tXML/Message/Ship/ShipSummary/ComName,tXML/Message/Ship/ShipSummary/FacName XPTO,127,Ship,105,English (United States),2017,XPTO 123,6…

  • Convert nested JSON with nested arrays to CSV

    I see a post Convert nested json with nested arrays in csv. The poster have this JSON data: [ { “aggregate_result”: [], “explain”: “”, “key_with_document”: [ { “document”: { “creation_date”: 1643342434, “expiration_date”: 2053342527, “modification_date”: 1643342527, “revision”: 4, “struct”: { “MatchResponse”: [ { “adRefId”: “e6040-c8dcdb165993”, “addrRefId”: “city_list:0”, “MatchCode”: “REGI_ADDR_BLOCK”, “maxScore”: 0.9968223809704663 }, { “adRefId”: “800-3c7a04dc8d3f”, “addrRefId”:…

  • Convert Large JSON to CSV without coding

    Sometimes you need to convert large JSON files to other formats, like CSV, TSV, TXT, Excel, XML, or SQL. If you don’t like to program, you can try Withdata Data File Converter, a native GUI JSON to CSV converter for Windows, Linux, and macOS, you can convert large JSON to CSV easily. Can run in…