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

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

exporting to csv


When I export to csv any information in a field that starts with a zero loses the zero on export. Ie: 000546, exports as 546. How do I get the zeros to export without having to put a character in front of it on the trello card?


1 answer

0 votes
Ryan Atlassian Team Nov 11, 2020

Hi there,

The export does contain the zeros, as you can see when you open the csv file in a text editor. However, this is a known issue when opening CSV files that they truncate the leading zeros. You can see some discussion about this in other forums eg. here and here.

I hope this information helps!


Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Trello

Taco Tuesday: Your favorite Trello blog takeaway

Hello friends! From the community that brought you Welcome Wednesday, Throwback Thursday and Friday Fun, welcome to Taco Tuesday, a weekly discussion about all things Trello. The best part? One Tac...

325 views 13 12
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you