Export & Import
Lido provides action formulas for exporting spreadsheet data to external files and importing data from external sources.
Export
EXPORTWORKSHEETSASEXCEL
Exports one or more worksheets as an Excel file.
Syntax:
=EXPORTWORKSHEETSASEXCEL(worksheet_names, destination)
=EXPORTWORKSHEETSASEXCEL(worksheet_names, destination, status_ref)
Parameters:
| Parameter | Description | Required |
|---|---|---|
worksheet_names | Name(s) of worksheets to export | Yes |
destination | Destination folder URL | Yes |
status_ref | Cell reference to write status | No |
EXPORTWORKSHEETASCSV
Exports a worksheet as a CSV file.
Syntax:
=EXPORTWORKSHEETASCSV(worksheet_name, destination)
=EXPORTWORKSHEETASCSV(worksheet_name, destination, status_ref)
Parameters:
| Parameter | Description | Required |
|---|---|---|
worksheet_name | Name of the worksheet to export | Yes |
destination | Destination folder URL | Yes |
status_ref | Cell reference to write status | No |
EXPORTASCSV
Exports data directly as a CSV file.
Syntax:
=EXPORTASCSV(data, destination)
=EXPORTASCSV(data, destination, status_ref)
Parameters:
| Parameter | Description | Required |
|---|---|---|
data | Data to export | Yes |
destination | Destination folder URL | Yes |
status_ref | Cell reference to write status | No |
EXPORTASFILE
Exports data as a file.
Syntax:
=EXPORTASFILE(data, destination)
=EXPORTASFILE(data, destination, status_ref)
Parameters:
| Parameter | Description | Required |
|---|---|---|
data | Data to export | Yes |
destination | Destination folder URL | Yes |
status_ref | Cell reference to write status | No |
APPENDTOGOOGLESHEET
Appends rows to a Google Sheet.
Syntax:
=APPENDTOGOOGLESHEET(credential, sheet_id, values)
=APPENDTOGOOGLESHEET(credential, sheet_id, values, status_ref)
Parameters:
| Parameter | Description | Required |
|---|---|---|
credential | Google credential ID | Yes |
sheet_id | Google Sheet ID or URL | Yes |
values | Data to append | Yes |
status_ref | Cell reference to write status | No |
UPDATECELLINGOOGLESHEET
Updates a cell in an external Google Sheet.
Syntax:
=UPDATECELLINGOOGLESHEET(credential, spreadsheet_id, range, value)
=UPDATECELLINGOOGLESHEET(credential, spreadsheet_id, range, value, status_ref)
Parameters:
| Parameter | Description | Required |
|---|---|---|
credential | Google credential ID | Yes |
spreadsheet_id | Google Sheet ID or URL | Yes |
range | Cell range to update (e.g., "Sheet1!A1") | Yes |
value | Value to write | Yes |
status_ref | Cell reference to write status | No |
Import
IMPORTGOOGLESHEET
Imports data from a Google Sheet.
Syntax:
=IMPORTGOOGLESHEET(credential, sheet_id, range, output_ref)
=IMPORTGOOGLESHEET(credential, sheet_id, range, output_ref, status_ref)
Parameters:
| Parameter | Description | Required |
|---|---|---|
credential | Google credential ID | Yes |
sheet_id | Google Sheet ID or URL | Yes |
range | Cell range to import (e.g., "Sheet1!A1:D10") | Yes |
output_ref | Cell reference to write the imported data | Yes |
status_ref | Cell reference to write status | No |
IMPORTEXCELWORKSHEET
Imports data from an Excel file.
Syntax:
=IMPORTEXCELWORKSHEET(credential, source_id, worksheet_name, output_ref)
=IMPORTEXCELWORKSHEET(credential, source_id, worksheet_name, output_ref, status_ref)
Parameters:
| Parameter | Description | Required |
|---|---|---|
credential | Credential ID | Yes |
source_id | File source identifier | Yes |
worksheet_name | Name of the worksheet to import | Yes |
output_ref | Cell reference to write the imported data | Yes |
status_ref | Cell reference to write status | No |
IMPORTJSON
Imports data from a JSON source.
Syntax:
=IMPORTJSON(credential, source_id)
=IMPORTJSON(credential, source_id, output_ref, status_ref)
Parameters:
| Parameter | Description | Required |
|---|---|---|
credential | Credential ID | Yes |
source_id | JSON source identifier | Yes |
output_ref | Cell reference to write the imported data | No |
status_ref | Cell reference to write status | No |