Kumu
  • Getting started
    • Welcome
    • Kumu 101
    • First steps
    • Quick tips
    • Webinars
  • Overview
    • Kumu's architecture
    • Accounts and workspaces
    • Kumu.io and Kumu Enterprise
    • Billing
    • User interfaces
      • Dashboard
      • Settings
      • Map editor
      • View editors
      • Quick Actions
    • Collaborating and sharing
    • Actions and permissions
    • Security
    • Advanced Editor hub
      • @settings reference
      • @controls reference
      • Color reference
      • Property reference
      • Selector reference
  • DISCIPLINES
    • SNA / Network Mapping
    • Systems mapping
    • Systems Practice workbook
  • Guides
    • Activity feed
    • Add-ons
      • Disqus
    • Bridge
    • Cluster
    • Controls
      • Cluster control
      • Color-legend control
      • Filter control
      • Focus control
      • Image control
      • Label control
      • Showcase control
      • SNA-dashboard control
      • Tagged-timeline control
      • Text Control
      • Title Control
      • View toggle control
    • Decorations
      • Direct decorations
      • Data-driven decorations
      • Flags
      • Icons
      • Images
      • Label templates
      • Popovers
    • Default view settings
    • Export
    • Fields
      • Computed fields
    • Filter
    • Focus
    • Forking
    • Grids & Guides
    • Import
      • Structure your data for Kumu
      • Excel / CSV
      • Google Sheets
      • JSON / Blueprints
    • Imported views
    • Layouts
      • Fixed
      • Force-directed
      • Remove overlap
      • Scatter
      • Snap-to
    • Legends
    • Licensing
    • Lightbox
    • Loops
    • Metrics
    • Two-factor authentication
    • Pro workspaces
      • Archiving projects
      • Discussions
    • Partial views
    • Presentations
    • Profiles
      • Markdown
    • Project admin
    • Selectors
    • Shapes
    • Share and embed maps
    • Shortcuts
    • Showcase
    • Slugs
    • Table
    • Templates
      • Geo template
    • URLs
    • Views
    • Widgets
  • About Kumu
    • What is Kumu?
    • How does it work?
    • Where can I get help?
  • Enterprise
    • About enterprise
    • Getting started with VMWare
    • Upgrading
    • Configuration
    • Creating user accounts
    • SSH Access
    • Single sign-on
    • Backing up enterprise data
    • Restoring enterprise data
    • Command line utilities
    • Changelog
  • Frequently Asked Questions
    • Does Kumu have a public API?
    • Does Kumu make use of AI?
    • How do I add annotations?
    • How do I add anchors to my map description?
    • How do I add arrows to my connections?
    • How do I add documents to profiles?
    • How do I add more than one element with the same label?
    • How do I add text dropdowns to my map overview?
    • How do I adjust arrow size?
    • How do I avoid duplicating data?
    • How do I change connection curvature?
    • How do I change font color?
    • How do I change font size?
    • How do I change the default for currency fields?
    • How do I change the length or strength of connections?
    • How do I change the order of control options?
    • How do I change the position of my element labels?
    • How do I cite Kumu?
    • How do I collapse duplicate connections?
    • How do I copy a map to another project?
    • How do I control label size while scaling element size?
    • How do I control text wrapping?
    • How do I convert a project from private to public?
    • How do I convert a project from public to private?
    • How do I create dynamic on/off toggles for my map?
    • How do I customize link text in popovers?
    • How do I customize the order of my legend?
    • How do I delete a project, map, or view?
    • How do I delete data from my project?
    • How do I downgrade my subscription?
    • How do I edit virtual elements?
    • How do I get rid of duplicates?
    • How do I hide elements without connections?
    • How do I hide images from the map but keep them in the profile?
    • How do I hide labels on my map?
    • How do I hide the settings button?
    • How do I keep elements from moving?
    • How do I list an element's connections in its profile?
    • How do I make elements transparent?
    • How do I make sense of my receipt?
    • How do I open a sub-system when clicking on an element?
    • How do I remove the Opposite entry from my legend?
    • How do I remove unneeded controls?
    • How do I remove unwanted legend entries?
    • How do I rename my map/view?
    • How do I restructure my adjacency matrix?
    • How do I save my changes in Kumu?
    • How do I select options by default in my control?
    • How do I set a minimum or maximum zoom level for my map?
    • How do I show the Settings button?
    • How do I size elements based on number of connections?
    • How do I transfer a project?
    • How do I update my credit card information?
    • How much data can my Kumu project handle?
    • How do my readers switch between maps and views?
    • My data won't import. What can I do?
    • My Kumu embed is not working. What can I do?
    • My map disappeared. How do I bring it back?
    • My PDF won't export. What can I do?
    • What pricing plans does Kumu have?
    • Where can I find my invoices?
    • Where can I find example Kumu projects?
Powered by GitBook
On this page
  • Structure your data
  • Common pitfalls
  • Master Imports in 5 Steps

Was this helpful?

Edit on GitHub
  1. Guides
  2. Import

Structure your data for Kumu

PreviousImportNextExcel / CSV

Last updated 1 month ago

Was this helpful?

This guide explains how to structure your data in Excel or Google Sheets. Finding it challenging to start from scratch? Do it the other way around! Manually create a few elements, connections, and some profile fields in Kumu, and click the icon in the bottom-right corner of your project.

Skip to section:

Structure your data

Before you can import your data into Kumu, you'll need to structure your spreadsheet so that Kumu can read it. First, make sure your spreadsheet contains the following required column headers:

For elements

  • Label (must be in the first cell of Column A)

For connections

  • From (must be in the first cell of Column A)

  • To (must be in the first cell of Column B)

After you create the required column headers, you can start filling out the rows to create new elements and connections. You can also optionally add more columns to hold custom data:

For elements

  • Type

  • Description

  • Tags

  • Organization

  • Net worth

...etc.

For connections

  • Type

  • Description

  • Tags

  • Label

  • Strength

...etc.

Here's a sample element import spreadsheet:

Label
Type
Description
Tags

Jeff Mohr

Person

Co-Founder and CEO, always up for learning

Founder|Male|Runner

Kumu

Company

A web-based platform for mapping relationships...

Mapping|Technology

And here's a sample connection import spreadsheet:

From
To
Type
Strength

Barack

Michelle

Personal

Strong

Ed Snowden

NSA

Contractor

It's complicated

Ignore unneeded sheets

Sometimes, you'll have other sheets in your Excel or Google Sheets workbook that aren't formatted for Kumu and shouldn't be imported, but need to stay in the workbook. If that's the case, just add (ignore) to the name of the sheet, and Kumu will ignore it during the upload.

Common pitfalls

Having trouble with your import? If Kumu is giving you an error message, click on the triangular error icon to see what is wrong. If Kumu just loads indefinitely, there's also likely something wrong with the format of your sheet(s). Here are a few common pitfalls...

Not starting your file with the correct column headers

Not having column headers in the first row

Your column headers (e.g. Label, Type, Description, etc.) should be in row 1 of your spreadsheet.

Not ignoring unneeded sheets

If you have multiple sheets in your file, and you only want to import some, make sure that Kumu ignores the other sheets when importing. To do this, you can add (ignore) to sheet names—for example: Sheet 3 (ignore). Also make sure to double-check if you have any hidden sheets in your file!

Hidden data in unused cells

Trying to import .xls files

If you run into this error message...

Sorry, there was an error with your import. Error: Import format not recognized: auto

...you're trying to import an .xls file. Save it as .xlsx and try again!

Importing an Excel file in Google Drive as a Google Sheet

If you add an XLSX file to Google Drive, it will still open as an Excel sheet, only inside Google Drive. Make sure you're file is actually a Google Sheet by clicking on "Open with" at the top of the page and choosing Google Sheets, or by clicking File in the top-left corner and then choose "Save as Google Sheets". You can enter that sheet's link as your Google Sheet link.

Too much data

Funny character issues?

Master Imports in 5 Steps

Looking to hone your importing skills? These tips will turn you into a master importer:

1. Separate elements (or element types) and connections into their own sheets

Since elements and connections often have very different sets of fields, we recommend using separate sheets in your workbook for each dataset. Sometimes, you'll have different types of elements (for example, people and organizations) that have very different fields. In that case, you can separate those elements into separate sheets as well. Each separate sheet can have different column headers, and Kumu will still be able to read and understand each sheet.

If you prefer keeping everything within a single sheet, you can use two blank rows to tell Kumu that a new section is starting—that is, Kumu should look at the first row of the new section to find column headers. If you are using a .csv file, this tip doesn't work—you'll need to either use the single sheet method or create separate files for elements and connections.

2. Take advantage of pre-named fields

3. Use pipes to separate multiple values

For columns with multiple values in a single cell (such as tags, skills, hobbies, etc), you need to separate them using the pipe character |. If you're already separating them using commas, just use find-and-replace to swap out the commas for the pipe character | before importing.

4. Try to be selector friendly

  • person To select all elements with type "Person"

  • personal-connection To select all connections with type "Personal"

  • project.priority To select all projects tagged "priority"

If you include special characters or multiple words, you'll have to use longer selector code instead (e.g. ["element type"="Government Sector"])—and that's just not nearly as much fun!

5. Ask for help!

All of these optional columns can be used to add data to inside your elements and connections. If you want to store multiple values inside of one cell (for example, tags or keywords), just separate each value with the pipe character |. If you put multiple elements in the "To" cell of a connection, separating each element with the pipe character |, Kumu will draw a connection from the "From" element to each separate element in the "To" cell.

It's also possible to use ID as the first column header in element and connection sheets. To learn how and why you would do that, .

Get your hands dirty! for the , or find our . You can examine these files to see how imports work with real data before creating your own import file.

If you need to convert an to meet Kumu's format, see our FAQ.

Label should be the first column header in your spreadsheet (cell A1) for an element import, and for a connection import, you should have From and To in the first two columns (cells A1 and B1). The only exception to this is when you're using IDs in the first column, please read more about that .

If it seems like your spreadsheet is taking forever to load, or it's consistently throwing errors, you might have some data or formatting hiding in your unused cells. To clear all content and formatting from unused cells in Excel, .

Kumu can only . Perhaps you're trying to add 10,000+ data points? Try importing a sub-set of your data first. If that imports without a problem, then your dataset is likely too large for one Kumu project.

If you're running into funny character issues, please make sure your import file is .

Our pre-named fields aren't required in your spreadsheet, but they get special visual treatment in , so it's great to use them when you can!

TypeUse the type field to categorize elements and connections. Common element types include person, project, and company. Common connection types include personal, business, and family. with your types, when you can.DescriptionThe description field designed to hold longer-form content that describes an item. Descriptions can include multiple paragraphs, and even images and videos. to format each description's content.TagsThe tags field is designed to hold multiple values that each describe your item in a different way. For example, a connection between a person and a non-profit might have "Strong relationship", "Board Member", "Donor", and "Advocate" all stored as separate values in the Tags field, adding rich detail to that person's relationship with the non-profit. Make sure to separate multiple tags using a pipe "|" in your spreadsheet cells, and with your tags, when you can.ImageInclude an image URL and Kumu will display it on the map and in the profile.EmailAdd an email and Kumu will automatically include their on the map and in the profile. Gravatars can be a huge time saver when working with social network data!

provide a simple way to slice up your data. By keeping your field names and values selector-friendly, you'll be able to write much shorter queries.

Use single words for your element types, connection types, and tags. By doing so you'll be able to use shorthand selectors in the , such as:

Still have questions? Having trouble structuring your data? We've massaged a lot of data to get it into Kumu's format, and we're happy to help.

fields
check out our guide on avoiding duplicate data
Click here for a sample import file
PayPal Mafia map
folder of public data samples here
adjacency matrix
"How do I restructure my adjacency matrix"
follow this Excel guide
handle so much data
UTF-8 encoded
profiles
Selectors
Let us know!
export
Common Import Pitfalls
Master Imports in 5 Steps
Separate elements (or element types) and connections into their own sheets
Take advantage of pre-named fields
Use pipes to separate | multiple | values
Try to be selector friendly
Ask for help!
You can use Markdown
gravatar
Try to be selector friendly
try to be selector friendly
Advanced Editor
here