Tap Forms provides a wide variety of options for importing data from other applications. You can import both CSV text files and Excel XLSX worksheet files.
Before you can import a CSV file to Tap Forms you must export it from another app to a text file. The text file can have a .csv (comma separated values), .txt (text), or .tsv (tab separated values) file extension. These file types are all pretty much the same but contain slightly different column delimiters. Just make sure whatever column delimiter you use in the file, you set Tap Forms to use the same column delimiter.
Importing XLSX files requires only that you have the first row in your Excel file be the names of the fields you would like to be in your form. Tap Forms will also only import the first sheet of data from the XLSX file. Make sure your data is structured as regular rows and columns. Tap Forms will not import any formatting information from an Excel worksheet file. The benefit of an XLSX file is you don’t have to worry about things like column delimiters, line endings, or file encodings.
The first thing to do is click the Choose file button and then select a file you wish to import.
It’s very important to set the file encoding setting correct for the file you’re trying to import. If you don’t set it correctly, Tap Forms won’t be able to understand all the characters in the file you’re trying to import. This will most likely manifest itself in Tap Forms importing fewer rows than are actually in the file. Another issue that you might notice is strange garbage characters appearing instead of properly accented characters.
Tap Forms supports the following set of column delimiters: comma, semi-colon, tab, and pipe. Column delimiters help tell Tap Forms how to distinguish one field’s value from the next. If you have a delimiter within your data then you must put double-quotes around the value. For example “Rolling Stones, The”. Because there is a comma in the value, the entire value must be surrounded with double quotes. Mostly you never have to worry about this sort of thing because programs like Excel and Numbers should automatically put double quotes around any data that contains a column delimiter within it. Tap Forms does then automatically when you export records.
When you have a file that has dates in it, Tap Forms needs to be told how to interpret the date values. Is it month, day, year, or day, month, year? In order for Tap Forms to understand the date values in your file, you must tell it what format your date columns use. Tap Forms only understands date formats that are numeric based. So if you have a date in your file like “Dec 10, 2013” then you need to convert that to be “12/10/2013” or some other variation on a numeric date format. As long as it follows one of the formats displayed in the list of date formats in Tap Forms.
There are a couple Date & Time formats in the popup menu also. You can use these if your date has a combined date & time value within it that has the date and time separated by the letter T. For example, when Bento exports its Date & Time values it uses this format: yyyy-MM-dd’T‘HH:mm:ss
Time formats follow the same principal as date formats. Just make sure your time format is set to be the same format as what is contained within your CSV file.
Select a Form
You can either enter a name for a new form to be created, or if you already have a form that you’d like to import your CSV file into, select it from the list of available forms. If you select New Form, Tap Forms will create a new form for you using the field names from the first row of the CSV file.
Assign Field Types
It’s important to tell Tap Forms before you import a CSV file what the field types are that it is importing. This helps Tap Forms to properly interpret the data being imported. If you don’t do this and you try to change field types after then Tap Forms will appear to lose the values in the field for which you changed the type. The data is not gone, it’s just stored in a different column in the database.
Click the record navigator to flip through the records in your CSV file. This will help you to determine if you have your file encoding, column delimiter, and your date and time formats set correctly.
Click the Import button when you’re ready to start the import process.
Need more help with this?
Don’t hesitate to contact us here.