# Copying table from google spreadsheets & numbers

**URL:** <https://connect.superhuman.com/t/copying-table-from-google-spreadsheets-numbers/23398>\
**Category:** Ask the Community\
**Created:** [May 13, 2021, 7:42am UTC](https://connect.superhuman.com/t/copying-table-from-google-spreadsheets-numbers/23398 "2021-05-13T07:42:10Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Federico\_Stefanato](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/federico_stefanato/32/10092_2.png) [@Federico\_Stefanato](https://connect.superhuman.com/u/Federico_Stefanato)\
**Post date:** [May 13, 2021, 10:43am UTC](https://connect.superhuman.com/t/copying-table-from-google-spreadsheets-numbers/23398/2 "2021-05-13T10:43:24Z")

</div>

Hi @Kochan,  
and welcome to Coda Community! 🤝

Firstly, by registering you agreed on the guidelines of this community ([FAQ - Coda Maker Community](https://connect.superhuman.com/guidelines)): it’s really appreciated to honour them.

Coming to your problem, currently formats on some data types are not covering all the full fine-grained spectrum (numbers, date, time).

However there are some workarounds to programmatically convert into the proper data type.

> [@Kochan](#):
>
> ok, maybe that “add formula” button can help me make a converter to convert that all to numbers

Not quite, but you can:

1. make a formula column (not editable) that displays in the correct data type
2. add a button that does it and puts the data in an editable column

I tried to provide you a sample with both alternatives: let me know if it is clear:

https://coda.io/embed/ApQD1HGfij/_su-9p?viewMode=embedplay

Also, Coda - as well as other relational oriented data tools - favourites a row-based approach rather that a column-oriented.  
Meaning that it is usually easier add a row than a column and if you follow this principle you’ll take full advantage of the tool (also provided in the sample).

Let me know if you have additional questions.  
Cheers!

---

_[View the full topic](https://connect.superhuman.com/t/copying-table-from-google-spreadsheets-numbers/23398)._
