Go Back
CSV to Excel File Conversion
Publisher
: Lingk
Run In Lingk
Description
This recipe converts an CSV file to Excel. To use this recipe, upload the file into the Local File connector for your Environment.
Browse the knowledge base
Twitter
E-Mail
# _____ _ _____ __ # | __ \ (_) |_ _| / _| # | |__) |___ ___ _ _ __ ___ | | _ __ | |_ ___ # | _ // _ \/ __| | '_ \ / _ \ | | | '_ \| _/ _ \ # | | \ \ __/ (__| | |_) | __/ _| |_| | | | || (_) | # |_| \_\___|\___|_| .__/ \___| |_____|_| |_|_| \___/ # | | # |_| # Project Name - CSV TO EXCEL FILE CONVERSION # Recipe ID - # Recipe URL - https://app.lingk.io/a/10932/tf/17959 # Description - # To use this recipe, upload the file into the Local File connector for your Environment # Industry - Higher Ed # Business Process - Graduate Reporting # Systems - Lingk # Connectors - LocalFile # Data Flows - Single Direction # Connection Type - CSV to Excel # 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 connectors ###### - name: sampleFile type: localFileReader format: csvFormat properties: fileName: "rows_100k.csv" - name: convertedFile type: localFileWriter format: excelFormat properties: fileName: "rows_100k_converted.xlsx" ###### End - LocalFile connectors ###### # ______ _ # | ____| | | # | |__ ___ _ __ _ __ ___ __ _| |_ ___ # | __/ _ \| '__| '_ ` _ \ / _` | __/ __| # | | | (_) | | | | | | | | (_| | |_\__ \ # |_| \___/|_| |_| |_| |_|\__,_|\__|___/ # FORMATS specify how files should be processed as they are being read or written to readFormats: - name: csvFormat type: delimited properties: quoteAllFields: true delimiter: ',' header: true writerFormats: - name: excelFormat type: excel properties: worksheets: "data" useHeader: "true" # _____ _ _ _ # / ____| | | | | | # | (___ | |_ __ _| |_ ___ _ __ ___ ___ _ __ | |_ ___ # \___ \| __/ _` | __/ _ \ '_ ` _ \ / _ \ '_ \| __/ __| # ____) | || (_| | || __/ | | | | | __/ | | | |_\__ \ # |_____/ \__\__,_|\__\___|_| |_| |_|\___|_| |_|\__|___/ # 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 - statement: (selected40000) => select * from sampleFile LIMIT 40000 - statement: (dataCount) => select count(*) from selected40000 #- statement: print dataCount - statement: INSERT selected40000 INTO convertedFile # Add more statements to convert, join, aggregrate, transform, and integrate your data
CSV to JSON File Conversion
CSV File Reader