This is data collected from the field on invertebrates:

What is the best way to organize this data (and metadata) in a spreadsheet so that it can be knit into Rstudio as a .csv file?

Invertebrate Data Sheet SITE Point Arena Date stun 23, 2021 Diver:_ Allison Visibility (m) - 10 Buddy: Ryleigh Count all orgs. > 2.5 cm Transect#: Transect# 2 10 Minute goal (30 x 2 m) Time: Beg: 8 43 End: 9:42 Time: Beg: 9:45 End. 9:55 0 ed abalone (size cm) 14 x2, 6 75. flat abalone (size cm) 4.5 2.5, 11, 45 pinto abalone (size cm) green abalone (size cm) pink abalone (size cm) 5 8, 12.5 Unknown abalone CA spiny lobster CA sea cucumber 141 Cucumbers " warty sea cucumber 11 bat star Sea Stars short spined sea star giant spined star sun/sunflower star chestnut cowry Kellet's whelk wavy / red turban snail Crabs | Slugs/snails giant keyhole limpet rock crab sheep/masking crab gumboot chitor rock scallop arge anemone (> 10cm) brown/golden gorgonian (10cm) Gorgonians red gorgonian (> 10 cm) red urchin Urchins purple urchin crowned urchin Other/comments Black ab (Y/N) White ab (Y/N) Subsample abundant organisms: at -50, stop counting and record distance surveyed along transect (meters)Invertebrate Data Sheet SITE Point Avena Date Jun 23, 2021 Diver: Visibility (m) ~low Buddy: Ryleigl Count all orgs. > 2.5 cm Transect#: 3 Transect#: + 10 Minute goal (30 x 2 m) Time: Beg. lo Do End: 18: 11 Dist Time: Beg: 10:15 End: 10 25 Dist ed abalone (size cm) 3 .5 , 5 , 8.5, 3 , 145 * 2 , 11 * 3 , 9 .5 , 4.5 10 * 3 15 x 3 -17 flat abalone (size cm) pinto abalone (size cm) green abalone (size cm) 10.5 45 Abalones pink abalone (size cm) 9.5 Unknown abalone CA spiny lobster CA sea cucumber Cucumbers " warty sea cucumber bat star Sea Stars short spined sea star giant spined star sun/sunflower star chestnut cowry Kellet's whelk wavy / red turban snail Crabs | Slugs/snails giant keyhole limpet rock crab sheep/masking crab gumboot chitor rock scallop arge anemone (> 10cm) brown/golden gorgonian (10cm) Gorgonians red gorgonian (> 10 cm) red urchin Urchins purple urchin 11 crowned urchin Other/comments Black ab (Y/N) White ab (Y/N) Subsample abundant organisms: at -50, stop counting and record distance surveyed along transect (meters)