This article explains how to export data from Quickbase tables. You can either export all table data to a file, or export only data included in data-entry fields. 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.
Limits
Exported data is compressed and zipped during transport. A table can have a maximum underlying size of 500MB. The compressed file being exported must be under 150MB. The number of records that can be exported within this limit will vary.
If your table exceeds these limits, you can either export the data using the RESTful API, or chunk your data into separate reports and export them individually.
To export data from a table:
-
Open the table, then choose More - Import/Export.
-
Select Export a table to a file to export all data, or select Export data-entry fields to a file to not include calculated fields.
-
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.
File attachments are not exported.