Arduino SD Card and Data Logging to Excel Tutorial 

So true!

I agree.

Yes, you can really see that he puts lot's of time into it. Thank You!

@Armani Uriel so cringe usinge those type of methods to spam

Thank you!!! I swapped them and it works.

@@saucerset12 Most welcome Kev. Thanks for sending this message here.

Yes, I understand. But I see you put a lot of effort into your videos and this is something I lack in it. Maybe you should consider it in future - just like a quick summary, so viewers could get better idea of how FAT system and etc works. Of course if its in your capabilities.

You should seriously have many more followers!. As an engineer, Im amazed!

you ever find an answer?

NeoIsTaken not yet

MOSI,MISO,SCK are fixed pins. look up your board's pin definitions. In UNO they are pins 11,12,13.

did you get yours to wok?

@@camerongordon2378 yes. I have it working on uno, not on mega. I didn’t try the excel part, i only cared about it initially working.

You should create aditional file on your sd card, named init settings where you will write every loop cycle, status of your logging device and initialization parameters at start-up, after then you need to parse each pair key = value, to get the desired values. Another more expensive one is depend on how you parse the logging data. If your file contains the most recent data at the top or at the botom. If you write append to the logging file, the recent data will be at the most end of the file, in this case you will need to request filesize in bytes and set up the pointer/cursor at this location-1. Make a while loop and compare current byte char against comma or newline 0xA and if is not found, store in a char array current byte char and decrement pointer to next char until this delimiter will be found. Now you have your last value as a char array data, use a function to convert this to a integer eg. strtoi and use your last value. The first option with a separate ini file would be very efficient to keep track of your device at runtime for recovery after an unexpected shutdown.

You think you can also log in power draw for each loop cycle?

how many times I can write/erase data to sd card?? because eeprom doesn't support many times.

yes

Thanks!

how do i connect everything?