📄️ How Cleaning Works
The core task during the review process is ensuring that the columns from your uploaded spreadsheet are correctly mapped to the columns defined in your target Decode Table. Decode uses a learning system called Possible Values to automate this process over time: the more you use it, the smarter it gets.
📄️ Correcting Mappings
The Mapping Table in the Preview Screen is where you ensure data from your spreadsheet flows correctly into your Decode Table columns. While Decode automates much of this, you'll sometimes need to review and make adjustments.
📄️ Manual Structure Override
Decode uses AI to automatically detect the structure of your spreadsheets—identifying where column headers begin and end, and where the data body is located. While this works reliably for most spreadsheet formats, occasionally the AI may misinterpret unusual layouts.
📄️ Approving the Upload
The final step in the review process for an uploaded spreadsheet sheet is Approving it. This action confirms that you are satisfied with the schema extraction, the column mappings (including any corrections or formulas you've applied), and the sample data preview.
📄️ Handling Missing Row ID
When you upload a spreadsheet sheet, one of the first things Decode tries to do is find and map the Row Identifier column you defined when creating the Table.
📄️ Mapping Header Data
Often, important contextual information isn't located in the main data columns of your spreadsheet but resides in the header rows at the top of the sheet. Examples include:
📄️ The Preview Screen
After Decode processes an uploaded spreadsheet sheet and its status becomes PreviewReady or MissingRowIdentifier, you need to review it before the data can be added to your Table. Clicking the "Review" button for that sheet in the Recent Uploads section will open the Preview & Mapping Dialog.