Try Foodworks for free
FoodWorks

Getting your FoodWorks data into Microsoft Excel

11 February 2020

It’s simple when you know how…

There are two ways to get your data into Excel – which way you choose depends on whether you have Microsoft Access or not.

In both cases, you start by exporting your FoodWorks database into Microsoft Access database format.

First Step – Export your FoodWorks data into MS Access data format

Whether you have Microsoft Access or not, you will first need to export your data into a Microsoft Access database. Here’s how:

  1. Open your FoodWorks database.
  2. On the Tools menu, click Export:
  3. The following dialog appears:
  4. Click the ellipsis button (…) to save your exported FoodWorks database to a location of your choice. Make sure to choose a safe and accessible location. (By default it will be saved in the FoodWorks folder in your Windows Documents.)
    NOTE: The two checkboxes in this dialog are for advanced use – unless you are a researcher or have red (missing) values in your analyses you can leave these blank.
  5. Then click Export.

Then, if you have Microsoft Access…

If you have Microsoft Access on your computer, to get your data into Excel:

  1. Do the First Step above to export your FoodWorks database into a Microsoft Access database.
  2. Open Microsoft Access.
  3. Open your newly exported FoodWorks database in Microsoft Access:
  4. Open the table you are interested in. (FoodWorks Nutrition Labelling users are usually most interested in the fw_labels table. FoodWorks Professional users are usually most interested the Documents or DocFoods table.)
  5. Select and copy the relevant rows.
  6. Open Microsoft Excel.
  7. Open a workbook.
  8. Paste in the data.

Or, if you don’t have Microsoft Access…

If you don’t have Microsoft Access on your computer, to get your data into Excel:

  1. Do the First Step above to export your FoodWorks database into a Microsoft Access database.
  2. Open Microsoft Excel.
  3. Open a workbook.
  4. Click Data, then Get Data.
  5. Select From Database, then From Microsoft Access Database:
  6. Select the table(s) that you want to import. (FoodWorks Nutrition Labelling users are usually most interested in the fw_labels table. FoodWorks Professional users are usually most interested in the Documents or DocFoods table.)

Try FoodWorks

Download free trial