You can upload or import any spreadsheet file or database file that you have from your computer into Keep&Share. Keep&Share can store any type of PC or Mac native file. All Table Documents that you want to import into Keep&Share must be in .CSV format. This is a standard file format for any spreadsheets from other programs such as Excel.
Note that “CSV formatted” is used as short hand for text files that confirm the following rules:
- One row per line (with or without column names in row one).
- Cells in each row separated by a separator character (comma, semicolon, or tab).
- Any cell containing a separator must be enclosed by double-quotes.
- If a cell contains a double-quote character, that is “escaped” by being preceded by another double-quote. For example (ex. The book “David Copperfield” was written by Charles Dickens) would be placed in the file as this: The book ““David Copperfield”” was written by Charles Dickens
There are two ways you can import Table Documents into Keep&Share: by using the “New Document” command and by using the “Upload Files” command.
Importing tables using the “New Document” dialog
Importing a Practice Table
At the bottom of the “Import Table” screen is a command at the bottom to “Import Practice Table.” This will import and create a table filled with some fake sample data. It's a great way to quickly create a table that you can practice with. You can create as many practice tables as you want. Be sure to try normal editing of content, saving and then also try using the “Edit Structure” screen on this practice table.
“Preview Import” screen
Unlike with the “Upload Links” in the first importing table method, using the “New Document” dialog will give you an extra “Preview Import Screen” after you click on the “Import Table” button.
In the Preview Import Screen you can:
- Edit the name of the table you are creating by changing the first text field by “Table Name.”
- But if the format is not right, you can change the Column Delimiter drop-down menu at the bottom.
- You can also edit the raw data and correct any problems in the first row by editing in the bottom pane. Click the “Update Table from Text Box” button to preview these edits.
- If the format of the data is correct, you can finish importing by clicking the “Finish Import” at the bottom.
The first row contains column names: Some CSV files will have column names in the first row & some will not. If yours does not, then the first row of data will show up as column headers when this screen comes up. If this is the case, uncheck this box and your first row of data will be restored as data. Default column names will be generated.
Note that you cannot make any changes concerning the column attributes (type, format, width, etc.) on this screen. Those changes have to wait until the next screen. Click Finish Import to continue.
Once you click on the “Finish Import” button, you will be taken to the Table Structure and Colors screen.