Importing CSV files

Download inside CSV Touch

To download a new CSV file, click the upper-left + button on the initial app screen:

  • Add using URL: Here you simply input an internet address pointing to your CSV file. Note that this must be a “direct” address; some cloud data providers do not provide direct addresses and instead the address will be redirected multiple times, and in these cases the address cannot be used.
  • Add using URL for list of files: Similar to the above, this should be a direct address to a file, but in this case the file should be a simple text files which in its turn lists a bunch of addresses, each pointing to a CSV file. So this use case is if you have a bunch of files to add, you can put all the addresses in a text file (one address / row) and load that file, instead of having to put in each address by itself.
  • Import local file: This will bring up the native iOS file picker interface, from which you can select any CSV file which will then be imported.

Importing a CSV file from another app

If you select a CSV file (or any text file) in other apps on your iOS device and this app supports opening/sharing of files, you will see CSV Touch in the list of apps which can open the app. Just select CSV Touch and your file will be imported. This works in e.g. the Files app, Mail, Messages and others.

Advanced usage

If you use Add using URL for list of files alternative above, you can also add additional data in this simple text file to update the app settings at the same time. This is intended for an administrator who wants to distribute the same CSV files to a set of people and to make sure the app settings are set to be able to parse the CSV files correctly.

To predefine the settings, after the list of CSV file addresses you should enter an empty row, followed by the actual settings, one setting / row. The settings are defined using a key+value, where you enter the key followed by a space and then the value. The available keys are:

encoding
smartDelimiter
delimiter
useGroupingForItems
groupNumbers
useMonospacedFont
showDetailsToolbar
safeStart
keepQuotes
showDebugInfo
useCorrectParsing           // This is the Alternative parsing setting
fixedWidthAlternative
useCorrectSorting
showInlineImages
numberSensitiveSorting
caseSensitiveSorting
literalSorting
clearSearchWhenQuickSelecting
nextDownloadTime
blankWordSeparator

As for the values, here are the not obvious ones (i.e. where the value is not a simple string or number):

  • Use 0/1 for OFF/ON, for keys corresponding to a on/off value.
  • encoding: Use the following integers for encoding values: UTF8 = 4, Unicode = 10, Latin1 = 5, Mac = 30.
  • fixedWidthAlternative: 0/1/2 <-> None/Predefined/Auto
  • To predefine which columns should be hidden for a downloaded file, simply input the column numbers (starting with 0 for the first column) after the file address. The format is a space directly after the file address, and then the hidden column numbers with a “,” between the numbers.

An example

This is how a file could look:

http://www.myfiles.com/csv/Films.csv 0,3,4,5
http://www.someotherplace.com/stuff.csv
ftp://username:password@ftpserver.someplace.com:80/username/files/collection.csv 10,11

encoding 4
smartDelimiter 0
delimiter ;