The Import and Export tool is great for getting bulk data into and out of the Content (area) and Pages (area). It allows for content to be exported and re-imported easily and reliably.&nbsp;

There are two types of formats that you can export: Regular and Translation.

This format will display all your exported website data content where each content type is represented on different Excel Worksheets, similar to database tables.

This format will allow you to easily make translation changes to your copy.

To export content, click on the Export Button:

If exporting for Translation, the TranslatedValue column is where you can enter your copy in a different language, eg. FR. You can then import the formatted excel document into Agility with the newly, translated values.

To begin Importing Content, first export the Content List you would like to work on.

Using your Export, update/enter any new content you would like to add.

NoteThe Agility_ContentID and&nbsp;Agility_ContainerName columns are required for import.

Agility_ContentID&nbsp;- This is the ContentID of an existing item. If you are importing new items, the value can be blank.

Agility_ContainerName&nbsp;- This is the reference name of the list to import into.

Once you have saved your Import and its changes, click on the Import Button:

Select your Import From Language and the&nbsp;Import To Language.

This is the original language from which you are importing from.

This is the language where you are you Importing into.

Choose your file, then click&nbsp;Import:

Importing Content that contains Child Content

Agility offers you the ability to import and export content&nbsp;via&nbsp;Excel, however, it is also important to note that you are&nbsp;also&nbsp;able to&nbsp;import and export&nbsp;child content.&nbsp;Let’s&nbsp;look&nbsp;at how this can be done.&nbsp;

As an example,&nbsp;here is a list of&nbsp;Properties (Content List), that&nbsp;can contain&nbsp;Linked Content to another Content List named Spaces

Under Shared Content, I created 3 new Properties in our Property list:&nbsp;

However, I did not add any Spaces to any of the Properties yet,&nbsp;I'll&nbsp;export these&nbsp;Properties to&nbsp;an Excel file, add Spaces to our Properties, then&nbsp;import back&nbsp;the&nbsp;Excel&nbsp;file.&nbsp;

&nbsp;Click on Export, export for Regular Format, then download the file.&nbsp;When&nbsp;we&nbsp;open&nbsp;the&nbsp;Excel file, we’ll see&nbsp;the information about our Properties:&nbsp;

Some important values to note here would be the ones in our “Spaces”&nbsp;column. This is the&nbsp;Reference Name&nbsp;for&nbsp;our Linked&nbsp;Content&nbsp;and&nbsp;we will use these to attach&nbsp;the&nbsp;Spaces to Properties&nbsp;(i.e.&nbsp;Spaces for the Agility Large Property will use&nbsp;Properties_Spaces&nbsp;and Spaces for the Agility Small Property will use Properties_Spaces39).&nbsp;

We can add a new sheet to this&nbsp;Excel&nbsp;file named “Spaces” and&nbsp;fill out some important information we’ll need to be able to import these spaces and link them to&nbsp;its&nbsp;respective&nbsp;Property:&nbsp;

Agility_ContentID &amp; Agility_VersionID: These do not require values as Agility will populate these upon import.&nbsp;

Agility_LanguageCode: Required Field.&nbsp;

Agility_State:&nbsp;May be set to Staging or Published depending on your&nbsp;use case.&nbsp;

Agility_ContainerName:&nbsp;This will be relating to the&nbsp;important&nbsp;values&nbsp;or “Reference Names”&nbsp;we&nbsp;mentioned&nbsp;earlier:

To add Spaces to the Agility Large Property, we’ll use Properties_Spaces 

To add Spaces to the Agility Medium Property, we’ll use Properties_Spaces38 

&nbsp;Title:&nbsp;This is just a Text Field set up to describe the&nbsp;Space and&nbsp;will be different depending on your use case.&nbsp;

We can save our Properties &amp; Spaces sheets, export it,&nbsp;and head back into the Agility dashboard to import our new data. Head to Properties under Shared&nbsp;Content and&nbsp;import our updated&nbsp;Excel&nbsp;file.&nbsp;

Once complete we can select a Property from our list and see the new Spaces we’ve created and imported:

Overview

This format will display all your exported site content data where each content type is represented on different Excel Worksheets, similar to database tables.

1. First, head to the Content Section of your instance and click on the Content List you'd like to export.

2. Click on the 3 Dot Menu Indicator on the right-hand side and Click Export

To begin Importing Content, first export the Content List you would like to work on (see above).

1. Using your Export, Update/Enter Any New Content you would like to add.

Note

2. Once you have saved your Import and its changes, click on the 3 Dot Menu Indicator again, and this time Click Import

Introduction

Importing and Exporting

System Status

Privacy Policy

GDPR

Security

Glossary

Headless CMS+

Features

For Business

For Developers/IT

For Content Editors

Pricing

Product Roadmap

Product

The Agility Marketplace

Implementation Partners

MACH Alliance Member

Partnership FAQ

Become a Partner

Partners 

Resource Center

Documentation

Blog

Starters

Resources

Editors

Developers

Owners & Admins

Apps

Web Studio is here! An enhanced experience to make it easier to create, preview, and collaborate on your website content<a class="link-line line-purple" href="/product/web-studio" rel="noopener">Learn More</a>

Importing and Exporting

Exporting Content

Regular Format

Translation Format

To Export Content:

Importing Content

Note

Import From

Import To