​

Import & Export

​

Export Data

​

Export Options

1. Run a query or open a table
2. Click the Export button in the toolbar
3. Choose your export format
4. Select destination and options
5. Click Export

​

Export Formats

id,name,email,created_at
1,"John Doe",[email protected],2024-01-15 10:30:00
2,"Jane Smith",[email protected],2024-01-16 14:45:00

[
  {
    "id": 1,
    "name": "John Doe",
    "email": "[email protected]",
    "created_at": "2024-01-15T10:30:00Z"
  },
  {
    "id": 2,
    "name": "Jane Smith",
    "email": "[email protected]",
    "created_at": "2024-01-16T14:45:00Z"
  }
]

INSERT INTO users (id, name, email, created_at) VALUES
(1, 'John Doe', '[email protected]', '2024-01-15 10:30:00'),
(2, 'Jane Smith', '[email protected]', '2024-01-16 14:45:00');

​

Exporting Query Results

1. Write and execute your query
2. Click Export while results are displayed
3. Only the displayed results are exported

​

Exporting Entire Tables

1. Click on the table in the sidebar
2. Click Export without applying any filters
3. Or run SELECT * FROM table_name and export

​

Exporting Structure Only

1. Open the table’s Structure tab
2. Go to the DDL sub-tab
3. Copy the CREATE TABLE statement

-- MySQL
SHOW CREATE TABLE users;

-- PostgreSQL
pg_dump -s -t users database_name

​

Clipboard Paste (CSV/TSV)

1. Copy data from a spreadsheet, text editor, or other source
2. Select a row in the data grid
3. Press Cmd+V to paste

• Quoted fields with commas inside (e.g., "New York, NY")
• Escaped double quotes (e.g., "He said ""hello""")
• Multi-line values within quoted fields
• Automatic header row detection (skips if column names match)

​

Import Data

​

Import Options

1. Click File > Import (or the Import button)
2. Select your source file
3. Configure import options
4. Preview the data
5. Click Import

​

Import Formats

[
  {"name": "Product A", "price": 29.99},
  {"name": "Product B", "price": 49.99}
]

​

Import Process

​

Column Mapping

• Auto-match: Columns with matching names are automatically mapped
• Manual mapping: Drag columns or use dropdowns to map
• Skip columns: Ignore columns you don’t want to import
• Default values: Set defaults for unmapped required columns

​

Import Modes

​

Data Preview

​

Preview Before Import

• First 100 rows of data
• Detected column types
• Potential parsing issues
• NULL value handling

​

Preview Before Export

• Total row count
• Estimated file size
• Data sample

​

Progress and Errors

​

Import Progress

• Rows processed / total rows
• Estimated time remaining
• Current batch

​

Error Handling

• Row number
• Error message
• Problematic data

​

Error Log

Row 45: Data too long for column 'name' at row 1
Row 89: Duplicate entry '[email protected]' for key 'email'
Row 123: Column count doesn't match value count

​

Compression

​

Compressed Export

• Enable “Compress with gzip” option when exporting
• Output file gets .gz extension
• Significantly reduces file size for large exports

​

Compressed Import

• TablePro automatically detects .gz files
• Decompresses on-the-fly during import (FileDecompressor.swift)
• No manual decompression needed

​

Best Practices

​

Exporting

1. Filter first: Export only what you need
   Copy

   SELECT * FROM orders WHERE status = 'completed' AND year(created_at) = 2024;
   
2. Consider file size: Use LIMIT for very large tables
   Copy

   SELECT * FROM logs ORDER BY created_at DESC LIMIT 100000;
   
3. Choose appropriate format:
   • CSV for data analysis tools
   • JSON for APIs/web
   • SQL for database migration
   • XLSX for sharing with non-technical users in Excel

​

Importing

1. Backup first: Always backup before bulk imports
2. Test with sample: Import a few rows first
   Copy

   -- Create test table
   CREATE TABLE users_import_test LIKE users;
   -- Import sample to test table
   
3. Validate data types: Ensure source data matches target columns
4. Use transactions: For critical imports, enable transaction mode
5. Disable indexes: For very large imports, consider:
   Copy

   -- Disable keys (MySQL)
   ALTER TABLE users DISABLE KEYS;
   -- Import data
   ALTER TABLE users ENABLE KEYS;
   

​

Troubleshooting

​

Export Issues

• Use LIMIT in your query
• Export in batches
• Choose a more compact format (CSV vs JSON)

• Verify database encoding
• Export with UTF-8 encoding
• Check for special characters

​

Import Issues

• Check delimiter settings
• Verify CSV has correct number of columns
• Look for unquoted commas in data

• Check date formats match database expectations
• Verify numeric values don’t contain commas
• Check for text in numeric columns

• Data contains duplicates for unique columns
• Consider using REPLACE mode
• Remove duplicates before import

• Import parent tables first
• Temporarily disable foreign key checks:
  Copy

  SET FOREIGN_KEY_CHECKS=0;
  -- Import
  SET FOREIGN_KEY_CHECKS=1;
  

​

Keyboard Shortcuts

​

Next Steps