Your existing data can be imported into Caspio during App creation or at any time from the Tools menu at the top. Regular data imports can also be scheduled via Tools > Data import/export tasks if the option is available in your Plan.

Caspio can import data files in the following formats:

• Microsoft Access files (.mdb and .accdb, all tables data types besides "Large number")
• Microsoft Excel files (.xlsx, .xlsm, .xltx, .xltm, .xlam)
• CSV (Comma Separated Values)
• Tab Delimited text
• Fixed Width text
• Caspio XML (every setting)
• Custom XML

One or multiple files of different formats can be compressed in ZIP format for faster upload. The maximum uncompressed size of each individual file is currently 512 MB.

The import process has two main steps: uploading your file and configuring the import. You can begin the upload and continue with other Caspio tasks and come back later and begin the import process from a message that will be posted in the messages area upon the completion of the upload process.

Uploading Data

1. To begin the Import process, select Tools from the main menu bar and click Import.
2. The pop-up window may look differently in various browsers. Click the Browse button to find and select the file you wish to import and click Next. This starts the upload process. Large files could take a few minutes to upload depending on your bandwidth. While the file is being uploaded, avoid closing the browser window because this will cancel the upload process but the screen displaying the progress provides you with a link to continue with other Caspio tasks.
3. Once the file is successfully uploaded, a confirmation message will display. Click Next.

Importing Data

1. If the file format is not automatically recognized, you will be prompted to specify file format and whether or not the first row contains field names.
2. The next step is to select the app where you want the data to be imported. Note that the default option is All Assets which may not be your desired choice.
3. Under Configure Objects, you will see a list of table(s) found in your imported file. Each table can be imported as a new table, or used to append or replace an existing table in your Caspio account.
   

Some or all of the following options may be available depending on the content of your account:

• Create New: Creates the table as a new object.
• Replace: Overwrites the data of an existing table and load the new data into it. Any new fields are added to the table design.
• Append: Adds the new data to an existing table. Any fields that don’t exist in the current table design will be added.
• Update: Updates the data of an existing table with the imported data.
• Update Design: Merges table designs without importing new data. Any fields that don’t exist in the current table design will be added.

Notes regarding unique fields:

• For Append and Replace, new data going into a field that is set to Unique cannot violate the uniqueness of the values of the table. Such records are skipped.
• For Update Design, the imported table cannot have a new field that is setup as Unique unless your destination Table is empty.
• For Update, the destination table dropdown only shows tables containing at least one unique field or Autonumber field. The Match by destination dropdown only shows fields that are unique.

Next Caspio imports your data. This process can take a few minutes depending on the number of records being imported. You can click Close to continue with other tasks. The import will continue in the background and the results will be available in the messages area. The unclaimed uploaded files stay in the messages area for 24 hours. Once the import is finished, the results of the import will be provided including any problems that may have been encountered.