Import excel to web database

We are very happy to introduce Import from Excel functionality in My Task Helper. Previously you were only able to create your database from scratch. But now you can move from your Excel databases to online database in a few clicks.

Please, follow few simple steps:

Signup

Please click on it to view full-size image

Create new project (form)

Please click on it to view full-size image

Copy Excel data

Assuming you have Excel file. Copy it's content and paste to MTH.

IMPORTENT NOTE: if you have any carriage returns in your data cells it will break all import. Please, make sure to do not enter any tabulations or carriage returns in your Excel file. You will be able to do it in MTH then.

Import Excel

Press Import and you are on the go!

Records imported

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

Database widget

And you can easily integrate your data table to your own page with a few clicks.

Add more data to existent database

It is obvious that you should be able to update your data using Import at any time. You may want to add new records or update entries.

Add new records using Import

On Records page you should see Import link, using which you can add or update your data using Excel Import. Procedure is the same as when you migrating from scratch. Just copy your excel file content and paste to import text area. Remember that you should include also first row with column names. The order of fields doesn't matter, but presense of this fields on your form is important. Because if you don't have such fields they will be created. And if you renamed fields in Form Builder but not in Excel you will have twice more fields. Which is not what you want. But 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 key data matches. Choose column name (Unique field) to use 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 :)