Importing specific cells from csv file to existing table, daily

1

Hello Coda Community,

First time posting here, be easy on me.

I am looking for a solution where I can upload a csv file and then have 10-15 specific cells from that file (it has around a thousand cells with information in them total) added to an existing table. At the moment I am just manually entering in the data. I do this for four businesses currently with more in the pipeline so I’m hoping to streamline this workflow.

I’ve attempted to add the CSV Converter pack but haven’t been able to make it work. I’m a Java novice. Not sure if I’m way off there.

Any guidance?

Further down the line, I imagine Zapier or some other solution could make it to where I don’t even need to upload the csv myself but I’m too cheap to pay for anything just yet.

2

Hi Harrison

Welcome to the community!

  1. The simplest way would just be to cut and paste the daily information into a table in Coda, then look up the relevant fields in the existing table.
  2. Depending on your CSV file’s source, there are other possibilities. But best of all, is there a way to eliminate the CSV file completely by directly going to the source of the CSV file? Or generate the data for the CSV file using Coda?

Regards
Piet

1 Like
3

We’re a franchised business and the franchise won’t let us connect to their system via Open API so the cvs file is the best we can do.

I need to pull 10-15 very specific cells from the csv to Coda in one row. My struggle right now is that I have to hop around the csv file to copy and paste those each individually. I’m looking for a tool that does that for me. Any ideas?

1 Like
4

Once you have the CSV file in Coda, you can use split() to break the row into pieces. Then you can use nth() to find the specific fields. (assuming they are in the same position every time.)

I have some examples below:

I hope this helps.