Exporting Data Out of QuickBase

You can export data out of QuickBase one table at a time. To do so, you'll save each table's data in a text file format (one of those listed in Step 6 below), which lets you transfer your data to outside spreadsheets or database applications. If you want to export a subset of data (like records you've collected in a report) instead, you can do that too. (Read how.)

Tip: If you want to export data to another application within QuickBase, read about the Import from Table feature.

To export a table's data:

1. Open the application from which you want to export data.
2. In the menu bar on any application page, click Customize > Import/Export.
3. Click the Export a table to a file radio button.
4. If you're exporting from a multi-table application, select the table from which you want to export data.
5. Select an export format:
   • comma-delimited (.csv) Saves records in text format. Fields are separated by commas and records are separated by a carriage return. Most database programs understand this format, so this kind of file is one of the most commonly used to move data between different programs. Use this format if you're exporting to a spreadsheet program.
   • tab-delimited (.tsv) This file is just like a comma-delimited file, except that tabs separate field values instead of commas. This format is also good for export to a spreadsheet program.
   • XML (short for Extensible Markup Language) output also creates a simple text file, but this file uses descriptive tags to separate fields and records.
   When you've made a selection, click Export to File.
6. Save the file. If you're exporting to an XML file, the file displays in your browser window. From your browser's menu, select File > Save As to save the file. (If you're using Mozilla Firefox, select File > Save Page As instead.) If you're exporting to a comma-delimited or tab-delimited file a File Download dialog box displays. Click Save to display a Save As dialog box. Enter a name and location for the exported file, and then click Save. When the download completes, click Close. (If you're using Mozilla Firefox, click Save to Disk instead.)

Note: You cannot export file attachments.