Import From Excel To Coda Tables

[Alyssa_Gono]

Is there any way to import data from excel to Coda tables. The condition below should follow.

if Excel.key == Coda.pub_key, then Coda.Nickname = Excel.nickname.

Excel

Coda

I want to automatically populate Coda’s Nickname base on pub_key. Thanks!

[Quentin_Morel]

Hi @Alyssa_Gono

Coda perfectly manages copy and paste directly from excel (see this quick screenshot)
It autofills the headings according to excel one and recognizes the type/format of element (see the date)

Then, you can easily modify your data. You may also be interested in CSV Importer Pack

I did not understand what you desired with the formula “Excel.key …”

Please let us know

[Alyssa_Gono]

Thanks! I updated my post for clarification.

[Quentin_Morel]

@Alyssa_Gono

if Excel.key == Coda.pub_key, then Coda.Nickname = Excel.nickname.

Hi @Alyssa_Gono, you need to clarify what you want to do : are we talking about one single table ? two ? Where do the “pub_key” come from in your coda table ?

• if you have only one table, just copy/paste and make the modification you want
• if you have two tables inside your coda doc, we need to understand the link between them

Thanks for those precisions that would help us to give advice to achieve your goals !

[Alyssa_Gono]

We are talking about one table from Coda and one excel file. The pub_key from Coda is already there. I can do manual populating of Nicknames based on pub_key. However, there are thousands of rows, I want to find a way to make it faster.

[Quentin_Morel]

OK understood :

• So you need to copy/paste your excel table (in grey in my document), and you also have your “existing coda table” :

You said pub_key_from_coda do already exists. Then, enter this formula on Nickname column from CODA table :

OK for you ?

Q.

[Alyssa_Gono]

Wow, great! Thank you so much.

[Quentin_Morel]

Happy to have helped ! Thanks for sharing screenshots and whole explanation, that was easier to understand then.