Go Back
Excel to JSON Conversion
Publisher
: Lingk
Run In Lingk
Description
This recipe converts an Excel file to JSON. To use this recipe, upload the file into the Local File connector for your Environment
Browse the knowledge base
Twitter
E-Mail
# _____ _ _____ __ # | __ \ (_) |_ _| / _| # | |__) |___ ___ _ _ __ ___ | | _ __ | |_ ___ # | _ // _ \/ __| | '_ \ / _ \ | | | '_ \| _/ _ \ # | | \ \ __/ (__| | |_) | __/ _| |_| | | | || (_) | # |_| \_\___|\___|_| .__/ \___| |_____|_| |_|_| \___/ # | | # |_| # Project Name - EXCEL TO JSON CONVERSION # Recipe URL - https://app.lingk.io/a/10932/tf/17860 # Description - # This recipe converts an Excel file to JSON. # To use this recipe, upload the file into the Local File connector for your Environment # Industry - Higher Ed # Business Process - Graduate Reporting # Systems - # Connectors - LocalFile # Data Flows - Single Direction # Connection Type - excel to JSON # Add Recipe notes / Change log information here! # _____ _ # / ____| | | # | | ___ _ __ _ __ ___ ___| |_ ___ _ __ ___ # | | / _ \| '_ \| '_ \ / _ \/ __| __/ _ \| '__/ __| # | |___| (_) | | | | | | | __/ (__| || (_) | | \__ \ # \_____\___/|_| |_|_| |_|\___|\___|\__\___/|_| |___/ # # CONNECTORS specify what data will be pulled into the in-memory database during processing connectors: # Configure LocalFile credentials in your Environment before running this recipe # LocalFile Setup - https://help.lingk.io/en/articles/126-local-file-connector-reference ###### Start: LocalFile Reader Connectors ####### - name: sampleFile type: localFileReader format: excelFormat properties: fileName: "rows_66k.xlsx" ###### End: LocalFile Reader Connectors ####### ###### Start: LocalFile Writer Connectors ####### - name: convertedFile type: localFileWriter format: jsonFormat properties: fileName: "rows_66k_converted.jsonl" ###### End: LocalFile Writer Connectors ####### # ______ _ # | ____| | | # | |__ ___ _ __ _ __ ___ __ _| |_ ___ # | __/ _ \| '__| '_ ` _ \ / _` | __/ __| # | | | (_) | | | | | | | | (_| | |_\__ \ # |_| \___/|_| |_| |_| |_|\__,_|\__|___/ # FORMATS specify how files should be processed as they are being read or written to readFormats: - name: excelFormat type: excel properties: worksheets: "data" useHeader: "true" writeFormats: - name: jsonFormat type: json # _____ _ _ _ # / ____| | | | | | # | (___ | |_ __ _| |_ ___ _ __ ___ ___ _ __ | |_ ___ # \___ \| __/ _` | __/ _ \ '_ ` _ \ / _ \ '_ \| __/ __| # ____) | || (_| | || __/ | | | | | __/ | | | |_\__ \ # |_____/ \__\__,_|\__\___|_| |_| |_|\___|_| |_|\__|___/ # STATEMENTS specify how the data should be processed while in memory statements: #******************************************************************** D I S C L A I M E R *********************************************************************************************** # * # Note that in an effort to keep recipes optimized for DPH (Data Processing Hours), print statements should be commented out after development has concluded for a recipe. * # For more information on DPH optimization, please visit the following help article - https://help.lingk.io/en/articles/212-minimizing-data-processing-hours-on-the-lingk-platform * # * #******************************************************************** D I S C L A I M E R *********************************************************************************************** - statement: (data) => select * from sampleFile #- statement: print data # JSON CONVERSION TIP: You can use functions like struct() and named_struct() to define any JSON output structure - statement: (dataCount) => select count(*) from sampleFile #- statement: print dataCount - statement: (dataCount) => select count(*) from sampleFile #- statement: print dataCount - statement: INSERT sampleFile INTO convertedFile # Add more statements to convert, join, aggregrate, transform, and integrate your data
Join Multiple Excel Spreadsheets and Output Excel
Public Location Data Set Browser with Distance Calculation