# Import large data from excel **URL:** \ **Category:** Ask the Community\ **Created:** [August 30, 2021, 7:11am UTC](https://connect.superhuman.com/t/import-large-data-from-excel/25331 "2021-08-30T07:11:35Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![elad\_noam](https://avatars.discourse-cdn.com/v4/letter/e/f475e1/32.png) [@elad\_noam](https://connect.superhuman.com/u/elad_noam)\ **Post date:** [August 30, 2021, 7:11am UTC](https://connect.superhuman.com/t/import-large-data-from-excel/25331/1 "2021-08-30T07:11:35Z")
i try to import large data from Excel, 200,000 rows 20 colums. once i paste the data, Coda crash. tried to copy 20,000 rows and still crash… can i get help? TY!! ---
**Author:** ![Florian\_Utner](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/florian_utner/32/22511_2.png) [@Florian\_Utner](https://connect.superhuman.com/u/Florian_Utner)\ **Post date:** [October 28, 2021, 2:03pm UTC](https://connect.superhuman.com/t/import-large-data-from-excel/25331/2 "2021-10-28T14:03:54Z")
@elad_noam I have a similar issue. Coda pastes the whole sheet as a .png. So I see the picture of the excel sheet in one cell only. I was just searching for an answer for this issue. Could you figure it out already? ---
**Author:** ![Roy\_van\_Ginneken1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/roy_van_ginneken1/32/24740_2.png) [@Roy\_van\_Ginneken1](https://connect.superhuman.com/u/Roy_van_Ginneken1)\ **Post date:** [March 29, 2022, 7:59am UTC](https://connect.superhuman.com/t/import-large-data-from-excel/25331/3 "2022-03-29T07:59:46Z")
Same here. But apparently still no solution? Is there any other way to fix this? ---
**Author:** ![Max\_OBrien](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/max_obrien/32/49285_2.png) [@Max\_OBrien](https://connect.superhuman.com/u/Max_OBrien)\ **Post date:** [March 29, 2022, 10:00am UTC](https://connect.superhuman.com/t/import-large-data-from-excel/25331/4 "2022-03-29T10:00:04Z")
there are some things where Coda is better than Excel then there are things where Excel or Google Sheets are better than Coda. running a model with 200k rows and 20 columns is one of those things best done with spreadsheets or pure database platforms. its just not what Coda is good at. i have taken on projects of that size and found ways to produce docs with hundreds of rows and maybe a handful of tables that automated single workflows, such as complex insurance claim cases or aerospace maintenance jobs. then users create hundreds of these single-case documents as required. each document handles just one client or aircraft. so the volume of data is manageable in coda. we then use cross-doc functionality to roll-up summary data from each document into a report document, again holding hundreds (not thousands) or rows in a handful of densly inter-related tables, dashboards and charts. coda is great for automating this size of workflow while still giving the flexability of a worksheet-like tool. just my humble opinion and experience, max ---
**Author:** ![Hendrik\_TnB](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/hendrik_tnb/32/25151_2.png) [@Hendrik\_TnB](https://connect.superhuman.com/u/Hendrik_TnB)\ **Post date:** [March 29, 2022, 11:58am UTC](https://connect.superhuman.com/t/import-large-data-from-excel/25331/5 "2022-03-29T11:58:46Z")
Coda can handle 10k rows with no problem. But for importing, you can’t copy paste. You must use import csv coda pack. But as @Max_OBrien has mentioned, it’s better to divide them into different docs. ---
**Author:** ![Max\_OBrien](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/max_obrien/32/49285_2.png) [@Max\_OBrien](https://connect.superhuman.com/u/Max_OBrien)\ **Post date:** [July 20, 2022, 6:41am UTC](https://connect.superhuman.com/t/import-large-data-from-excel/25331/6 "2022-07-20T06:41:39Z")
update: we now have a few documents with more than 10k rows. and they function well. but whevever we need to import large amounts of data into coda, we use Google Application Script and the Coda API to import data from Google Sheets. that way we can tailor the script to do exactly what is required max