Skip to main content

Managing Your Uploaded Files

Once you've uploaded files to a Data Profile, Decode provides several tools to manage, inspect, and maintain them. All file management actions are accessible from the Data Profile Dashboard for the profile you're working with.

File Structure Overview

When you upload a spreadsheet to Decode:

  • The original file is stored as a Raw File.
  • Each worksheet within that file becomes a Cleaned Sheet after processing.
  • Both raw files and individual sheets can be managed independently.

Files and sheets are displayed in the Profile Dashboard, grouped by their current status (Needs Attention, Processing, Completed, etc.). You can expand any raw file card to see its individual cleaned sheets.

Available Actions

Downloading Files

Decode allows you to download both your original raw files and the cleaned/processed versions.

Individual Downloads:

  • Raw File: Click the download icon on a raw file card. If the file has cleaned sheets, Decode will bundle both the raw file and all its cleaned sheets into a ZIP file with separate raw/ and cleaned/ folders.
  • Cleaned Sheet: Click the download icon on an individual cleaned sheet card to download just that processed sheet.

Bulk Downloads:

  • Download All: Use the "Download All" button at the top of the Profile Dashboard to download every file (raw and cleaned) associated with the current Data Profile as a single ZIP archive.
  • Download Selected: Select multiple files or sheets using the checkboxes, then click "Download" in the selection toolbar to download only the selected items.

Deleting Files

Deleting files removes them from Decode and reverses any changes they made to your database table (undoing the diffs).

Deleting a Cleaned Sheet:

  1. Expand the raw file card to view its sheets.
  2. Click the delete icon on the specific sheet you want to remove.
  3. Confirm the deletion in the dialog.

The sheet's data contributions will be removed from the table.

Deleting a Raw File:

  1. Click the delete icon on the raw file card.
  2. Confirm the deletion in the dialog.

This will delete the raw file and all of its cleaned sheets, reversing all changes those sheets made to the database.

Bulk Deletion:

Select multiple files or sheets using the checkboxes, then click "Delete" in the selection toolbar to queue them all for deletion at once.

note

Files that are currently processing cannot be deleted. Wait for processing to complete before attempting deletion.

Recleaning Files

If a sheet encountered an error during processing, or if you've updated the Profile Mapping Values to better accommodate your file's schema, you can reclean the sheet to re-run the extraction and mapping process from scratch.

To reclean a sheet:

  1. Expand the raw file card to view its sheets.
  2. Click the refresh icon on the sheet you want to reclean.

Decode will reprocess the sheet using the current mapping values and AI extraction logic. The sheet's status will change to "Processing" while this occurs.

Manual Structure Override:

If the AI is incorrectly detecting your spreadsheet's structure (wrong header rows or data boundaries), you can manually specify the correct row ranges. Click the "Review" button on the sheet, then use the "Fix header/body rows" button to manually override the structure detection. This bypasses AI detection entirely and uses your exact specifications.

Viewing Diffs (Data Changes)

For sheets that have been successfully ingested (Completed status) or have failed, you can view the diffs—the numerical changes that sheet made (or attempted to make) to your database table.

To view diffs:

  1. Expand the raw file card to find a completed or failed sheet.
  2. Click the expand/details icon on the sheet card.

This opens a dialog showing the diff table: a record of rows added, updated, or modified when that sheet was ingested.

Mapping Preview:

For sheets with PreviewReady or Completed status, you can also click directly on the sheet card to open a visual preview of how the spreadsheet columns are mapped to your table columns.

Bulk Selection

The Profile Dashboard supports bulk operations for efficiency:

  1. Use the checkboxes on raw file cards to select entire files (including all their sheets).
  2. Use the checkboxes on individual sheet cards to select specific sheets.
  3. A selection toolbar appears showing how many items are selected.
  4. From the toolbar, you can:
    • Download all selected items as a ZIP.
    • Delete all selected items (queues them for deletion).
    • Clear the selection.

Summary of Actions by Status

StatusAvailable Actions
ProcessingDownload only (deletion disabled)
PreviewReadyDownload, Delete, Reclean, Review, View Mapping
MissingRowIdentifierDownload, Delete, Reclean, Review
CompletedDownload, Delete, Reclean, View Diffs, View Mapping
FailedDownload, Delete, Reclean, View Diffs

For guidance on reviewing files that need attention, see Reviewing and Approving Uploads.