How to Export Nutrition Reports into Excel

By in
158
How to Export Nutrition Reports into Excel

The Genesis R&D Foods and Food Processor programs let you export reports as tab-delimited text files that you can either save as a .txt file or paste into other documents (such as an Excel spreadsheet). This is useful for sharing your nutrition analysis data in a simple, easily-accessed format.

This blog will quickly cover both options.

To export as text to a file

  1. Open your Report. This example uses the Multi-Column report.
  2. Select Export As Text > To File from the Report ribbon.
  3. Navigate to your destination.
  4. Click OK.
  5. This is what your text file will look like without any formatting:
  6. You can also open .txt files in Excel and format columns and tabs there:

a. Launch Excel (or your spreadsheet program).
b. Go to File > Open and choose your saved .txt file.
c. Follow the Import wizard to open the report in your spreadsheet.

To export as text to clipboard

  1. Open your Report
  2. Select Export As Text > To Clipboard
  3. Open Excel or another spreadsheet or word processing document.
  4. Go to Edit > Paste. It will look something like this:


Watch the tutorial