{"id":"https://openalex.org/W7126415841","doi":"https://doi.org/10.18653/v1/2024.findings-eacl.158","title":"NL2Formula: Generating Spreadsheet Formulas from Natural Language Queries","display_name":"NL2Formula: Generating Spreadsheet Formulas from Natural Language Queries","publication_year":2024,"publication_date":"2024-01-01","ids":{"openalex":"https://openalex.org/W7126415841","doi":"https://doi.org/10.18653/v1/2024.findings-eacl.158"},"language":"en","primary_location":{"id":"doi:10.18653/v1/2024.findings-eacl.158","doi":"https://doi.org/10.18653/v1/2024.findings-eacl.158","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/2024.findings-eacl.158","pdf_url":"https://aclanthology.org/2024.findings-eacl.158.pdf","source":{"id":"https://openalex.org/S7407087051","display_name":"Findings of the Association for Computational Linguistics: EACL","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Findings of the Association for Computational Linguistics: EACL 2024","raw_type":"proceedings-article"},"volume":null,"type":"conference-paper","indexed_in":["arxiv","crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://aclanthology.org/2024.findings-eacl.158.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5124607864","display_name":"Wei Zhao","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I47720641","display_name":"Huazhong University of Science and Technology","ror":"https://ror.org/00p991c53","country_code":"CN","type":"education","lineage":["https://openalex.org/I47720641"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Wei Zhao","raw_affiliation_strings":["Huazhong University of Science and Technology ,"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Huazhong University of Science and Technology ,","institution_ids":["https://openalex.org/I47720641"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5025165533","display_name":"Zhitao Hou","orcid":"https://orcid.org/0000-0002-5335-748X","observed_orcids":["https://orcid.org/0000-0002-5335-748X"]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zhitao Hou","raw_affiliation_strings":["Microsoft"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5124470630","display_name":"Siyuan Wu","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I47720641","display_name":"Huazhong University of Science and Technology","ror":"https://ror.org/00p991c53","country_code":"CN","type":"education","lineage":["https://openalex.org/I47720641"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Siyuan Wu","raw_affiliation_strings":["Huazhong University of Science and Technology ,"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Huazhong University of Science and Technology ,","institution_ids":["https://openalex.org/I47720641"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5139781137","display_name":"Yan Gao","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yan Gao","raw_affiliation_strings":["Microsoft"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5042086739","display_name":"Haoyu Dong","orcid":"https://orcid.org/0000-0002-5132-0341","observed_orcids":["https://orcid.org/0000-0002-5132-0341"]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Haoyu Dong","raw_affiliation_strings":["Microsoft"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101555948","display_name":"Yao Wan","orcid":"https://orcid.org/0000-0001-6937-4180","observed_orcids":["https://orcid.org/0000-0001-6937-4180"]},"institutions":[{"id":"https://openalex.org/I47720641","display_name":"Huazhong University of Science and Technology","ror":"https://ror.org/00p991c53","country_code":"CN","type":"education","lineage":["https://openalex.org/I47720641"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yao Wan","raw_affiliation_strings":["Huazhong University of Science and Technology ,"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Huazhong University of Science and Technology ,","institution_ids":["https://openalex.org/I47720641"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5124532998","display_name":"Hongyu Zhang","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]},{"id":"https://openalex.org/I158842170","display_name":"Chongqing University","ror":"https://ror.org/023rhb549","country_code":"CN","type":"education","lineage":["https://openalex.org/I158842170"]}],"countries":["CN","US"],"is_corresponding":false,"raw_author_name":"Hongyu Zhang","raw_affiliation_strings":["Chongqing University ,","Microsoft"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Chongqing University ,","institution_ids":["https://openalex.org/I158842170"]},{"raw_affiliation_string":"Microsoft","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5053058502","display_name":"Yulei Sui","orcid":"https://orcid.org/0000-0002-9510-6574","observed_orcids":["https://orcid.org/0000-0002-9510-6574"]},"institutions":[{"id":"https://openalex.org/I31746571","display_name":"UNSW Sydney","ror":"https://ror.org/03r8z3t63","country_code":"AU","type":"education","lineage":["https://openalex.org/I31746571"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Yulei Sui","raw_affiliation_strings":["University of New South Wales"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of New South Wales","institution_ids":["https://openalex.org/I31746571"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5124654951","display_name":"Haidong Zhang","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]},{"id":"https://openalex.org/I158842170","display_name":"Chongqing University","ror":"https://ror.org/023rhb549","country_code":"CN","type":"education","lineage":["https://openalex.org/I158842170"]}],"countries":["CN","US"],"is_corresponding":false,"raw_author_name":"Haidong Zhang","raw_affiliation_strings":["Chongqing University ,","Microsoft"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Chongqing University ,","institution_ids":["https://openalex.org/I158842170"]},{"raw_affiliation_string":"Microsoft","institution_ids":["https://openalex.org/I1290206253"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.273,"has_fulltext":true,"cited_by_count":1,"citation_normalized_percentile":{"value":0.61246418,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":93,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"2377","last_page":"2388"},"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.8676999807357788,"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.8676999807357788,"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/T10181","display_name":"Natural Language Processing Techniques","score":0.0471000000834465,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T10028","display_name":"Topic Modeling","score":0.04280000180006027,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/natural-language-questions","display_name":"natural language queries","score":0.9049999713897705},{"id":"https://openalex.org/keywords/sequence-to-sequence-models","display_name":"sequence-to-sequence models","score":0.859000027179718},{"id":"https://openalex.org/keywords/spreadsheet-analysis","display_name":"spreadsheet analysis","score":0.5350000262260437},{"id":"https://openalex.org/keywords/error-analysis","display_name":"error analysis","score":0.8569999933242798}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7110999822616577},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.4471000134944916},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.41920000314712524},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.40220001339912415},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.4016999900341034},{"id":"https://openalex.org/C2776608160","wikidata":"https://www.wikidata.org/wiki/Q4785462","display_name":"Natural (archaeology)","level":2,"score":0.2948000133037567},{"id":"https://openalex.org/C2776401178","wikidata":"https://www.wikidata.org/wiki/Q12050496","display_name":"Feature (linguistics)","level":2,"score":0.26600000262260437},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.24639999866485596},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.23190000653266907},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.23100000619888306}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.18653/v1/2024.findings-eacl.158","doi":"https://doi.org/10.18653/v1/2024.findings-eacl.158","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/2024.findings-eacl.158","pdf_url":"https://aclanthology.org/2024.findings-eacl.158.pdf","source":{"id":"https://openalex.org/S7407087051","display_name":"Findings of the Association for Computational Linguistics: EACL","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Findings of the Association for Computational Linguistics: EACL 2024","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:2402.14853","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/2402.14853","pdf_url":"https://arxiv.org/pdf/2402.14853","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"doi:10.48550/arxiv.2402.14853","doi":"https://doi.org/10.48550/arxiv.2402.14853","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2402.14853","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"}],"best_oa_location":{"id":"doi:10.18653/v1/2024.findings-eacl.158","doi":"https://doi.org/10.18653/v1/2024.findings-eacl.158","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/2024.findings-eacl.158","pdf_url":"https://aclanthology.org/2024.findings-eacl.158.pdf","source":{"id":"https://openalex.org/S7407087051","display_name":"Findings of the Association for Computational Linguistics: EACL","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Findings of the Association for Computational Linguistics: EACL 2024","raw_type":"proceedings-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[{"id":"https://openalex.org/G8363725921","display_name":null,"funder_award_id":"62102157","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W7126415841.pdf","grobid_xml":"https://content.openalex.org/works/W7126415841.grobid-xml"},"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W7166886286","https://openalex.org/W4399156370","https://openalex.org/W7131856896","https://openalex.org/W7223022820","https://openalex.org/W4393160017","https://openalex.org/W7168042935","https://openalex.org/W3126805032","https://openalex.org/W4387929179","https://openalex.org/W6920795264","https://openalex.org/W4416617103"],"abstract_inverted_index":{"Writing":[0],"formulas":[1,21,62],"on":[2,22,66],"spreadsheets,":[3],"such":[4],"as":[5,76],"Microsoft":[6],"Excel":[7],"and":[8,27,91,98,157],"Google":[9],"Sheets,":[10],"is":[11],"a":[12,25,50,67,71,82,110],"widespread":[13],"practice":[14],"among":[15],"users":[16],"performing":[17],"data":[18],"analysis.However,":[19],"crafting":[20],"spreadsheets":[23],"remains":[24],"tedious":[26],"error-prone":[28],"task":[29,53,107,156],"for":[30,159],"many":[31],"end-users,":[32],"particularly":[33],"when":[34],"dealing":[35],"with":[36,43,56,138],"complex":[37],"operations.To":[38],"alleviate":[39],"the":[40,57,105,119,130,154],"burden":[41],"associated":[42],"writing":[44],"spreadsheet":[45,68,93],"formulas,":[46,94],"this":[47],"paper":[48],"introduces":[49],"novel":[51],"benchmark":[52],"called":[54,114],"NL2FORMULA,":[55],"aim":[58],"to":[59,129],"generate":[60],"executable":[61],"that":[63],"are":[64],"grounded":[65],"table,":[69],"given":[70],"Natural":[72],"Language":[73],"(NL)":[74],"query":[75],"input.To":[77],"accomplish":[78],"this,":[79],"we":[80,133,149],"construct":[81],"comprehensive":[83],"dataset":[84],"consisting":[85],"of":[86,101,121],"70,799":[87],"paired":[88],"NL":[89],"queries":[90],"corresponding":[92],"covering":[95],"21,670":[96],"tables":[97],"37":[99],"types":[100],"formula":[102],"functions.We":[103],"realize":[104],"NL2FORMULA":[106,155],"by":[108],"providing":[109],"sequence-to-sequence":[111],"baseline":[112,131],"implementation":[113],"f":[115,122,136],"CODER.Experimental":[116],"results":[117],"validate":[118],"effectiveness":[120],"CODER,":[123],"demonstrating":[124],"its":[125],"superior":[126],"performance":[127],"compared":[128],"models.Furthermore,":[132],"also":[134],"compare":[135],"CODER":[137],"an":[139],"initial":[140],"GPT-3.5":[141],"model":[142],"(i.e.,":[143],"text-davinci-003).Lastly,":[144],"through":[145],"indepth":[146],"error":[147],"analysis,":[148],"identify":[150],"potential":[151],"challenges":[152],"in":[153],"advocate":[158],"further":[160],"investigation.":[161],"1":[162]},"counts_by_year":[{"year":2026,"cited_by_count":1}],"updated_date":"2026-10-12T09:40:04.860316","created_date":"2026-02-02T00:00:00"}