Any tools can generate datatype from string?

Python's pandas library essentially does this when creating a DataFrame object from a CSV file. Of course, it's not always correct, but may be a starting point for your use case.

Any sort of office suite would be able to do it, but the data types would be very limited. CSV itself is not standardized, and with a well-constructed spreadsheet wouldn't contain information such as a currency symbol that would make more advances data types possible.

Not exactly that but your first step should be to use magic to determine file type: https://en.wikipedia.org/wiki/File_(command)

ETL tools and similar things will generally have a go at this.

e.g. the Import Flat File wizard in SQL Server

Delimted File metadata tool in Talend

Basically they look at the first N rows and take a guess. If the guess turns out to be wrong its usually worse than not guessing at all.

In f# you could use type providers for that.

In C# there's source generators.

I am sure there are other options for other languages.

Yes. I built several of these before. The trick is to have a lattice of types at the ready.

If a 'guess' is sufficient, just guess that all the columns are strings.

If that's not correct or good enough, then a guessing is not a sufficient solution for this problem.