If you already have copious amounts of data, it can take quite a bit of time to create a table with all the fields required to take in that information, as well as manually creating each row through the interface.
To help you get started and moving fast, jestor allows you to create tables from Google Spreadsheets, setting up field types and uploading data with just a few clicks. Just make sure data is organized and set the field types before importing: we take care of the rest.
We understand that sometimes you may have a lot of legacy data and that just uploading it would probably put you in a usage tier that doesn't reflect your daily operation. To help you settle things down inside jestor without worries, importing data through the feature below will only count as one single action.
To create a table from a Google Spreadsheets file, first you must organize the information in the proper format. Don't worry too much: chances are, your spreadsheets are probably already organized in a similar manner.
Basically, there's only two things you have to worry about:
- The spreadsheet organizes information in a table structure. That is: having a header with column titles, with each column being a type of information and each row being a separate data entry;
- All the information you want to upload to a table must be contained on a single tab of the spreadsheet.
To give you a clear example, this is a proper format for uploading:
This, however, is not:
Once you're done organizing the data, it's time to create the table and upload it!
You can do that by clicking on the + icon on the menu and selecting Import Data.
After that, select your Google account, the spreadsheet file and the tab which contains the data you'd like to import.
We're almost there! Now, just click on "Validate Fields" and jestor will automatically sort your data into a new table, showing you a preview with suggestions of field types that seem to make sense for each kind of information.
You can now change the name of your table, as well as the name and type of the fields. That way, if jestor suggests Short text as a field type, but you think that kind of information makes more sense as a Single select field, you can just correct it before your upload.
When everything's just the way you like it, click on "Finish". This will start the process of creating your table and uploading your data. Don't worry if it's a lot of information to upload: you can keep using jestor normally while it's importing your data, and you can also cancel the import before it's done if you'd like to change something.
As soon as it's finished, you have a brand new table with all your data!
Did we mention that all of this counts a one single action? This is a great way to build the initial structures for your jestor in a quick, efficient manner.
Updated 4 months ago