To export sample information from eLabJournal, you can export it as a PDF. Open the sample information sheet of the sample you want to export and click on the PDF button.
To export multiple samples, you create an export file to Excel. Navigate to Advanced Search in the Inventory and specify your search criteria. If you do not specify any search criteria, you can export a list of your entire sample database to keep that as a local back-up.
The searched samples are displayed in the search results of the advanced search. Click on Export to create a tab-delimited CSV file that can be opened with or imported in Excel.
You can open the CSV file directly in Excel, but depending on the settings in your Excel installation the data may not automatically separate into columns. If that is the case, save the file first to your computer and import the file into Excel. Open Excel and choose in the Data tab the import from text option
Browse to the saved sample export file and select it. A 3-step wizard in Excel will help you to import the samples in Excel. Choose in the first step the following settings:
- Delimited – data in the export file are separated by tabs and placed between quotes (“)
- UTF-8 encoding – if your sample contains special characters, make sure set the character set to UTF-8 to keep them in the export file.
In the next step, you can define how to separate the data and which text indicator to choose. Choose the option Tab and ” (double quote). In the preview window, the data should be separated correctly in different columns.
In the last step, you can define the data type should for each column. The default setting is standard. You can scroll through all columns to see if the preview of the data is accordingly. For most columns, the standard-setting is works alright. Only when there are punctuations (such as: ' or, or ") used that could be interpreted by a spreadsheet program as a separator these columns should be changed from General to Text. For columns that contain a date or date and time, make sure to change these columns to a date and select the date desired formatting.
Click Finish to complete export to Excel.