Skip to main content

​
A lot of data is missing in the Superjoin preview. What do I do?

If you notice missing data in the Superjoin preview, follow these steps to ensure your full dataset is imported correctly. This FAQ guides you through preview limitations, importing all your data, and troubleshooting filtered or blank previews.
Quick fix: The preview only shows 100 rows by design. Click the Import button to get your complete dataset.

​
Why is my data preview incomplete?

Superjoin intentionally limits the data preview to 100 rows. The preview is designed for a quick snapshot—not to show your entire dataset.
This limitation exists for performance reasons and to keep the preview loading fast. Don’t worry—your complete data is still available for import.
Image needed: Screenshot showing the data preview section with 100 rows limit in Superjoin interface.

​
How do I get all of my data into Google Sheets?

1

Locate the Import button

Look for the Import button in the Superjoin sidebar or preview area.
2

Click Import

Click the Import button to load your full dataset into Google Sheets.
3

Wait for completion

All eligible data (not just the previewed sample) will be imported to your sheet.
The import process typically takes a few moments depending on your data size. You’ll see a progress indicator during the import.

​
What if the preview shows nothing after I apply a filter?

Don’t panic if your preview appears empty after filtering! This is a common scenario and doesn’t mean your data is missing.

​
Why does this happen?

The preview filter only applies to the first 100 rows. If your filtered values aren’t in those initial rows, the preview will appear blank. However, this does NOT mean your filtered data is missing!
Image needed: Screenshot showing empty preview after applying filter when matching data isn’t in the first 100 rows.

​
How can I confirm my data after importing?

1

Import your data

Click the Import button to bring in your complete dataset.
2

Check your Google Sheet

Navigate to your Google Sheet and review the imported data.
3

Verify filtered results

Often, records that were missing from the preview (because of the 100-row limit or filter location) now appear correctly in your sheet.
Image needed: Screenshot showing the full dataset after import, including filtered values appearing in the Google Sheet.

​
Summary & Best Practices

✅ Do This

  • Always click Import to get your complete dataset
  • Check your actual Google Sheet after import, not just the preview
  • Remember that previews are limited to 100 rows for performance

⚠️ Common Issues

  • Don’t panic if filtered previews appear empty
  • Don’t rely solely on the preview for data validation
  • Don’t assume missing data if the preview is incomplete

​
Troubleshooting Steps

If you still can’t find your data after import:
  1. Review your data source - Ensure the source has the data you expect
  2. Check your filters - Verify filter settings aren’t too restrictive
  3. Adjust connection settings - Try different field selections or date ranges
  4. Re-import - Sometimes a fresh import resolves sync issues
Still missing data after import? Contact Superjoin support with details and screenshots so they can assist you further.
⌘I