Use Power Query's M language to quickly fix names, remove hidden characters, extract numbers, and merge columns.

All in all, your first RESTful API in Python is about piecing together clear endpoints, matching them with the right HTTP ...

Python has made using Microsoft Excel much easier than it has ever been, and it isn't very hard to start using it yourself.