What's the difference between `raw` and `formatted` data during export?

Table export is in beta testing. Contact us if you want to test it out!

Sometimes, there’s a choice between formatted and raw and data. How do they differ?

  • The formatted variant displays the data like you see it on the page — so it would be easier to make it into a table in a document. This format is visually pleasing, but not as convenient for data analysis. In the ‘formatted’ variant, the locations are usually columns, and the data is in rows. In data analysis, this is sometimes called the “long” form.

  • The raw variant creates a spreadsheet where the data is in columns, and the locations are the rows. This form is nicer if you want to aggregate data from many notebooks, or do more sophisticated data analysis. In data analysis, this is sometimes called the “wide” form.