Import CSV data

[eriel...@erp-consultoria.com]

I've been keeping a diary in Excel and have a lot of data I'd like to import to SDD and keep using as my main app.

The data is in table form with date/time, food item, amount, calories, fat (g), sodium, carbs, and sugars.

Is there any way to avoid reentering everything?

[Martin Stone]

Short answer: No, sorry.

Long answer: Maybe... If you're a competent programmer, or have a friend who is, it would be possible to write a script of some sort that enters your CSV data into a database file that the app understands. You would start by exporting a blank database file from the app (Menu / Manage data / Back up to SD card). That file is a standard SQLite database file, which lots of software can read and write. You'd need a script that opens that database and inserts records into it based on your CSV data. The database isn't a single table like an Excel sheet though. For example, each identical food item is recorded only once, then referenced in a diary entry by its ID. Reorganising the data like that is the hard bit. If you got past that, you'd then have an updated database file which you could load into the app with Menu / Manage data / Restore from SD card. I'm happy to advise further if you really want to try that.