How to parse a price from a file?

Question

Android

Good afternoon. Please tell me how and with what to parse a file (for example, excel) containing N rows and 2 columns ( name and price ).
In principle, I can put the price in any file (as it is easier to do this). But there will always be a kind of price list, for example, this:
Pants
500r Long pants 600r
, etc.
And it’s better to store this whole thing in sqlite too, apparently, before outputting to the necessary activity ... I still have to figure out how =)
I don’t really understand how to start solving this issue, maybe you can suggest a good article on this topic or share examples, experiences.
Thank you very much.

Answer 1

Try the .CSV format (everything transforms well into it from Excel)

Answer 2

The choice of format is a secondary issue and left solely to the choice of others.
The main question is HOW to parse ;)

Answer 3

XLS -> CSV -> SQLite