{"id":"https://openalex.org/W4387614448","doi":"https://doi.org/10.1016/j.simpa.2023.100588","title":"Json2Xlsx: Extraction and visualization of nested data in a sparse spreadsheet","display_name":"Json2Xlsx: Extraction and visualization of nested data in a sparse spreadsheet","publication_year":2023,"publication_date":"2023-10-13","ids":{"openalex":"https://openalex.org/W4387614448","doi":"https://doi.org/10.1016/j.simpa.2023.100588"},"language":"en","primary_location":{"id":"doi:10.1016/j.simpa.2023.100588","doi":"https://doi.org/10.1016/j.simpa.2023.100588","is_oa":true,"landing_page_url":"https://doi.org/10.1016/j.simpa.2023.100588","pdf_url":"http://www.softwareimpacts.com/article/S2665963823001252/pdf","source":{"id":"https://openalex.org/S4210180398","display_name":"Software Impacts","issn_l":"2665-9638","issn":["2665-9638"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-d","jufo-1","norway-1","poland-20","vabb-shw"],"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Software Impacts","raw_type":"journal-article"},"volume":null,"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"http://www.softwareimpacts.com/article/S2665963823001252/pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5029151960","display_name":"Raphael Scheible","orcid":"https://orcid.org/0000-0003-2067-5569","observed_orcids":["https://orcid.org/0000-0003-2067-5569"]},"institutions":[{"id":"https://openalex.org/I161046081","display_name":"University of Freiburg","ror":"https://ror.org/0245cg223","country_code":"DE","type":"education","lineage":["https://openalex.org/I161046081"]},{"id":"https://openalex.org/I2801240073","display_name":"University Medical Center Freiburg","ror":"https://ror.org/03vzbgh69","country_code":"DE","type":"healthcare","lineage":["https://openalex.org/I2801240073"]},{"id":"https://openalex.org/I2802619606","display_name":"TUM Klinikum","ror":"https://ror.org/04jc43x05","country_code":"DE","type":"healthcare","lineage":["https://openalex.org/I2802619606","https://openalex.org/I62916508"]},{"id":"https://openalex.org/I62916508","display_name":"Technical University of Munich","ror":"https://ror.org/02kkvpp62","country_code":"DE","type":"education","lineage":["https://openalex.org/I62916508"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Raphael Scheible","raw_affiliation_strings":["Institute for AI and Informatics in Medicine, University Hospital Rechts der Isar, Technical University Munich, 81675 Munich, Germany","Institute for Immunodeficiency, Center for Chronic Immunodeficiency, Medical Center-University of Freiburg, Faculty of Medicine, University of Freiburg, 79106 Freiburg, Germany"],"raw_orcid":"https://orcid.org/0000-0003-2067-5569","affiliations":[{"raw_affiliation_string":"Institute for AI and Informatics in Medicine, University Hospital Rechts der Isar, Technical University Munich, 81675 Munich, Germany","institution_ids":["https://openalex.org/I2802619606","https://openalex.org/I62916508"]},{"raw_affiliation_string":"Institute for Immunodeficiency, Center for Chronic Immunodeficiency, Medical Center-University of Freiburg, Faculty of Medicine, University of Freiburg, 79106 Freiburg, Germany","institution_ids":["https://openalex.org/I161046081","https://openalex.org/I2801240073"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5031062569","display_name":"Stephan Rusch","orcid":"https://orcid.org/0000-0002-3529-1384","observed_orcids":["https://orcid.org/0000-0002-3529-1384"]},"institutions":[{"id":"https://openalex.org/I161046081","display_name":"University of Freiburg","ror":"https://ror.org/0245cg223","country_code":"DE","type":"education","lineage":["https://openalex.org/I161046081"]},{"id":"https://openalex.org/I2801240073","display_name":"University Medical Center Freiburg","ror":"https://ror.org/03vzbgh69","country_code":"DE","type":"healthcare","lineage":["https://openalex.org/I2801240073"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Stephan Rusch","raw_affiliation_strings":["FREEZE-Biobank \u2013 Center for Biobanking, Medical Center-University of Freiburg, Faculty of Medicine, University of Freiburg, 79106 Freiburg, Germany","Institute for Immunodeficiency, Center for Chronic Immunodeficiency, Medical Center-University of Freiburg, Faculty of Medicine, University of Freiburg, 79106 Freiburg, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"FREEZE-Biobank \u2013 Center for Biobanking, Medical Center-University of Freiburg, Faculty of Medicine, University of Freiburg, 79106 Freiburg, Germany","institution_ids":["https://openalex.org/I161046081","https://openalex.org/I2801240073"]},{"raw_affiliation_string":"Institute for Immunodeficiency, Center for Chronic Immunodeficiency, Medical Center-University of Freiburg, Faculty of Medicine, University of Freiburg, 79106 Freiburg, Germany","institution_ids":["https://openalex.org/I161046081","https://openalex.org/I2801240073"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5080318958","display_name":"Maria Elena Maccari","orcid":"https://orcid.org/0000-0001-6488-7622","observed_orcids":["https://orcid.org/0000-0001-6488-7622"]},"institutions":[{"id":"https://openalex.org/I161046081","display_name":"University of Freiburg","ror":"https://ror.org/0245cg223","country_code":"DE","type":"education","lineage":["https://openalex.org/I161046081"]},{"id":"https://openalex.org/I2801240073","display_name":"University Medical Center Freiburg","ror":"https://ror.org/03vzbgh69","country_code":"DE","type":"healthcare","lineage":["https://openalex.org/I2801240073"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Maria Elena Maccari","raw_affiliation_strings":["Institute for Immunodeficiency, Center for Chronic Immunodeficiency, Medical Center-University of Freiburg, Faculty of Medicine, University of Freiburg, 79106 Freiburg, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute for Immunodeficiency, Center for Chronic Immunodeficiency, Medical Center-University of Freiburg, Faculty of Medicine, University of Freiburg, 79106 Freiburg, Germany","institution_ids":["https://openalex.org/I161046081","https://openalex.org/I2801240073"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027980182","display_name":"Markus G. Seidel","orcid":"https://orcid.org/0000-0003-0981-8661","observed_orcids":["https://orcid.org/0000-0003-0981-8661"]},"institutions":[{"id":"https://openalex.org/I202276237","display_name":"Medical University of Graz","ror":"https://ror.org/02n0bts35","country_code":"AT","type":"education","lineage":["https://openalex.org/I202276237"]}],"countries":["AT"],"is_corresponding":true,"raw_author_name":"Markus G. Seidel","raw_affiliation_strings":["Division for Pediatric Hematology-Oncology, Department of Pediatrics and Adolescent Medicine, Medical University of Graz, 8036 Graz, Austria"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Division for Pediatric Hematology-Oncology, Department of Pediatrics and Adolescent Medicine, Medical University of Graz, 8036 Graz, Austria","institution_ids":["https://openalex.org/I202276237"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038630174","display_name":"Stephan R. Ehl","orcid":"https://orcid.org/0000-0002-9265-2721","observed_orcids":["https://orcid.org/0000-0002-9265-2721"]},"institutions":[{"id":"https://openalex.org/I161046081","display_name":"University of Freiburg","ror":"https://ror.org/0245cg223","country_code":"DE","type":"education","lineage":["https://openalex.org/I161046081"]},{"id":"https://openalex.org/I2801240073","display_name":"University Medical Center Freiburg","ror":"https://ror.org/03vzbgh69","country_code":"DE","type":"healthcare","lineage":["https://openalex.org/I2801240073"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Stephan Ehl","raw_affiliation_strings":["Institute for Immunodeficiency, Center for Chronic Immunodeficiency, Medical Center-University of Freiburg, Faculty of Medicine, University of Freiburg, 79106 Freiburg, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute for Immunodeficiency, Center for Chronic Immunodeficiency, Medical Center-University of Freiburg, Faculty of Medicine, University of Freiburg, 79106 Freiburg, Germany","institution_ids":["https://openalex.org/I161046081","https://openalex.org/I2801240073"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5043483596","display_name":"Alexandra Nieters","orcid":"https://orcid.org/0000-0002-6184-9759","observed_orcids":["https://orcid.org/0000-0002-6184-9759"]},"institutions":[{"id":"https://openalex.org/I161046081","display_name":"University of Freiburg","ror":"https://ror.org/0245cg223","country_code":"DE","type":"education","lineage":["https://openalex.org/I161046081"]},{"id":"https://openalex.org/I2801240073","display_name":"University Medical Center Freiburg","ror":"https://ror.org/03vzbgh69","country_code":"DE","type":"healthcare","lineage":["https://openalex.org/I2801240073"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Alexandra Nieters","raw_affiliation_strings":["FREEZE-Biobank \u2013 Center for Biobanking, Medical Center-University of Freiburg, Faculty of Medicine, University of Freiburg, 79106 Freiburg, Germany","Institute for Immunodeficiency, Center for Chronic Immunodeficiency, Medical Center-University of Freiburg, Faculty of Medicine, University of Freiburg, 79106 Freiburg, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"FREEZE-Biobank \u2013 Center for Biobanking, Medical Center-University of Freiburg, Faculty of Medicine, University of Freiburg, 79106 Freiburg, Germany","institution_ids":["https://openalex.org/I161046081","https://openalex.org/I2801240073"]},{"raw_affiliation_string":"Institute for Immunodeficiency, Center for Chronic Immunodeficiency, Medical Center-University of Freiburg, Faculty of Medicine, University of Freiburg, 79106 Freiburg, Germany","institution_ids":["https://openalex.org/I161046081","https://openalex.org/I2801240073"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5056926926","display_name":"Gerhard Kindle","orcid":"https://orcid.org/0000-0003-0894-5327","observed_orcids":["https://orcid.org/0000-0003-0894-5327"]},"institutions":[{"id":"https://openalex.org/I161046081","display_name":"University of Freiburg","ror":"https://ror.org/0245cg223","country_code":"DE","type":"education","lineage":["https://openalex.org/I161046081"]},{"id":"https://openalex.org/I2801240073","display_name":"University Medical Center Freiburg","ror":"https://ror.org/03vzbgh69","country_code":"DE","type":"healthcare","lineage":["https://openalex.org/I2801240073"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Gerhard Kindle","raw_affiliation_strings":["FREEZE-Biobank \u2013 Center for Biobanking, Medical Center-University of Freiburg, Faculty of Medicine, University of Freiburg, 79106 Freiburg, Germany","Institute for Immunodeficiency, Center for Chronic Immunodeficiency, Medical Center-University of Freiburg, Faculty of Medicine, University of Freiburg, 79106 Freiburg, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"FREEZE-Biobank \u2013 Center for Biobanking, Medical Center-University of Freiburg, Faculty of Medicine, University of Freiburg, 79106 Freiburg, Germany","institution_ids":["https://openalex.org/I161046081","https://openalex.org/I2801240073"]},{"raw_affiliation_string":"Institute for Immunodeficiency, Center for Chronic Immunodeficiency, Medical Center-University of Freiburg, Faculty of Medicine, University of Freiburg, 79106 Freiburg, Germany","institution_ids":["https://openalex.org/I161046081","https://openalex.org/I2801240073"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5027980182","https://openalex.org/A5029151960","https://openalex.org/A5031062569","https://openalex.org/A5038630174","https://openalex.org/A5043483596","https://openalex.org/A5056926926","https://openalex.org/A5080318958"],"corresponding_institution_ids":["https://openalex.org/I161046081","https://openalex.org/I202276237","https://openalex.org/I2801240073","https://openalex.org/I2802619606","https://openalex.org/I62916508"],"apc_list":{"value":260,"currency":"USD","value_usd":260},"apc_paid":{"value":285,"currency":"EUR","value_usd":307},"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.1686999,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"18","issue":null,"first_page":"100588","last_page":"100588"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.4487000107765198,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.4487000107765198,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13681","display_name":"Engineering and Information Technology","score":0.18770000338554382,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10799","display_name":"Data Visualization and Analytics","score":0.061799999326467514,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/data-visualization","display_name":"data visualization","score":0.5329999923706055},{"id":"https://openalex.org/keywords/json-api","display_name":"JSON API","score":0.5120000243186951},{"id":"https://openalex.org/keywords/php-frameworks","display_name":"PHP frameworks","score":0.5540000200271606},{"id":"https://openalex.org/keywords/healthcare-data-management","display_name":"health data management","score":0.5}],"concepts":[{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.6904561519622803},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6695011854171753},{"id":"https://openalex.org/C4725764","wikidata":"https://www.wikidata.org/wiki/Q844704","display_name":"Extraction (chemistry)","level":2,"score":0.5053563714027405},{"id":"https://openalex.org/C2777466982","wikidata":"https://www.wikidata.org/wiki/Q5227287","display_name":"Data extraction","level":3,"score":0.41118475794792175},{"id":"https://openalex.org/C121684516","wikidata":"https://www.wikidata.org/wiki/Q7600677","display_name":"Computer graphics (images)","level":1,"score":0.4052301347255707},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3208242356777191},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.07707861065864563},{"id":"https://openalex.org/C2779473830","wikidata":"https://www.wikidata.org/wiki/Q1540899","display_name":"MEDLINE","level":2,"score":0.06885701417922974},{"id":"https://openalex.org/C43617362","wikidata":"https://www.wikidata.org/wiki/Q170050","display_name":"Chromatography","level":1,"score":0.0653638243675232},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1016/j.simpa.2023.100588","doi":"https://doi.org/10.1016/j.simpa.2023.100588","is_oa":true,"landing_page_url":"https://doi.org/10.1016/j.simpa.2023.100588","pdf_url":"http://www.softwareimpacts.com/article/S2665963823001252/pdf","source":{"id":"https://openalex.org/S4210180398","display_name":"Software Impacts","issn_l":"2665-9638","issn":["2665-9638"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-d","jufo-1","norway-1","poland-20","vabb-shw"],"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Software Impacts","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1016/j.simpa.2023.100588","doi":"https://doi.org/10.1016/j.simpa.2023.100588","is_oa":true,"landing_page_url":"https://doi.org/10.1016/j.simpa.2023.100588","pdf_url":"http://www.softwareimpacts.com/article/S2665963823001252/pdf","source":{"id":"https://openalex.org/S4210180398","display_name":"Software Impacts","issn_l":"2665-9638","issn":["2665-9638"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-d","jufo-1","norway-1","poland-20","vabb-shw"],"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Software Impacts","raw_type":"journal-article"},"sustainable_development_goals":[],"sustainable_development_goals_aurora":[],"study_designs":[],"awards":[{"id":"https://openalex.org/G3450082450","display_name":"Centrum f\u00fcr Chronische Immundefizienz (CCI)","funder_award_id":"01EO1303","funder_id":"https://openalex.org/F4320321114","funder_display_name":"Bundesministerium f\u00fcr Bildung und Forschung"},{"id":"https://openalex.org/G3900745063","display_name":"DIFUTURE - Medizininformatik-Konsortium - Teilvorhaben: Konsolidierung und Interoperabilit\u00e4t: TU M\u00fcnchen","funder_award_id":"01ZZ2304A","funder_id":"https://openalex.org/F4320321114","funder_display_name":"Bundesministerium f\u00fcr Bildung und Forschung"},{"id":"https://openalex.org/G5276359075","display_name":null,"funder_award_id":"BMBF 01EO1303","funder_id":"https://openalex.org/F4320321114","funder_display_name":"Bundesministerium f\u00fcr Bildung und Forschung"},{"id":"https://openalex.org/G6114708134","display_name":"Verbundprojekt: Deutsches Netzwerk f\u00fcr Prim\u00e4re Immundefekte (PID-NET): TP A3: Genetische und immunologische Variabilit\u00e4t bei Patienten mit Lymphoproliferation und Autoimmunit\u00e4t (ALPS), TP B1: Deutsches nationales Register f\u00fcr Prim\u00e4re Immundefekte.","funder_award_id":"01GM1517C","funder_id":"https://openalex.org/F4320321114","funder_display_name":"Bundesministerium f\u00fcr Bildung und Forschung"},{"id":"https://openalex.org/G750904052","display_name":"Netzwerk Universit\u00e4tsmedizin: Zweite F\u00f6rderphase","funder_award_id":"01KX2121","funder_id":"https://openalex.org/F4320321114","funder_display_name":"Bundesministerium f\u00fcr Bildung und Forschung"}],"funders":[{"id":"https://openalex.org/F4320321114","display_name":"Bundesministerium f\u00fcr Bildung und Forschung","ror":"https://ror.org/04pz7b180"},{"id":"https://openalex.org/F4320326494","display_name":"Bundesministerium f\u00fcr Bildung, Wissenschaft, Forschung und Technologie","ror":null},{"id":"https://openalex.org/F4320332004","display_name":"European Society for Immunodeficiencies","ror":"https://ror.org/00qr00h56"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4387614448.pdf","grobid_xml":"https://content.openalex.org/works/W4387614448.grobid-xml"},"referenced_works_count":11,"referenced_works":["https://openalex.org/W641258496","https://openalex.org/W2065019996","https://openalex.org/W2086906616","https://openalex.org/W2613543409","https://openalex.org/W2792908940","https://openalex.org/W2886940188","https://openalex.org/W2914208637","https://openalex.org/W2955588459","https://openalex.org/W4220834637","https://openalex.org/W4301217393","https://openalex.org/W4382405220"],"related_works":["https://openalex.org/W2068608913","https://openalex.org/W3124914020","https://openalex.org/W2141033859","https://openalex.org/W2077542787","https://openalex.org/W2156434174","https://openalex.org/W2071701083","https://openalex.org/W2383687187","https://openalex.org/W2070401501","https://openalex.org/W2121496884","https://openalex.org/W2387910809"],"abstract_inverted_index":{"Data":[0],"extraction,":[1],"visualization":[2],"and":[3],"distribution":[4],"is":[5,60],"an":[6],"important":[7],"task":[8],"in":[9,50,62],"the":[10,19],"daily":[11],"work":[12],"of":[13],"a":[14,38,51,65,73,77],"database":[15,45],"management":[16],"team.":[17],"In":[18],"medical":[20],"field":[21],"requests":[22],"are":[23],"often":[24],"made":[25],"by":[26],"researchers":[27],"who":[28],"use":[29],"spreadsheet":[30,53],"programs":[31],"such":[32],"as":[33],"Excel.":[34],"Thus,":[35],"we":[36,69],"developed":[37],"framework":[39],"which":[40,54],"allows":[41],"us":[42],"to":[43,76],"extract":[44],"tables":[46],"with":[47],"1:N":[48],"relations":[49],"sparse":[52],"prevents":[55],"redundant":[56],"information.":[57],"The":[58],"Framework":[59],"implemented":[61],"PHP":[63],"using":[64],"JSON":[66],"interface.":[67],"Further,":[68],"offer":[70],"connectors":[71],"for":[72],"direct":[74],"connection":[75],"Postgres":[78],"database.":[79]},"counts_by_year":[],"updated_date":"2026-10-16T09:59:22.235173","created_date":"2025-10-10T00:00:00"}