Import data into Claris Studio

There's more than one way to bring data into Claris Studio.

Import a CSV file into a spreadsheet view

In a Claris Studio spreadsheet view, you can choose Table Actions > Import from CSV. This method is limited to importing 1000 records at a time.

  1. Go to Claris Studio and turn on Developer Mode if it's not on.

  2. Open an existing spreadsheet view or create a new one.

  3. In the spreadsheet, choose Table Actions > Import from CSV.

  4. In the dialog box, click to choose a CSV file or drag one here.

    For each field in the current spreadsheet, you can choose the fields in the CSV file to import.

  5. For each field in Claris Studio, choose the field in the CSV file to import, or deselect the fields you don't want to import into.

    If you chose to create a new spreadsheet, you can name and choose the type of each field.

    Note   Be sure to choose fields in Claris Studio with the field type that best suits the fields in the CSV file, because you currently can't change a Claris Studio field type after it has been created. For example, choose a number field for CSV fields that contain only numbers, so they'll be formatted and sorted as numbers.

  6. Click Import.

Import data with FileMaker Pro

In a custom app, you can choose File > Import Records > File to import data in one of several supported file formats into a linked Claris Studio table.

  1. In your custom app, add the linked Claris Studio table you want to import into, if it isn't present already.

    See Working with a Claris Studio data source.

  2. Choose File > Import Records > File, specify the file, then specify the fields to import.

    See Importing data into an existing file.