# \#data-import-export **URL:** https://community.nocodb.com/tag/data-import-export/1.md [Latest](https://community.nocodb.com/latest.md) · [Categories](https://community.nocodb.com/categories.md) · [Tags](https://community.nocodb.com/tags.md) --- ## [Students, hobbyists and digital gardeners selfhost subscription](https://community.nocodb.com/t/students-hobbyists-and-digital-gardeners-selfhost-subscription/2272)
**Author:** [@nocogardener](https://community.nocodb.com/u/nocogardener)\ **Replies:** 0\ **Last updated:** [June 29, 2026, 5:21pm UTC](https://community.nocodb.com/t/students-hobbyists-and-digital-gardeners-selfhost-subscription/2272 "2026-06-29T17:21:13Z")
Could it be possible to have a license for that userbase with possibilities of trash management and full import export of data? Right now licenses are clearly for business users and I find it not so nice to lock full ex… --- ## [Switchting from airtable](https://community.nocodb.com/t/switchting-from-airtable/2266)
**Author:** [@sronline](https://community.nocodb.com/u/sronline)\ **Replies:** 2\ **Last updated:** [June 21, 2026, 4:42am UTC](https://community.nocodb.com/t/switchting-from-airtable/2266 "2026-06-21T04:42:45Z")
Hi everyone, We’ve been using Airtable for several years as a central operational database/dashboard for our team. We originally chose Airtable because personally I prefer to avoid using google spreadsheets. We current… --- ## [Migrating NocoDB from SQLite to PostgreSQL (Linode Managed DB)](https://community.nocodb.com/t/migrating-nocodb-from-sqlite-to-postgresql-linode-managed-db/2181)
**Author:** [@michaell](https://community.nocodb.com/u/michaell)\ **Replies:** 1\ **Last updated:** [March 12, 2026, 6:34am UTC](https://community.nocodb.com/t/migrating-nocodb-from-sqlite-to-postgresql-linode-managed-db/2181 "2026-03-12T06:34:19Z")
I’m not a developer, but I manage NocoDB for our business. It has become a critical tool for us, and as our data has grown, SQLite has started to feel sluggish. I’d like to move to PostgreSQL for better performance and r… --- ## [Access to NocoDb data from a SQL server](https://community.nocodb.com/t/access-to-nocodb-data-from-a-sql-server/2175)
**Author:** [@Productivix](https://community.nocodb.com/u/Productivix)\ **Replies:** 1\ **Last updated:** [February 12, 2026, 4:32pm UTC](https://community.nocodb.com/t/access-to-nocodb-data-from-a-sql-server/2175 "2026-02-12T16:32:06Z")
I make mobile app that populate data to a NoCodb database (on https://app.nocodb.com/#/) . My customer want to only read by SQL query from their own (external) server those data. How can they do that please? Thanks pe… --- ## [Migrating from supabase to self-hsoted NocoDB](https://community.nocodb.com/t/migrating-from-supabase-to-self-hsoted-nocodb/2139)
**Author:** [@Duckey](https://community.nocodb.com/u/Duckey)\ **Replies:** 1\ **Last updated:** [December 8, 2025, 7:26pm UTC](https://community.nocodb.com/t/migrating-from-supabase-to-self-hsoted-nocodb/2139 "2025-12-08T19:26:30Z")
So I used to use supabase but it’s kinda been annoying with constantly and randomly pausing projects. Is there I way I can export the entire lot of my project from supabase to my self hosted NocoDB instance? --- ## [Importing from Airtable error: Duplicate column alias](https://community.nocodb.com/t/importing-from-airtable-error-duplicate-column-alias/2027)
**Author:** [@webjuice](https://community.nocodb.com/u/webjuice)\ **Replies:** 3\ **Last updated:** [July 28, 2025, 2:37pm UTC](https://community.nocodb.com/t/importing-from-airtable-error-duplicate-column-alias/2027 "2025-07-28T14:37:43Z")
I am trying to import a base from Airtable, but I got this error: “Duplicate column alias” I have a question about importing data from Airtable. Is it possible to have detailed logs when an error occurs? I have a “Dupli… --- ## [NocoDB API Response Type Mismatch for OpenAPI](https://community.nocodb.com/t/nocodb-api-response-type-mismatch-for-openapi/2017)
**Author:** [@Hitu-C](https://community.nocodb.com/u/Hitu-C)\ **Replies:** 2\ **Last updated:** [July 23, 2025, 5:47pm UTC](https://community.nocodb.com/t/nocodb-api-response-type-mismatch-for-openapi/2017 "2025-07-23T17:47:51Z")
There is an inconsistency between the OpenAPI specification and the actual API response Content-Type for the link records endpoint: https://app.nocodb.com/api/v2/tables/{tableId}/links/{linkFieldId}/records/{recordId}. T… --- ## [\[bug\] Export to Excel missing](https://community.nocodb.com/t/bug-export-to-excel-missing/1980)
**Author:** [@Dagaloni](https://community.nocodb.com/u/Dagaloni)\ **Replies:** 2\ **Last updated:** [July 2, 2025, 5:49pm UTC](https://community.nocodb.com/t/bug-export-to-excel-missing/1980 "2025-07-02T17:49:15Z")
I’m running NocoDB 0.263.8 and today I noticed that the Excel export function is missing. Did I miss something or is this a bug? --- ## [How can I download table as CSV via API?](https://community.nocodb.com/t/how-can-i-download-table-as-csv-via-api/1947)
**Author:** [@dan\_named](https://community.nocodb.com/u/dan_named)\ **Replies:** 3\ **Last updated:** [June 20, 2025, 3:18am UTC](https://community.nocodb.com/t/how-can-i-download-table-as-csv-via-api/1947 "2025-06-20T03:18:13Z")
Hey there! I’m curious — is it possible to download a table or table view via any of the API endpoints in the self-hosted version of NocoDB? I’ve been browsing the web, but many discussions refer to endpoints I haven’t… --- ## [Querying multi-tag fields with spaces in NocoDB: anyof filter not matching tags containing spaces](https://community.nocodb.com/t/querying-multi-tag-fields-with-spaces-in-nocodb-anyof-filter-not-matching-tags-containing-spaces/1866)
**Author:** [@maxodors](https://community.nocodb.com/u/maxodors)\ **Replies:** 1\ **Last updated:** [May 13, 2025, 12:04pm UTC](https://community.nocodb.com/t/querying-multi-tag-fields-with-spaces-in-nocodb-anyof-filter-not-matching-tags-containing-spaces/1866 "2025-05-13T12:04:18Z")
I’m using NocoDB to store records with multi-tag fields (e.g. “Scene,” “Mood”, etc.). Tags without spaces work fine when filtering via the REST API, but tags that include spaces (e.g. “Combat – Light”) fail to match. I’d… --- ## [Import Airtable data](https://community.nocodb.com/t/import-airtable-data/1770)
**Author:** [@jeppe](https://community.nocodb.com/u/jeppe)\ **Replies:** 4\ **Last updated:** [April 3, 2025, 11:04am UTC](https://community.nocodb.com/t/import-airtable-data/1770 "2025-04-03T11:04:32Z")
Hi everyone! I followed the instruction for importing a base in Airtable to Nocodb and I got all the tables imported, but with no data. the log gave me this error: data :: You should provide valid api key to perform th… --- ## [Self-hosted : sqllite \> postgres](https://community.nocodb.com/t/self-hosted-sqllite-postgres/1733)
**Author:** [@ceri](https://community.nocodb.com/u/ceri)\ **Replies:** 2\ **Last updated:** [March 20, 2025, 6:49pm UTC](https://community.nocodb.com/t/self-hosted-sqllite-postgres/1733 "2025-03-20T18:49:08Z")
Hello everyone, i’m trying to migrate my sqlite database to a postgresql database with losing any data, i tried with pgloader , but it not working like i’d like to , is there a safe way to fully migrate a sqlite to postg… --- ## [Move / migrate nocodb to coolify](https://community.nocodb.com/t/move-migrate-nocodb-to-coolify/1713)
**Author:** [@crazyshmazy](https://community.nocodb.com/u/crazyshmazy)\ **Replies:** 2\ **Last updated:** [March 13, 2025, 10:37am UTC](https://community.nocodb.com/t/move-migrate-nocodb-to-coolify/1713 "2025-03-13T10:37:22Z")
Hey NocoDB Community! We’ve been running NocoDB on a server set up with auto-install, but now we’re switching to Coolify and want to get NocoDB running on it too. Anyone know the best way to move all our data over to th… --- ## [Import - String to Select - Get an error](https://community.nocodb.com/t/import-string-to-select-get-an-error/1677)
**Author:** [@jbo](https://community.nocodb.com/u/jbo)\ **Replies:** 5\ **Last updated:** [February 26, 2025, 7:19am UTC](https://community.nocodb.com/t/import-string-to-select-get-an-error/1677 "2025-02-26T07:19:58Z")
Hello, My config: Node: \*\*v22.13.0\*\* Arch: \*\*x64\*\* Platform: \*\*linux\*\* Docker: \*\*true\*\* RootDB: \*\*pg\*\* PackageVersion: \*\*0.260.2\*\* I try to import an excel file to a table and i get an error. After multiple tests, i … --- ## [Question field error](https://community.nocodb.com/t/question-field-error/1595)
**Author:** [@Farah](https://community.nocodb.com/u/Farah)\ **Replies:** 1\ **Last updated:** [January 15, 2025, 4:13am UTC](https://community.nocodb.com/t/question-field-error/1595 "2025-01-15T04:13:57Z")
I have a date field, and I would like to transform it into a single selection field with the same format as the date, which is dd/mm/yyyy. Whenever a new value is added to the date field, I want the single selection fiel… --- ## [Nested IF Formula](https://community.nocodb.com/t/nested-if-formula/1594)
**Author:** [@Farah](https://community.nocodb.com/u/Farah)\ **Replies:** 1\ **Last updated:** [January 14, 2025, 10:30am UTC](https://community.nocodb.com/t/nested-if-formula/1594 "2025-01-14T10:30:26Z")
I have this formula: IF({Montant payé} = 50, {Prix}, {Prix} - {Montant payé} - {Montant code}) I would like to implement it in NocoDB. --- ## [Nested IF formula error](https://community.nocodb.com/t/nested-if-formula-error/1593)
**Author:** [@Farah](https://community.nocodb.com/u/Farah)\ **Replies:** 1\ **Last updated:** [January 13, 2025, 5:08pm UTC](https://community.nocodb.com/t/nested-if-formula-error/1593 "2025-01-13T17:08:01Z")
I would like to make a formula like this with Nocodb IF(Pack=“X”,50, IF(Pack=“Y”,8, IF(Pack=“Z”,10, IF(Pack=“R”,100, IF(Pack=“F”,22, IF(Pack=“O”,160, IF(Pack=“E”,100, IF(Pack=“D”,1000, IF(Pack=“T”,99, IF(Pack=“… --- ## [Move Binary installation to docker](https://community.nocodb.com/t/move-binary-installation-to-docker/1505)
**Author:** [@omnimercador](https://community.nocodb.com/u/omnimercador)\ **Replies:** 1\ **Last updated:** [November 25, 2024, 12:16pm UTC](https://community.nocodb.com/t/move-binary-installation-to-docker/1505 "2024-11-25T12:16:47Z")
I installed NocoDB on Windows using the binary quite a long time ago, and kept the install up to date. It’s been in full use for a small retail business. I recently noticed that the guidance is to use Docker for all pro… --- ## [Self host: Webhook Dynamic Data](https://community.nocodb.com/t/self-host-webhook-dynamic-data/1470)
**Author:** [@islamnazmi](https://community.nocodb.com/u/islamnazmi)\ **Replies:** 1\ **Last updated:** [November 12, 2024, 9:28am UTC](https://community.nocodb.com/t/self-host-webhook-dynamic-data/1470 "2024-11-12T09:28:50Z")
What is the correct structure to send a record id --- ## [How to export all databases from NocoDB Cloud to Self-hosted?](https://community.nocodb.com/t/how-to-export-all-databases-from-nocodb-cloud-to-self-hosted/1409)
**Author:** [@mikhalchan](https://community.nocodb.com/u/mikhalchan)\ **Replies:** 4\ **Last updated:** [October 28, 2024, 5:01pm UTC](https://community.nocodb.com/t/how-to-export-all-databases-from-nocodb-cloud-to-self-hosted/1409 "2024-10-28T17:01:37Z")
I’ve been testing NocoDB in the Cloud, and I love it. But for a long time use, I’ve installed it on my own server. But I can’t export databases via Share Base. Are there any ways to copy or move all databases from Cloud … --- ## [Migration from Airtable base](https://community.nocodb.com/t/migration-from-airtable-base/1362)
**Author:** [@swarnendu](https://community.nocodb.com/u/swarnendu)\ **Replies:** 2\ **Last updated:** [September 12, 2024, 11:45am UTC](https://community.nocodb.com/t/migration-from-airtable-base/1362 "2024-09-12T11:45:38Z")
Tried importing from Airtable base. Getting this screen for an hour twice. Nothing is happening. --- ## [Exporting Bases from Self Host to Cloud Version](https://community.nocodb.com/t/exporting-bases-from-self-host-to-cloud-version/1296)
**Author:** [@bluechair](https://community.nocodb.com/u/bluechair)\ **Replies:** 1\ **Last updated:** [July 30, 2024, 6:24am UTC](https://community.nocodb.com/t/exporting-bases-from-self-host-to-cloud-version/1296 "2024-07-30T06:24:33Z")
We’re loving our self-hosted instance, but I’m noticing a couple of cloud-only features we need (mainly limiting record selection in linked fields). Is it possible to export everything more directly than downloading to … --- ## [Removed old column name(vendors\_id) from database but on Nocodb UI it is asking for the column](https://community.nocodb.com/t/removed-old-column-name-vendors-id-from-database-but-on-nocodb-ui-it-is-asking-for-the-column/1278)
**Author:** [@weintegral](https://community.nocodb.com/u/weintegral)\ **Replies:** 2\ **Last updated:** [July 18, 2024, 1:00pm UTC](https://community.nocodb.com/t/removed-old-column-name-vendors-id-from-database-but-on-nocodb-ui-it-is-asking-for-the-column/1278 "2024-07-18T13:00:24Z")
I removed column named “vendors\_id” from database . But nocodb requesting for the removed column select "\_\_nc\_root"."id" as "corc0qszl073s25", "\_\_nc\_root"."technology" as "cglbtz63oqxjuog", "\_\_nc\_root"."recruiters\_id" a… --- ## [Import csv issue with a specific characters?](https://community.nocodb.com/t/import-csv-issue-with-a-specific-characters/1248)
**Author:** [@anthony.charrieau](https://community.nocodb.com/u/anthony.charrieau)\ **Replies:** 5\ **Last updated:** [June 28, 2024, 3:20pm UTC](https://community.nocodb.com/t/import-csv-issue-with-a-specific-characters/1248 "2024-06-28T15:20:30Z")
Hello, I setup my table on NocoDB Cloud and tested .csv import feature with a sample .csv file with few lines and it worked perfectly. I initiated the data import with the .csv file containing all my data (3312 rows / …