# Creating Lookups from imported spreadsheet data

**URL:** <https://connect.superhuman.com/t/creating-lookups-from-imported-spreadsheet-data/22834>\
**Category:** Ask the Community\
**Created:** [April 14, 2021, 4:55am UTC](https://connect.superhuman.com/t/creating-lookups-from-imported-spreadsheet-data/22834 "2021-04-14T04:55:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Michael\_Kim-Eubanks](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/michael_kim-eubanks/32/20461_2.png) [@Michael\_Kim-Eubanks](https://connect.superhuman.com/u/Michael_Kim-Eubanks)\
**Post date:** [April 14, 2021, 4:55am UTC](https://connect.superhuman.com/t/creating-lookups-from-imported-spreadsheet-data/22834/1 "2021-04-14T04:55:51Z")

</div>

I’m a new Coda user migrating from Notion, and I’ve got a question. I’m creating a donor database for a nonprofit. I’ve got two basic tables that I plan to use to create reports of various types: an “offerings” table that will be data from an Excel spreadsheet and list all monetary donations, and a “contributors” table which will have basic info about those making the donations.

The tables (which come from another, more ornery database), are linked by ID numbers for each contributor, and so my question is: how do I create a lookup (or lookups) that connect these tables? Please let me know if this doesn’t make sense and I’d be glad to provide more context.

---

<div class="post-metadata">

**Author:** ![Piet\_Strydom](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/piet_strydom/32/19269_2.png) [@Piet\_Strydom](https://connect.superhuman.com/u/Piet_Strydom)\
**Post date:** [April 14, 2021, 5:20am UTC](https://connect.superhuman.com/t/creating-lookups-from-imported-spreadsheet-data/22834/2 "2021-04-14T05:20:27Z")

</div>

HI Michael,

Welcome to Coda.

Coda support provided me with an example, which I have recorded in [this document.](https://coda.io/@piet-strydom/rambling-petes-quick-examples)

It is on the page “One to zero or one join”

I hope that this is what you are looking for. If not,there are a couple of other examples too.

---

<div class="post-metadata">

**Author:** ![Michael\_Kim-Eubanks](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/michael_kim-eubanks/32/20461_2.png) [@Michael\_Kim-Eubanks](https://connect.superhuman.com/u/Michael_Kim-Eubanks)\
**Post date:** [April 15, 2021, 4:21am UTC](https://connect.superhuman.com/t/creating-lookups-from-imported-spreadsheet-data/22834/3 "2021-04-15T04:21:58Z")

</div>

This is amazingly helpful. Thanks so much!