Query locations by type, export?

Overpass-API is good for this type of query. Here's a quick example using Overpass Turbo to select the area of the query:

[out:csv(name,::lat,::lon)][bbox:{{bbox}}];
nwr[shop=mall];
out center;

It may be necessary to add more tags to really find all malls, depending on how they are tagged in the area of interest. This can be done by replacing the nwr[shop=mall]; line with a union. For example, this query also returns areas tagged as commercial landuse:

[out:csv(name,::lat,::lon)][bbox:{{bbox}}];
(
  nwr[shop=mall];
  nwr[landuse=commercial];
);
out center;

You may also want to add additional tags to the csv() block. Each one will show up as a column in the result.