Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,456,613
Community Members
 
Community Events
176
Community Groups

Looking to import data from Excel/csv file to a board initally, then update the same data repeatedly

Before committing to using a Trello Baord, in our internal communications and workflow, I’d like to understand the following:

We are trying to use our Trello “Production” board as an internal communication tool, based on imported data from an Excel/csv file, combined with manually entered comments and notes to each card.

Initially we will create the cards in the “Production” Board from an Excel/csv file, this is our production data, including things like, name/date/quantity etc

Then we would like to update this same board with extra cards, and also change the production data, like dates, quantity in each of the existing cards from a later updated file import.

However to use this a board for internal communications we would like to make comments or add notes to the cards in the board during each week for example.

The question is, will another later import of our Production data (dates, quantities etc) overwrite the comments and notes we added separately, or can we import very defined data to a card without losing the comments and notes within the that card?

Appreciate any comments or suggestions from the community

1 answer

0 votes

Hi @Alan Metcalfe ! Welcome to the community! What tool are you using for the import? When you say another later import, are you talking about importing additional rows in your spreadsheet to create new cards, or are you referring to updating existing rows in your spreadsheet and then this new information syncing to Trello and update existing cards (e.g. updating the date in a row and this updates an existing card's date).

Also, happy to recommend some tools to get data from a spreadsheet into Trello depending on whether you need "one-off" imports, or more ongoing syncs.

Hannah Hi,

We have not selected an import tool to use as yet.

The later import’s need to be able o perform two actions

1. Import new rows, in the spreadsheet, to create new cards in the board.

2. Update existing rows in the spreadsheet and syncing (updating) the information in the cards already created.

The intention is that the spreadsheet will be the only source of data to create cards and the only source to update specific fields within the cards.

We need the facility to then add comments, notes and communicate within the team on these cards.

Hope that helps clarify what we are trying to achieve.

Appreciate any suggestions about the available tools 

Many thanks for the reply

Hannah Morgan Community Leader Mar 09, 2022

@Alan Metcalfe in that case, it sounds like you need more of an ongoing integration between the two tools rather than an import solution. You have tools like Zapier where you can create "if this then that" automation. I believe there is also an option in Zapier to update existing cards by using their lookup function (i.e. when a row is updated, lookup related card, and update field". It might get a bit tricky depending on how many fields you'd like to "map" to Trello.

Another alternative is to use Unito which will create a true sync between your spreadsheet and Trello. They don't integrate with Microsoft Excel, but they do support Google Sheets and Airtable if you're open to using a cloud-based app for your database. 

Like Robin Warren likes this

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events