Import data from CSV

Bring content from any source and add it to your Framer site.

Bring content from any source and add it to your Framer site.

This article will teach you the basics of how to prepare your content for importing, how to import your content, and things to look out for.

How to Import

  1. Prepare your CSV file

  2. Prepare your CMS Collection

  3. Import your CSV file

Prepare your CSV file

Make sure your file is exported as a “CSV” file, also known as a “Comma Separated Values” file. If you encounter any issues you'll want to verify your file is UTF-8 encoded and less than 5mb. If your file is larger than that, try removing columns you may not need. See below for additional information on specific fields.

Tip: You do not have to import every column from your CSV. Only fields set up in your CMS collection in the next step will be imported.

Rich Text Fields

Formatted text content needs to be formatted as HTML. Many tags are supported, such as paragraphs and headers <p>,<h1>, <h2>), formatting (<em>, <i>, <strong>), links (<a>), lists (<ol>, <ul>, <li>) and images (<img>). Images from URLs will be automatically downloaded from their original source and imported into Framer.

Image Fields

Images in your CSV content must be URLs to an image. They will be downloaded and imported into Framer. Relative paths are not supported.

Date Fields

Recommended format is ISO8601 compliant, for example: 2023-12-17T14:42:00. The shorthand value of year-month-day is also supported, for example: 1982-12-01. Long format strings may work, but will depend on your browser, for example: Tue May 12 2020 18:50:21 GMT-0500 (Central Daylight Time). All time data, including time zone information, will be stripped from the date.

Color Fields

A color formatted as CSS hexadecimal RGB code, rgb, hls or hlv expression, or a named color. All variants with an alpha value are also supported. Examples: #00ffee, rgb(0, 153, 255), hsla(204, 100%, 50%, 0.5), blue, darkgreen, rebeccapurple.

Toggle Fields

A boolean value. Y, yes, TRUE, 1 will be interpreted as the toggle being “Yes”, all other values will be “No”. 

Prepare your CMS Collection

Here is a checklist to prepare your CMS collection for importing.

  1. Verify each field/column in your CSV has a matching field in your CMS collection with the same name.

  2. Include a unique field for each item, often named “Slug”

  3. Verify that your data types match (eg. a CMS Date field for a date field in your data)

Tip: Framer uses your Slug field to identify each item, and will use it to update that item with repeat imports.

Import your CSV file

You can find the Import feature by going to the CMS in your project, and clicking “Import” in the toolbar. From there, you can select your CSV file for importing. You may also drag & drop your CSV file directly into the CMS collection interface.

Tip: Importing supports Undo / Redo actions. If you’re not happy with the import, you can simply undo the change with CMD+Z on MacOS or CTRL + Z on Windows. Redo will not re-run the import, but instantly apply the changes to the collection.

Updating or Re-Importing

To update your content, you can import into the same collection again. If any item in the new import has a slug field that matches one of the items in your collection, you will be able to update it or skip importing it again.

FAQ

What content is imported?

  • Rich Text Content (Text, Images, Formatting, Lists, Links)

  • Plain Text Fields

  • Date Fields

  • Image Fields

  • Color Fields

  • Link Fields

  • Number Fields

  • Toggle (Boolean) Fields


What content is not imported?

  • Multi-Image Fields

  • Inline Code

  • Code Blocks

  • Embeds

  • Media

  • Styles

  • Custom CSS