English Español Deutsch Italiano Polski Nederlands Português Français 中文 日本語 हिन्दी اللغة العربية Русский Українська עִברִית Ελληνικά Türk Latvietis Dansk Norsk Íslenska 한국어 Suomen Gaeilge Bahasa Melayu Svenska Čeština
Log In

Log In


How to import Excel and CSV files to online database

You can start working in QuintaDB from uploading your existent CSV or Excel database. You just select your file from your PC and QuintaDB will create web-form based on your spreadsheet and database with same rows as you had in Excel

How can you import your Excel or CSV database to QuintaDB?


Import Excel file to web database


Assuming you have an Excel file, load it to QuintaDB using the Import form.


Please, notice that your columns now represent form fields. All your data is located on the Records page.

Import CSV to QuintaDB database

If your data is saved in CSV file you still can import it to the online database. All process is just the same. Only make sure your data is separated by comma: Column1, Column 2, Column 3

Also, if you have some issues while importing your Excel file, like blank records and unknown column names - most probably this is because you have data in your excel cells with new line breaks. You will be able to create your online database from CSV then.

Number of records per page

In order to change the number of records per page go to Records menu and find Records per page slider in the left side menu:

Find duplicates

If you need to find same records in the table, you can use "Find Duplicates" function.
You can find it in the "Import" menu.

Choose the column and press on "Search button". 

Using the "Remove all duplicates" button you can delete all duplicates.

Add more data to the existent database

It is obvious that you should be able to update your data using Import at any time. You may want to Create new records or Update existing records when key data maches.

Add new records using Import


On the Records page you can see the Import link, using which you can add or update your data using Excel Import. Procedure is the same as when you migrate from the scratch. Just upload your excel file. Remember that file should include the first row with column names.
The order of fields doesn't matter, but presence of thess fields on your form is important, because if you don't have such fields they will be created. And if you rename fields in the Fields menu but not in Excel you will have twice more fields, which is not what you want. Using this trick you can update your database structure along with adding or updating records.

Update records using Import


Also you can update existing records when the key data matches. Choose a column name (Unique field) to use it as a key for comparing data.
If your new record contains the same value in this column as one of your existing records, the existing record will be updated with the new data. If no match is found, a new record will be created.

Remember that you always can export your updated data back to Excel or PDF.

To remove all records from the database go to the Records menu and find the button Delete all records under ‘Actions’ DropDown.
Please, see the screenshot below:

Be careful, you cannot recover deleted files without backup.

Please, login to QuintaDB to be able to post comments


How do you import Boolean data from excel into quinta?

Igor Nosovskiy

Thank you for testing QuintaDB service!
There is no such possibility, yet.
You can import it as a Single line field, then change the field type on DropDown or Radio button and enter your values in the list of values.

Newton Malerman

I have 3 fields for photo images: Main Image, Detail1, and Detail2.
I am uploading my fields using an Excel comma separated export and find that photos cannot be exported in that file from Filemaker.
Is there any way that I can now import my photos by ID#? Or do I have to copy and paste them one at a time?

Igor Petrushenko

Hi, Newton!
We couldn’t import files by url.
However if your files hosted somewhere you can enable option for URL field to render that image in the table cell.

Or you can upload multiple files from your pc using ‘Import multiple files option’.

Share the discussion in the social networks: