Data Analytics
Data Engineering
Importing Content
Oct 22, 2024
Naveed Noushad
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.
Verify each field/column in your CSV has a matching field in your CMS collection with the same name.
Include a unique field for each item, often named "Slug"
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.
Let’s Talk Data
Strategy!
Get in touch with our data strategy experts to review your data struggles and help map out steps to achieve data-driven decision making.
Request A Call
Get in touch with our team to solve your queries.
US Office
160 Bovet Road, Suite # 101,
San Mateo, CA 94402 USA
Pleasanton, California – 6701 Koll Center Parkway, #250 Pleasanton, CA 94566
Tel: +1 408 365 4638
Support: +1 (408) 512 1812
UAE OFFICE
Dubai, UAE – Dubai Internet City, 1st Floor, Building Number 12, Premises ED 29, Dubai, UAE
Tel: +971-55-6540154
Tel: +971-04-2505173
UK OFFICE
Export House, Cawsey Way, Woking Surrey, GU21 6QX
Tel: +44 (0) 14 8361 6611
Mexico Office
EPICENTRIA, Avenida Netzahualcóyotl 1597, Ciudad del Sol, Zapopan, Jalisco
Pakistan Office
Plot 26, Block B, SMCH Society, Main Shahrah-e-Faisal, Karachi
Corporate 7 by Maaksons, Executive Block, Civic Center 1, Gulberg Green, Islamabad
First Floor, Blue Mall 8-R, MM Alam Road Gulberg III, Lahore
Tel: +92-21-3432 3721-4
Canada Office
2 – 105 CONSUMERS DRM.
WHITBY ON L1N 1C4
Tel: +1 408 365 4638
Support: +1 (408) 512 1812
Bulgaria Office
49 Bacho Kiro Street, Sofia, 1000, Bulgaria
© 2024, Folio3 Software Inc., All rights reserved.
Privacy Policy & Terms of Use Cookie Policy