Can You Copy Gathercontent Templates

Import content from a spreadsheet

Apace populate your projection with content by importing it from a CSV, XLSX, XLS or ODS file.

Written by Bruno Wilson
Updated over a week ago

This commodity explains how to import content from a spreadsheet into GatherContent.

Required spreadsheet structure for import
Supported import file formats
How to import content from a spreadsheet
Frequently asked questions

Required spreadsheet structure for import

Your content should be in the post-obit format to import into GatherContent.

each row in your spreadsheet is an particular - and so row one should contain item names
each column in your spreadsheet is a field in the item - so column 1 should contain field titles. These volition appear on the template as field labels in one case imported
For each template, you want to import content for, use a different sheet in the spreadsheet - and so sheet ane would contain content with 6 columns (6 fields), and sheet 2 contains content with 10 columns (10 fields).
This does not work for CSV files - please utilise XLSX.

Tip: If you've exported content as a CSV or XLSX file from GatherContent, you lot can upload the output directly on the 'Import' tab 👍

Supported import file formats

You tin import CSV, XLSX, XLS and ODS files. Any import spreadsheet should be plain text to enable a seamless import.

Import content from a spreadsheet

one. Click the 'Migrate' tab in the project you want to import into.

2. Select the 'Import' tab.
3. Drag the spreadsheet into the upload space shown. Y'all tin also click on the upload box to select a file from your file computer.

4. Click 'Import X items' when y'all meet the 'Ready to import' message.

This volition then import all the items from the spreadsheet. When y'all're running a large import, this may accept some fourth dimension.

5. Head to the 'Content' tab

This is where you lot'll come across the imported items. If you leave the import screen, the import will continue to run in the background.

All imported items will take an 'auto template' structure applied to them, which contains the date and time of upload. This is created by GatherContent, based on the number of columns containing content in the import spreadsheet.

Edit the 'Motorcar template' once you have completed the import, to rename and add extra fields if needed. This volition become the template you manage in GatherContent for these items 👍

Oft asked questions

I'm having trouble with odd character encoding when importing?
Salve your spreadsheet as an XLS file and try the import again.

How exercise I turn my 'Auto template' into a template?
All imported items will have an 'Auto template' applied. Care for this 'Auto template' like a normal template that you'd create manually from the Templates tab.

Edit the 'Auto template' by renaming information technology to the template proper name of your selection. Besides, edit the field labels and add instructions text to the fields.

The number of items on the 'fix to import' screen doesn't lucifer the number of items in my spreadsheet.
Applied formatting may be interfering with the spreadsheet structure existence read correctly. Please copy the spreadsheet content into a new spreadsheet, and paste it as 'values' or 'plain text'. Endeavor re-uploading the newly saved version.
Has the import finished? It's still loading and hasn't updated the page.
This could mean the import hasn't worked for a variety of reasons. Things to check are:

If y'all've got any jail cell references in your spreadsheet, this may be blocking the import. Copy and paste your spreadsheet values equally plain text (values merely) and endeavor importing this version.

Still, having problem importing your content from a spreadsheet? Please arrive touch with us using the blue chimera at the bottom right-hand corner inside GatherContent.