How to Export Records from a Database to CSV

Exporting records from Databases to CSV allows you to analyze data externally and generate custom reports more easily.

1st Step: Accessing the Databases Module

In the upper left side menu, click “Databases” to open the list of databases.

Select the desired database to view its records.

2nd Step: Applying Filters (Optional)

If you want to export only a subset of records, click the “Filter” button represented by the funnel icon in the upper right corner.

Configure Field, Operator, and Value to refine the records list.

3rd Step: Exporting Records to CSV

1. At the top of the records list, click the “Export to CSV” button represented by the download icon.
2. A dialog window will be displayed requesting export confirmation.
3. Click “Confirm” to generate the CSV file.
   

4th Step: Downloading and Verifying the CSV File

1. The download will start automatically, and the file will be saved in the downloads folder (e.g., octapipe-database-records-20250616.csv).
2. Open the CSV in a spreadsheet editor to validate the content. It will contain columns such as:

• uuid (record universal unique identifier)
• name (record name)
• base_de_dados_name (database name)
• owner_user (record owner)
• creator_user (user who created the record)
• cf_<custom_field_uuid> (database custom field)
• base_de_dados_uuid (database universal unique identifier)
• owner_user_uuid (owner user universal unique identifier)
• creator_user_uuid (creator user universal unique identifier)
• created_at (creation date and time)
• updated_at (last update date and time)

Best Practices:

• Filter before exporting to retrieve only the desired records.
• Check “created_at” and “updated_at” dates for time-based reports.
• Protect the CSV if it contains sensitive data.
• Update exports regularly to keep external reports synchronized.

Conclusion:

You have learned how to export records from a database to CSV, from selection to validating the generated file. If you have any questions, contact our support team.