Google Docs Export

We have archived records on Google Docs going back 3 years with information for about 5000 contacts. The spreadsheets are not all uniform with some having more columns than others. We want all this data exported into excel with some kind of uniformity so that we can organise our email and text campaigns. Some of the data needs to be tidied up with spaces removed from phone numbers and and leading zeros added where required. A good understanding of google docs is essential and expertise with excel spreadsheets is required