# Import Data The **Data Import Wizard** is used to import plate reader data from different sources into labrador. Those sources are `.csv` files from cerillo devices and labrador, **folders** from cerillo devices' SD cards, and **automatic** which is used for importing data from other plate readers or from marked up spreadsheets. The **Data Import Wizard** can be opened in three ways: 1. **Import Data** button on **Home** page 2. **Import Data** button in **Results** Page 3. **File** menu -> **Import Data** ![Import Type Select](../../_images/import-1.png) | Number | Element | Description | | ------ | --------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 1 | **Close** | Close out of the data import wizard, cancelling any imports started. Outside clicks will also close the wizard. | | 2 | **Next** | Moves on to the next step in the wizard. Steps depend on the **Import Type** | | 3 | **Import Type** | **CSV** - choose this import type if you are importing a `.csv` file exported from labrador or are importing a `.csv` that came from the SD card of a device. **Folder** - choose this import type when importing directly from the SD card from a Cerillo Device. This import type is useful because it will import the plate data saved along with measurements. This option only imports one experiment at a time. **Automatic** - choose this import type for external data not from a cerillo device or labrador. This step will update the wizard steps to more accurately import your data. | ![Import Data Format](../../_images/import-2.png) | Number | Element | Description | | ------ | ---------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 1 | **Previous** | Go back to **Import Type** step. | | 2 | **Next** | Moves on to the **Add Data** step in the wizard. | | 3 | **Plate Type** | Choose the plate type you are trying to import. Without selecting the proper plate type, import will most likely fail. | | 4 | **Data Format Select** | If your data is organized like a plate or table where rows and columns of the data represent the rows and columns of the plate, choose **Plate Format**. If your data is organized by rows or columns denoting a time and with readings across the row/column, choose **Timecourse/Kinetic Format**. Labrador will automatically detect whether the timecourse data uses rows or columns as the time axis. Different plate readers will output data differently, so make sure to choose the correct format that your data uses! | ![Add Data](../../_images/import-3.png) | Number | Element | Description | | ------ | --------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 1 | **Previous** | Go back to **Data Format** step. | | 2 | **Text Input** | Paste data into this field to import from your clipboard. | | 3 | **Import** | Will attempt to import data from the text pasted into the **Text Input** | | 4 | **Upload File** | Will open a window to choose a file to upload for import. File types generally accepted are `.csv`, `.xslx`, `.txt`. For `.txt` files, there needs to be a delimiter like a comma, space, tab or semi-colon. If trying to import a `.xlsx` file and it is not importing correctly, you can try pasting the data into the **Text Input** instead. Some `.xlsx` files with multiple sheets may not be parsed correctly. | :::{tip} If your automatic data is not importing correctly, it can help to paste only the measurements into the **Text Input** rather than uploading a file. ::: :::{note} If you have data files that fail to import correctly, we would love to improve our parsing algorithms to better import your data. Feel free to send files that failed to import to [support@cerillo.bio](mailto:support@cerillo.bio) with the subject "Import Data Failed" ::: ## Data Editing ![edit data button](../../_images/external-edit-data-button.png) For any external or non-cerillo experiment imported into Labrador, data editing tools are available to add or update data. For any external experiment, the **edit data** button will be available which will open up an editable data table overlay. ![edit data overlay](../../_images/edit-data-overlay.png) | Number | Element | Description | | ------ | -------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 1 | **Undo** | Undo the most-recent change to data | | 2 | **Redo** | Redo the most-recent undone change | | 3 | **Edit Data Format** | Edit the data format including the time interval unit, the plate type, and whether to input data in plate format (for an endpoint experiment) or in a kinetic format (as displayed here) | | 4 | **Clear Table** | Clear all data from table. **Undo** is available if this is clicked by accident. | | 5 | **Row Menu** | Click here to select the full row and open up the row menu | | 6 | **Copy Row** | Copy the contents of this row. Can be pasted with ctrl+v or ⌘v | | 7 | **Insert Above** | Insert a blank row above the currently selected row | | 8 | **Insert Below** | Insert a blank row below the currently selected row | | 9 | **Delete Row** | Delete this row | | 10 | **Table Cells** | Click an individual cell to edit it's contents. Click and drag to select multiple cells for deletion, copying (ctrl+c or ⌘c), or cutting (ctrl+x or ⌘x). Paste content into cells with ctrl+v or ⌘v. Content that can be pasted into the table includes data copied from the table as well as data from external programs like excel, numbers, or google sheets. | | 11 | Delete Experiment | Offers a way to delete external experiments. Confirmation required before deletion occurs. | | 12 | **Save** | Save data to experiment and close overlay. Clicking the **x** button will also save the data to the experiment. | Editing endpoint experiments works the same way as described above, but the interface will show the table in plate format as seen below, where the table matches a co-culture plate. ![edit endpoint](../../_images/edit-endpoint.png) ## Importing Cerillo Co-Culture Duet System into Labrador Data imported from an external data source can also be remapped to other plate types after the face. A common use case for this is importing co-culture data from another plate reader as a 96-well plate and then remapping it to a Cerillo Co-culture Plate, since we have that plate definition within labrador. This can be accomplished with the following steps: 1. Import the data either with the **external** option, or by starting with a **blank** experiment and pasting the data into the [edit data](#data-editing) table. Make sure to choose **96-well** as the plate type at this stage. 2. Go to the plate layout, and choose to remap the data to **Cerillo Co-Culture Plate** 3. Click **save** 4. Now, you should see that your data has removed the detectors covered up by the plate frame and should only see your sample data. At this point you can export your data or add your plate layout for visualization.