Don’t use spreadsheets to comply with Making Tax Digital
For businesses who maintain their financial records using a manual cashbook or spreadsheet you need to convert to a book keeping package which is MTD compliant, such as Xero, or adapt your existing system to an “API enabled spreadsheet cashbook”.
Read this post