# 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:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kochan](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/kochan/32/20285_2.png) [@Kochan](https://connect.superhuman.com/u/Kochan)\
**Post date:** [May 13, 2021, 7:42am UTC](https://connect.superhuman.com/t/copying-table-from-google-spreadsheets-numbers/23398/1 "2021-05-13T07:42:10Z")

</div>

Trying to copy from google sheets with default number format and coda cant understand it

_there was table pics but i cant post them_

> **[:(](https://coda.io/@kochan/iwantnumbers)**

even manually selecting that this values are numbers doesn’t work

![image](https://global.discourse-cdn.com/coda1/original/3X/2/d/2dcd6d3015f6200fd8422b5e77a29a1b35323c2b.png)

WHYYYY I CAN USE ONLY , SEPARATOR??? LITERALLY ALL normal people use space, why the fuck do i need to use ,

ok, maybe that “add formula” button can help me make a converter to convert that all to numbers

_imagine a picture with formula menu_

i don’t understand what this is and why this is in the number format menu

---

<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!

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [November 2, 2021, 11:20pm UTC](https://connect.superhuman.com/t/copying-table-from-google-spreadsheets-numbers/23398/3 "2021-11-02T23:20:39Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.