Import & Export Data

How to import data and export insights in Datastripes

Written By Vins

Last updated About 9 hours ago

Overview

Importing and exporting data in DataStripes allows you to move information between your spreadsheets and external sources, supporting a wide range of formats and advanced options for automation and customization.

Importing Data

  1. Click the Import button in the toolbar or right-click to use the context menu.

  2. Select your file (CSV, XLSX, TSV, or supported format).

  3. Preview the data and map columns if prompted. You can skip or reorder columns as needed.

  4. Choose the target sheet or create a new one for the import.

  5. Confirm the import. Data will be added to your sheet, preserving types and formatting where possible.

Advanced Import Options

  • Append vs. Overwrite: Choose whether to add data to existing rows or replace the sheet contents.

  • Header Row Detection: Automatically detect and use the first row as column headers.

  • Data Type Inference: DataStripes will try to infer number, date, and text types automatically.

  • Error Handling: Invalid rows are highlighted for review before finalizing the import.

Exporting Data

  1. Click the Export button in the toolbar.

  2. Select the desired format: PDF, HTML, or CSV.

  3. Choose which sheets and ranges to export (all sheets, current sheet, or selection).

  4. Configure export options (include formulas, formatting, or comments).

  5. Download the exported file or send it directly via email (if enabled).

Advanced Export Features

  • Multi-sheet Export: Each sheet is exported as a separate section in the output file.

  • Scheduled Exports: Set up automated exports to run at specific times and deliver to email recipients.

  • Custom Templates: Use export templates for consistent formatting and branding.

Tips & Best Practices

  • Exported files retain most formatting, formulas, and comments.

  • Use scheduled exports for recurring reports or backups.

  • Always review the export preview before confirming.

  • For large datasets, consider exporting only relevant sheets or filtered data.

Troubleshooting

  • If import fails, check file format and encoding (UTF-8 recommended).

  • For export issues, ensure you have permission to download files or send emails.

  • If data appears misaligned, review column mapping during import.

Import and export in DataStripes are designed for flexibility and reliability, supporting both simple and advanced workflows for all your data needs.