Can someone please explain the steps to create a file we can import?

When I go to physical inventory count there is a button that lets you import a .txt file.  We have our inventory count sheets and have typed them all into excel. Is there a certain format this all has to be in?

I cannot find a tutorial or anything in the help or online.

Thanks