This topic describes how to import data to an existing dataset in a LabKey study. Authorized users can add data a row at a time, or import data from spreadsheets or other data files. Imported data must match the structure of the dataset into which it is imported.
The following import methods are available:
Insert Single Row
- Navigate to the dataset of interest.
- Select (Insert Data) > Insert New Row above the dataset grid.
- Enter data for the fields.
- Fields marked with '*' are required.
- Hover over the '?' for any field to see more information, such as the type expected.
- If an administrator has limited input to a set of values, you will see a dropdown menu and can type ahead to narrow the list of options.
- When finished, click Submit.
Import from File
- Navigate to the dataset of interest.
- Select (Insert Data) > Import Bulk Data.
- To confirm that the data structures will match, click Download Template to obtain an empty spreadsheet containing all of the fields defined. Fill in your data, or compare to your existing spreadsheet and adjust until the spreadsheet format will match the dataset.
- To import the data from the file, click the Upload file panel to open it.
- Click Browse or Choose File to select and upload the .xlsx, .xls, .csv, or .txt file.
- Use the Import Lookups by Alternate Key if you want lookups resolved by something other than the primary key.
- Click Submit.
Import via Copy/Paste
- Navigate to the dataset of interest.
- Select (Insert Data) > Import Bulk Data.
- To confirm that the data structures will match, click Download Template to obtain an empty spreadsheet containing all of the fields defined. Fill in your data, or compare to your existing spreadsheet and adjust until the spreadsheet format will match the dataset.
- To import the data either:
- Click Upload File to select and upload the .xlsx, .xls, .csv, or .txt file.
- Copy and paste your tabular data into the Copy/paste text box. Select the Format (either tab-separated or comma-separated).
- Use the Import Lookups by Alternate Key if you want lookups resolved by something other than the primary key.
- Click Submit.
Related Topics
