CSV to JSON

A CSV (Comma-Separated Values) file is a type of file used to store tabular data (numbers and text) in plain-text form. It's essentially a basic spreadsheet format without the additional formatting or formulas you'd find in something like a Glide Table, Google Sheet, Excel, or Airtable. CSV files are typically used for data import and export among different software programs.

The CSV integration provides tools to transform CSV data in Glide.

Adding the Integration

To start using the CSV integration, you first need to add it to your project.

• In Glide, click the Settings icon in the upper-right corner.

• Navigate to the Integrations tab and select CSV

• Click the Add button

Using CSV to JSON

The CSV to JSON feature converts CSV values into JSON values. It requires a CSV string value as the input, and will export JSON.

If you have a CSV file, you will first need to upload the file with a file picker component, then parse the CSV data with the Get Webpage Source or Call API feature. You can then use the parsed CSV values as the input for the CSV to JSON feature.

In the Data Editor

1. Open the table where you want to use the CSV to JSON feature.

2. Add a new URL column by clicking the (+) plus symbol to the right of the table. This will store the file URL for CSV files uploaded from the file picker component.

   • New columns added with the plus button will always appear on the right. If you'd like to add a column somewhere else in your data, you can select the dropdown menu on an existing column and choose **Add column right.**You can also click and drag columns to rearrange them.

3. Add a Get Webpage Source column to parse the CSV values from the file. Search for “Get Webpage Source” or navigate to Integrations → Browser → Get Webpage Source.

   • The input for this column should be the URL column you created in step 2, with the CSV file URLs

   • If you prefer to use a Call API column, you can also use the Get method and make the endpoint your uploaded CSV file. This allows for added authentication via API if necessary.

4. Add a CSV to JSON column. Search for “CSV to JSON” or navigate to Integrations → CSV→ CSV to JSON.

5. For the CSV string field, use the Get Webpage Source or Call API column you created in step 3, or enter a custom CSV value string.

In the Layout Editor

1. Before you can use the CSV to JSON action, you’ll need to have a file picker component set up to upload the CSV.

2. Make sure you’ve also set up a Get Webpage Source column to parse the CSV values from the uploaded file.

3. Create a column in the Data Editor to store the JSON result.

4. Select the component you'd like to add the action to. Remember, this must be a component that supports actions.

5. Search for the CSV to JSON action or navigate to Integrations -> CSV -> CSV to JSON.

6. Name the action.

7. Choose an icon.

8. For the CSV string field, select the column that contains the parsed CSV string, or enter a custom CSV value string.

9. For the JSON field, select the column where you want to store the JSON result.

10. Click away to exit the configuration.

In the Workflow Editor

1. Before you can use the CSV to JSON action, you’ll need to have a file picker component set up to upload the CSV.

2. Make sure you’ve also set up a Get Webpage Source column to parse the CSV values from the uploaded file.

3. Create a column in the Data Editor to store the JSON result.

4. Search for the CSV to JSON action or navigate to Integrations -> CSV -> CSV to JSON.

5. Name the action.

6. Choose an icon.

7. For the CSV string field, select the column that contains the parsed CSV string, or enter a custom CSV value string.

8. For the JSON field, select the column where you want to store the JSON result.

9. Click away to exit the configuration.