# Upload large CSV? in self hosted

**URL:** <https://community.nocodb.com/t/upload-large-csv-in-self-hosted/835>\
**Category:** Self-Host\
**Created:** [June 25, 2023, 6:55am UTC](https://community.nocodb.com/t/upload-large-csv-in-self-hosted/835 "2023-06-25T06:55:25Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mohammed](https://avatars.discourse-cdn.com/v4/letter/m/13edae/32.png) [@Mohammed](https://community.nocodb.com/u/Mohammed)\
**Post date:** [June 25, 2023, 6:55am UTC](https://community.nocodb.com/t/upload-large-csv-in-self-hosted/835/1 "2023-06-25T06:55:25Z")

</div>

How to upload large CSV files to the Nocodb…  
My files are of the size 150MB each…  
Currently the system is saying its limited by 5MB.

---

<div class="post-metadata">

**Author:** ![coderjos](https://avatars.discourse-cdn.com/v4/letter/c/ec9cab/32.png) [@coderjos](https://community.nocodb.com/u/coderjos)\
**Post date:** [February 20, 2024, 10:07am UTC](https://community.nocodb.com/t/upload-large-csv-in-self-hosted/835/2 "2024-02-20T10:07:45Z")

</div>

Hi Mo,  
Did you find a solution to this? I’m having the same problem.

Thanks

---

<div class="post-metadata">

**Author:** ![dstala](https://avatars.discourse-cdn.com/v4/letter/d/f04885/32.png) [@dstala](https://community.nocodb.com/u/dstala)\
**Post date:** [February 20, 2024, 10:09am UTC](https://community.nocodb.com/t/upload-large-csv-in-self-hosted/835/3 "2024-02-20T10:09:29Z")

</div>

@coderjos You will have to break your CSV into chunks & iteratively upload. Easier that way. What is size of your CSV? what is your usecase?

---

<div class="post-metadata">

**Author:** ![coderjos](https://avatars.discourse-cdn.com/v4/letter/c/ec9cab/32.png) [@coderjos](https://community.nocodb.com/u/coderjos)\
**Post date:** [February 20, 2024, 10:30am UTC](https://community.nocodb.com/t/upload-large-csv-in-self-hosted/835/4 "2024-02-20T10:30:14Z")

</div>

just testing out the functionality and limitations of nocodb.  
I’m testing with 100K customer records and higher.

> **[Download Sample CSV Files for free - Datablist](https://www.datablist.com/learn/csv/download-sample-csv-files#customers-dataset)**
>
> You can download sample CSV files here for testing purposes. The datasets can be used in any software application compatible with CSV files. An easy tool to edit CSV ...

why is there a limitation on the self hosted version and are there any other ways to import other than breaking up the file to smaller sizes. seems like a lot of effort

---

<div class="post-metadata">

**Author:** ![dstala](https://avatars.discourse-cdn.com/v4/letter/d/f04885/32.png) [@dstala](https://community.nocodb.com/u/dstala)\
**Post date:** [February 28, 2024, 4:16am UTC](https://community.nocodb.com/t/upload-large-csv-in-self-hosted/835/5 "2024-02-28T04:16:18Z")

</div>

We had plans to introduce an environment variable on the self hosted version to control this. Will discuss with the Engineering team & keep you posted on this.

---

<div class="post-metadata">

**Author:** ![vivek](https://avatars.discourse-cdn.com/v4/letter/v/77aa72/32.png) [@vivek](https://community.nocodb.com/u/vivek)\
**Post date:** [March 25, 2024, 8:03am UTC](https://community.nocodb.com/t/upload-large-csv-in-self-hosted/835/6 "2024-03-25T08:03:31Z")

</div>

Please update, is the feature available?

---

<div class="post-metadata">

**Author:** ![pppaul](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/pppaul/32/457_2.png) [@pppaul](https://community.nocodb.com/u/pppaul)\
**Post date:** [April 8, 2024, 9:39pm UTC](https://community.nocodb.com/t/upload-large-csv-in-self-hosted/835/7 "2024-04-08T21:39:49Z")

</div>

i just ran into same problem with a localhost install, trying to import a 200mb sheet. maybe there is a workaround where we can turn the sheet into a sqlite db, and then connect that?

---

<div class="post-metadata">

**Author:** ![coderjos](https://avatars.discourse-cdn.com/v4/letter/c/ec9cab/32.png) [@coderjos](https://community.nocodb.com/u/coderjos)\
**Post date:** [June 12, 2024, 10:03am UTC](https://community.nocodb.com/t/upload-large-csv-in-self-hosted/835/8 "2024-06-12T10:03:25Z")

</div>

any update on this limitation?

---

<div class="post-metadata">

**Author:** ![Navi](https://avatars.discourse-cdn.com/v4/letter/n/3be4f8/32.png) [@Navi](https://community.nocodb.com/u/Navi)\
**Post date:** [June 13, 2024, 1:44pm UTC](https://community.nocodb.com/t/upload-large-csv-in-self-hosted/835/9 "2024-06-13T13:44:39Z")

</div>

hey @coderjos - I have raised an [issue to be tracked here](https://github.com/nocodb/nocodb/issues/8723).

Could you briefly explain the usecase

- What is the usecase of these many rows (or large files) ?
- What happens to the data after being uploaded - do you edit it / clean it ?
- How often do you do this ? in a day/week/month ?

---

<div class="post-metadata">

**Author:** ![coderjos](https://avatars.discourse-cdn.com/v4/letter/c/ec9cab/32.png) [@coderjos](https://community.nocodb.com/u/coderjos)\
**Post date:** [June 13, 2024, 2:03pm UTC](https://community.nocodb.com/t/upload-large-csv-in-self-hosted/835/10 "2024-06-13T14:03:50Z")

</div>

Hi Navi,

Just want to import a data set.

Thanks

---

<div class="post-metadata">

**Author:** ![Navi](https://avatars.discourse-cdn.com/v4/letter/n/3be4f8/32.png) [@Navi](https://community.nocodb.com/u/Navi)\
**Post date:** [June 13, 2024, 2:06pm UTC](https://community.nocodb.com/t/upload-large-csv-in-self-hosted/835/11 "2024-06-13T14:06:44Z")

</div>

Could you please share about your usecase ? this would help us understand more on the problem

> [@Navi](#):
>
> - What is the usecase of these many rows (or large files) ?
> - What happens to the data after being uploaded - do you edit it / clean it ?
> - How often do you do this ? in a day/week/month ?

---

<div class="post-metadata">

**Author:** ![mcorona](https://avatars.discourse-cdn.com/v4/letter/m/85f322/32.png) [@mcorona](https://community.nocodb.com/u/mcorona)\
**Post date:** [October 17, 2024, 1:07pm UTC](https://community.nocodb.com/t/upload-large-csv-in-self-hosted/835/12 "2024-10-17T13:07:51Z")

</div>

Did you ever figure this out? I can’t get mine to go above 25MB

---

<div class="post-metadata">

**Author:** ![kota](https://avatars.discourse-cdn.com/v4/letter/k/e47c2d/32.png) [@kota](https://community.nocodb.com/u/kota)\
**Post date:** [November 22, 2024, 6:01pm UTC](https://community.nocodb.com/t/upload-large-csv-in-self-hosted/835/13 "2024-11-22T18:01:26Z")

</div>

As of the day, with nocodb/nocodb:0.258.2 (or even earlier versions) you can set `NC_ATTACHMENT_FIELD_SIZE`. Details can be found on the this [page](https://docs.nocodb.com/getting-started/self-hosted/environment-variables/)

 ![截圖 2024-11-23 凌晨2.01.11](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/0dcb8bb6da32aaf6e5a33c1f13095be71d8c51fc.png)
