Quick Start Guide

This guide will walk you through your first experience with DB Table, from uploading a file to exploring and editing your data. You'll be working with your spreadsheets in just a few minutes!

Step 1: Upload Your First File

1. Open DB Table in your web browser
2. Click the "Upload File" tab (it should be selected by default)
3. Choose your file by either:
   • Clicking the upload area and selecting a file
   • Dragging and dropping an Excel (.xlsx, .xls) or CSV file onto the upload area

4. Click "Upload File" to process your data
5. Wait for processing - DB Table will automatically:
   • Parse your file structure
   • Detect column types
   • Prepare your data for viewing

Step 2: Explore Your Data

Once uploaded, you'll automatically switch to the "View Data" tab where you can:

Navigate the Table

• Scroll through your data using the table or pagination controls
• Sort columns by clicking on column headers
• Filter data using the search box in the toolbar
• Show/hide columns using the "Columns" dropdown

Understand Your Data Types

Look for the colored type indicators next to column names:

• 🔤 Blue: Text/String data
• 🔢 Green: Numbers
• 📅 Purple: Dates
• ✅ Orange: Boolean (Yes/No)
• 📊 Teal: Percentages
• 💰 Yellow: Currency

Switch Between Views

Toggle the "Show Formatted" switch to see:

• Formatted view: Data displayed with proper formatting (dates, currency symbols, etc.)
• Raw view: Original data as it appears in your file

Step 3: Use AI Analysis (Optional)

For better data type detection, try the AI Data Profiler:

1. Click "AI Data Profiler" in the toolbar
2. Review the suggestions - AI will analyze your data and suggest optimal column types
3. Apply suggestions by clicking "Apply All Suggestions" or review individual columns
4. See the improvements - Your data formatting will update automatically

Step 4: Edit Your Data (Optional)

To make changes to your data:

1. Click "Enable Editing" in the toolbar
2. Click any cell to start editing
3. Make your changes - DB Table provides type-specific editors:
   • Text fields for strings
   • Number inputs for numeric data
   • Date pickers for dates
   • Dropdowns for boolean values
4. Save or cancel your changes using the cell controls
5. Save all changes by clicking "Save Changes" when you're done

Change Tracking

• Yellow highlighting shows cells with unsaved changes
• Warning dialogs prevent accidental data loss
• Discard option lets you revert all changes

Step 5: Export Your Work

When you're satisfied with your data:

1. Click "Export" in the toolbar
2. Download begins automatically - your data is saved as a CSV file
3. File includes all your formatting and changes

Working with Multi-Sheet Files

If you uploaded an Excel file with multiple sheets:

1. Look for sheet tabs at the top of the data table
2. Click any tab to switch between sheets
3. Each sheet maintains its own formatting and edit state
4. Export downloads the currently active sheet

Next Steps

Now that you've mastered the basics:

• Learn about file upload options - Understand supported formats and limitations
• Explore data viewing features - Master sorting, filtering, and navigation
• Understand column types - Learn about automatic detection and manual overrides
• Master the AI profiler - Get the most out of AI-powered analysis
• Become an editing expert - Learn advanced editing techniques

Common First-Time Questions

"Why aren't my dates showing correctly?"

DB Table automatically detects date formats, but sometimes manual adjustment is needed. Try using the AI profiler or manually changing the column type to "date".

"Can I undo changes?"

Yes! Use the "Discard Changes" button to revert all unsaved edits, or disable editing mode to cancel current changes.

"How do I work with large files?"

DB Table handles large files efficiently, but for best performance with files over 2MB, consider filtering your data before editing.

"What happens to my original file?"

Your original file is preserved. DB Table only modifies the data in your browser session. Use the export feature to save your changes.

---

Having trouble? Check out our troubleshooting guide or explore specific features in the detailed documentation sections.