# Converting tsv to an OTU format for R **URL:** \ **Category:** Uncategorized\ **Created:** [September 4, 2021, 3:58pm UTC](https://forum.mothur.org/t/converting-tsv-to-an-otu-format-for-r/21111 "2021-09-04T15:58:43Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Aysha\_Ross](https://avatars.discourse-cdn.com/v4/letter/a/919ad9/32.png) [@Aysha\_Ross](https://forum.mothur.org/u/Aysha_Ross)\ **Post date:** [September 4, 2021, 3:58pm UTC](https://forum.mothur.org/t/converting-tsv-to-an-otu-format-for-r/21111/1 "2021-09-04T15:58:43Z")
I had 16S and ITS data sequenced for a study. I received that sequencing data back in a Excel file. I have been trying to run the data in R but I need it in an OTU format. I was told to use mothur to do this but I am completely lost as to how. Any help will be appreciated. Thank you. ---
**Author:** ![pschloss](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.mothur.org/pschloss/32/4_2.png) [@pschloss](https://forum.mothur.org/u/pschloss)\ **Post date:** [September 8, 2021, 4:54pm UTC](https://forum.mothur.org/t/converting-tsv-to-an-otu-format-for-r/21111/2 "2021-09-08T16:54:06Z")
Hi there Aysha, Is it sequences data (with all the A, T, G, C’s) or count/relative abundance data? Normally, sequence data comes in a fasta or fastq-formatted file. Regardless, your sequence provider should really be giving you the raw fastq data if you hope to publish these results. Having the fastq data will work best with mothur and make it possible to make you data publicly available when you publish. Pat ---
**Author:** ![Aysha\_Ross](https://avatars.discourse-cdn.com/v4/letter/a/919ad9/32.png) [@Aysha\_Ross](https://forum.mothur.org/u/Aysha_Ross)\ **Post date:** [September 9, 2021, 2:52pm UTC](https://forum.mothur.org/t/converting-tsv-to-an-otu-format-for-r/21111/3 "2021-09-09T14:52:13Z")
Thank you! I actually do have the fastq data.