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, 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 app within Quickbase, read about the Import from Table feature.
Limits
There is no hard limit on the number of records you export. Instead, limits are related to the total volume of data you export. This can vary - the number of fields and the volume data is in those fields can add up. For example, a text-multi line field could include 5 characters, or 500.
To export data from a table:
-
Open the table, then choose More - Import/Export.
-
Click Export a table to a file.
-
Select the table from which you want to export data in the Pick Table list.
-
Select an export format:
-
Comma Separated Values (.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 Values (.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.
-
-
Click Export to File after you make a selection.
Note: You can't export file attachments.