Getting out data out of Sniffie and into Excel is easy! With the latest version of Excel (part of Office 365) importing data is as simple as pressing the export button, downloading the CSV file and opening it directly from the browser.

 

Price matrix export button pressed with CSV option hovered.
Price matrix export button.

Possible problems with older versions of Excel

If you’re not using Office 365 and the latest Excel (or have a default decimal separator as a comma), you may run into something that looks like this:

Don’t worry. Here are the steps and a video showing how to open the data in an older version of Excel (2013 in this case).

  1. Download the CSV file by clicking Export > Save as CSV.
  2. Open Excel and select Data > From Text (or Text/CSV)
  3. Select the file you just downloaded (something similar to Sniffie-Price-Matrix in your Downloads folder)
  4. Set the data type as Delimited. If your data contains non-english characters, set the encoding to Unicode UTF-8.
  5. Click Next.
  6. Set the Delimiter selection to Comma.
  7. Click Next.
  8. Set the decimal separator to a dot by clicking on Advanced and selecting . from the dropdown menu.
  9. Click OK, Finish, OK.

Note: Depending on your system, not all steps may be necessary. Try skipping some of the selections to see if your system can detect them automatically.