TablePlus Documentation
  • Overview
  • Getting Started
  • GUI Tools
    • The Interface
      • Quick Look
      • Menu
      • Toolbar
      • Left sidebar
      • Right sidebar
      • Console Log
      • Query Editor
      • Multi Tabs / Workspaces / Windows
    • Open Anything
    • Code Review & Safemode
      • Code Preview
      • Commit changes
      • Discard changes
      • Safe mode
    • Connections & Command Line (CLI)
    • Database
    • Working with Table
      • Table Basics
      • Row
      • Column
      • Constraint
      • Index
      • Trigger
    • Filter
    • Database Objects
      • Function
      • Procedure
      • View
    • Import & Export
    • Backup & Restore
    • User Management
    • Metrics board
  • Query Editor
    • Editor Basics
    • Multiple Carets
    • Query Favorite & Keyword Binding
    • Query History
    • Streaming Results & Async Loading
    • Autocomplete
    • Split Panes
    • Split Results into Tabs
    • Working With Query Results
    • Format query (beautify/minify/uglify)
    • Query Parameters
    • Customize Query Editor
  • Preferences
    • General
      • Application
      • Table Data
      • SQL Editor
      • CSV File
      • Connections
    • Fonts & Colors
    • Crash & Security
    • Keymap
  • Utilities
    • Plugin
    • DBngin
    • Shortcut Keys
    • Licensing
    • Troubleshooting
Powered by GitBook
On this page
  • Import Data
  • Export Data

Was this helpful?

  1. GUI Tools

Import & Export

PreviousViewNextBackup & Restore

Last updated 5 years ago

Was this helpful?

Import Data

To import data from a CSV file to a table:

  • Navigate to File > Import > From CSV...

  • Or right click on the table on the left sidebar and choose Import > From CSV...

You can import a CSV file and choose to create a new table if it doesn't exist.

To import data from a SQL dump file:

  • Navigate to File > Import > From SQL Dump...

  • Or right click on the left sidebar and choose Import > From SQL Dump...

Export Data

You can export data from the current database to a CSV, JSON, or SQL file.

  • Select table(s), navigate to File > Export

  • Or select table(s), right click and choose Export...

  • Specify the file output and click Export... button so save it on your disk.