# How do I restructure my adjacency matrix? If your data is structured as an [adjacency matrix](https://en.wikipedia.org/wiki/Adjacency_matrix), the matrix will need to be restructured as a list of connections, before it can be [imported](/guides/import.md). Restructuring an adjacency matrix can be complex, so we created a tool to help you. It's a custom Google Sheets formula called `KUMU_CONNECTION_LIST` that will convert any adjacency matrix into a connection list, which can then be imported into Kumu. To get access to the custom formula, you can open our ["With custom Kumu formulas" Google Sheet](https://docs.google.com/spreadsheets/d/1qRhkn6qECtBaAncWykMa0hAG97jPK6q_bODrwntqze8/edit?usp=sharing), then click "File" > "Make a copy" to create your own editable copy of the sheet. Delete all the example tabs in your spreadsheet, then create a new tab, and put your matrix in that tab. Be sure to add `(ignore)` to the tab name to make sure Kumu doesn't try to import it. Next, add a new tab, and type `=KUMU_CONNECTION_LIST(` in cell `A1` to get started. ## Video explanation {% embed url="" %} Note: the first tool in this video is currently unavailable. Please refer to the second tool (custom Google Sheets) at 01:41 of the video. {% endembed %} ## Sample usages `KUMU_CONNECTION_LIST(A1:J10)` `KUMU_CONNECTION_LIST(A1:J10, TRUE, TRUE, TRUE, TRUE, TRUE)` ## Syntax `KUMU_CONNECTION_LIST(matrix, is_directed, include_duplicate_connections, include_self_connections, include_zero_strength_connections, include_blank_strength_connections)` | Parameter | Description | | ------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `matrix` | The cell range containing the adjacency matrix to be converted | | `is_directed` |

TRUE when the network is directed, FALSE when the network is undirected.

Defaults to FALSE.

| | `include_duplicate_connections` |

For directed networks: TRUE when the connection list should include connections with the same source and target, FALSE when the connection list should only include the the first connection for any given source-target pair (ignoring all other connections between that pair).

For undirected networks: TRUE when the connection list should include multiple connections between the same pair of elements, FALSE when the connection list should only include the the first connection for any given pair of elements.

Defaults to FALSE.

| | `include_self_connections` |

TRUE when the connection list should include connections between any given element and itself, FALSE when it shouldn't.

Defaults to FALSE.

| | `include_zero_strength_connections` |

TRUE when the connection list should include connections whose strength is 0, FALSE when it shouldn't.

Defaults to FALSE.

| | `include_blank_strength_connections` |

TRUE when the connection list should include connections whose strength is blank, FALSE when it shouldn't.

Defaults to FALSE.

| `KUMU_CONNECTION_LIST` returns the full connection list, which will span across multiple columns and rows. ## Renaming the "Strength" column The `KUMU_CONNECTION_LIST` formula will store your connection strengths in a column titled "Strength", and "Strength" will become a field name in Kumu. If you want to use a field name other than "Strength" you can follow these steps to change the column header in Kumu: 1. Add `(ignore)` to the tab that contains your new connection list, and add a new tab 2. In cell `A2` of the new tab, copy/paste the following formula: ``` =ARRAYFORMULA('My other tab (ignore)'!A2:C) ``` Replace `My other tab (ignore)` with the actual name of the tab where your connection list is. 3. Enter `From` and `To` as the column headers in cells `A1` and `B1` 4. Enter your custom Strength column header in cell `C1` --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.kumu.io/frequently-asked-questions/how-do-i-restructure-my-adjacency-matrix.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.