Avion Knowledge Base
avion.ioSign inSign up
  • 👋Introduction
  • 👉Getting started
    • What is Avion?
    • Define your product backbone
    • Scoping and prioritizing your product
    • Creating your release plan
    • Aligning the team
    • Integrating with backlog tools
  • Docs
    • 👏Core concepts
      • Projects
        • Project team
        • Migrating to projects
      • Organizations
        • Invite a member
        • Remove a member
        • Roles
        • Transfer ownership
        • Configure your path
        • Delete your organization
    • 🚀Story map
      • Story map anatomy
      • Journeys and steps
      • Stories
      • Releases
      • Attachments
      • Tags
      • Personas
      • Labels
      • Dependencies
      • Search and filter
      • Sharing
        • Restricted links
        • Public links
      • Workflow
      • Importing data
        • Import from Excel
          • XLSX import template
        • Import from StoriesOnBoard
      • Exporting data
        • Export to PDF
        • Export to image
        • Export to CSV
        • Export to Excel
      • Rich text editor
        • Keyboard shortcuts
        • Known limitations
      • Keyboard shortcuts
      • Tips
    • 🤝Integrations
      • Backlog tools
        • Set up an integration
          • Authentication
          • Project / board selection
          • Backbone syncing
          • Map story states
          • Additional syncing options
          • Importing data
        • Sync data
          • Pushing
          • Importing
          • Attachments
          • Deleting data
        • Configuration
        • Pause an integration
        • Re-authenticate
        • Remove an integration
        • Maintenance
          • Removing stale webhooks
        • FAQs and troubleshooting
        • Services
          • Jira Cloud
            • Features
            • Set up
            • Permissions required
            • Mapping options
              • Mapping fix versions
            • Epics ~ our thoughts
            • Additional data syncing
              • Mapping custom fields
                • Company-managed projects
                • Team-managed projects
            • Migrating to epic hierarchies
            • Import using JQL
            • FAQs and troubleshooting
              • Required fields
              • Verify webhooks
              • JQL import issues
              • Workflow issues
              • Ghost cards (cards with a dashed border)
              • Limitations
              • Jira Cloud or Jira Server
          • Jira Data Center (Server)
            • Features
            • Set up
              • Creating an application link
            • Permissions required
            • Mapping options
            • Additional data syncing
              • Mapping custom fields
            • Import using JQL
            • FAQs and troubleshooting
              • Required fields
              • Ghost cards (card with a dashed border)
              • Jira Cloud or Jira Server
              • JQL import issues
          • Azure DevOps
            • Features
            • Set up
            • Permissions required
            • Import using WIQL
            • FAQs and troubleshooting
              • Verify webhooks
              • No Azure DevOps accounts were found for your user
              • Problems communicating with Azure DevOps
              • Work items couldn't be imported
              • Show epics in Azure DevOps backlog
              • Import limits
          • Trello
            • Features
            • Set up
            • FAQs and troubleshooting
          • GitHub
            • Features
            • Set up
            • Permissions required
            • FAQs and troubleshooting
              • What types of GitHub Projects are supported?
          • Linear
            • Features
            • Set up
            • Permissions required
            • FAQs and troubleshooting
      • Notifications
        • Slack
          • Set up
          • Configure notification settings
          • Remove Slack
      • Design tools and media
        • Figma
        • Adobe XD
        • Axure
        • Framer X
        • Invision Web & Studio
        • YouTube & Vimeo
      • Embed Avion
        • Confluence
        • Confluence Server
        • Notion
        • Coda
    • 🔒Security
      • Single Sign-On (SSO)
        • Setup & Configure SSO
        • Azure AD
        • Google Workspace
        • Okta
        • OpenID Connect
      • Two-factor authentication (2FA)
    • ❓FAQs
      • Attachment file types
    • 💳Billing
      • Plans and pricing
      • Legacy plans
      • Free trials
      • Billing and payments
      • Change your plan
      • Cancel your plan
      • Refunds
      • Startup, student and educational discount
  • Story Mapping Guides
    • How To Story Map — A Simple Example
    • Advantages of Story Mapping
    • A Recommended Workflow
Powered by GitBook
On this page
  • What data can I import?
  • Preparing your data
  • How does the import template work?
  • How to quickly import user stories
  • Importing your XLSX file
  • Import limits
  • Reference diagram for persona avatars
  1. Docs
  2. Story map
  3. Importing data

Import from Excel

Last updated 1 year ago

What data can I import?

Avion supports importing data from an Excel workbook (XLSX). This is a very powerful import tool that gives you the ability to quickly create and update the following types of data in your story maps:

  • Cards (journeys, steps, and stories)

  • Releases

  • Personas

  • Tags

  • Labels

  • Workflow

Preparing your data

The Excel importer requires that you follow a standardised structure for each object in your story map when getting your data ready for import. Therefore, you must use the latest version of the XLSX import template. We offer both Microsoft Excel and Google Sheets versions of this template and you can get access to these from the link below:

The XLSX import template has separate sheets that each relate to the different types of data you can import. We've prepared an example file here with some sample data to demonstrate:

How does the import template work?

Each individual sheet within the XLSX import template provides you with the ability to mass-create and bulk-update objects within your story map. Each sheet is optional, so you can choose to only import very specific data within each sheet as you see fit. This means you can use the Excel importer to create and / or update any combination of objects as needed.

The Excel importer will analyse your current story map data and compare it with the data provided in your import file when trying to decide whether to create new objects or update existing objects. The matching algorithm is primarily concerned with comparing the names of each object you are importing when trying to identify a potential match. If a name match is found, the object's properties are fully updated with the supplied row of data in your import file.

As a result, the only required fields in each sheet are the Name columns. You can optionally choose to leave everything else empty, and the importer will choose sensible defaults when creating new objects.

Note: When updating existing objects, an empty cell is considered valid and will therefore overwrite its respective property in Avion. For example, an empty description on a matching Release in the import file will remove the description in Avion. If you plan to use the import tool to perform a bulk-update operation, it is recommended to first export your story map to Excel and use that as your import template.

When matching objects with parent relationships, the Excel importer will also compare the names of parent objects too (this specifically relates to steps and stories). Therefore, when using the importer to update existing steps and stories, you must ensure that the parent journey name and parent step name is also correct. Otherwise, new objects will be created instead.

Tip: If you are importing a large dataset into a story map with existing items, you should make sure to export your story map to an Excel file beforehand. This way, you will always have a backup of your data just in case you make a mistake and need to revert. Alternatively, you can also duplicate your story map from the dashboard.

How to quickly import user stories

To import a set of stories, simply populate the Stories sheet within the import template, adding a new row for each new story. You can leave the Parent Journey and Parent Step columns empty and the Excel importer will append an "Excel Import" journey to your story map, with all your new user stories inserted below.

Importing your XLSX file

First, browse to the story map you would like to import data into. Then click on "Import" from the left hand menu:

Then use the following screen to select your XLSX import file and upload:

Import limits

There are restrictions with how many objects you can import at once. Below are the limits for each type of object. If the amount of data exceeds the specified limits, you will need to run multiple imports separately.

Object Type

Import Limit

Journeys

50

Steps

125

Stories

500

Releases

25

Personas

50

Labels

50

Tags

100

Workflow

25

Reference diagram for persona avatars

When creating a new persona via the Excel importer, you must set an avatar by choosing a number from 1–20. You can refer to the below key which will help as a reference guide when trying to decide which number to use.

🚀
XLSX import template
43KB
XLSX Import Template – Example Data.xlsx
Example Import Data