Saving a file for use in spreadsheets
Occasionally you may wish to export a LogTag® data file so you can analyse it in more detail using a spreadsheet program such as Microsoft™ Excel. You can choose between a few different options to achieve this:
- You can use the File - Save as command from the menu, and select the *.csv option.
CSV files can be read by most spreadsheet programs.
Please note that files created by LogTag® Analyzer may not always be true CSV files ( Comma Separated Values), as they use the list separator from the Windows operating system. It does however mean the file can be opened with MS Excel without going through the data import facility. To create a true CSV file select "Use custom list separator" and enter a comma in the adjacent field. You can also use the custom list separator to generate files for applications which require other list separator characters.
- Select the Data tab and press CTRL-C or click Edit - Copy from the menu. Open an empty worksheet in your spreadsheet program and select CTRL-V or click Edit - Paste from the applications's menu. The data will be pasted in the cells and you can save the file in the format of your spreadsheet program.
- Automatically export the data into a CSV file when a logger is downloaded. Please Exports and Reports for further details.
LogTag®