Skip to main content

Klips: How do I upload spreadsheet files for data sources and custom Klips?

Updated

In Klipfolio Klips, you can upload spreadsheet files and create data sources that are used to power your custom Klips.

This article includes:

Note:

  • Supported file types and sizes: We support Excel, CSV, JSON, and XML file formats and a 10MB maximum file size.
  • Modifying your spreadsheet data in Klips doesn't change your original spreadsheet source data.

Creating a data source using an uploaded file

To create a data source using an uploaded file:

  1. Click Data Sources in the left navigation bar.
    If you don’t see this option, go to the bottom of the left navigation sidebar and click your Account Name > Data Sources instead.
  2. Click Create a New Data Source and select File Upload.
  3. Click Choose File and select a file to upload.
  4. Click Get data.
  5. Ensure this is the data you’re looking for. Optionally select the checkbox to Model your data. Learn more about modelling data sources.
  6. Click Continue.
  7. Name, choose refresh settings, and, optionally, share your data source.
  8. Click Save.

The data source is added to your account and is ready to use for custom Klips. You can see all your data sources in your Data Source Library, accessed by clicking Data Sources in the left navigation sidebar.

Updating an uploaded data source

If you modify the local file and want to update the data source (and its associated custom Klips) to reflect your changes, you'll need to overwrite the version you previously uploaded.

Note: When you make changes to data that's stored on the cloud (for example, data in Google Drive) the connected data sources are refreshed automatically.

To update an uploaded data source:

  1. Click Data Sources in the left navigation bar to open your list of data sources.
    If you don’t see this option, go to the bottom of the left navigation sidebar and click your Account Name > Data Sources instead.
  2. From your list of data sources, select the file you want to update.
    Note: You must select a raw data source, not a modelled data source.
  3. On the About this Data Source page, select Reconfigure Connection or Re-Upload Now.

  1. Click Reconfigure Connection, click Reconfigure.
  2. Click Choose File and select a file to upload.
  3. Click Get data.
  4. Ensure this is the data you’re looking for, then click Done.

Want to learn more?

Check out these related articles:

Related articles