Recipient address map export or download

[johnmagee]

We really need a way to download the content of a Recipient Address Map.  In the previous UI, the content could be copied in the browser. That is no longer possible and as our map has become larger it wouldn't have been easy.

This would be used for backup and for detailed review.  In the UI, many email addresses are not fully displayed

[toms]

Agree, luckily we migrated just in time to have the old UI - at least we have the search line now, but it still isn't as great as can be

[drew_coughlin]

Is there really no export function in the admin UI nor API endpoint to export complete recipient address map contents?  This is an absolute required feature if it doesn't yet exist!

[louis4]

There isn't an export function for this but with the new UI, copying and pasting is still possible but just a different way.

• Set "Rows per pages" to 50
• Scroll to the bottom of your recipient address map
• Click just before the R in "Rows"
• Scroll all the way up
• Hold shift and click on "Address"

You should be able to see the entire thing copied 50 at a time, paste inside a spreadsheet and clean up the data.

What I do is sort and filter to delete all the blank rows, create a column beside and type A/B alternating for each row to differentiate the Address and Map to Address.

I use Xlookup for the A or B in two other columns then paste Ctrl Shift V to get the raw values without formula.

Afterwards, I use concatenate(A1,",",B1) and drag all the way down to pull out the value in a single cell that you paste the raw value again in a separate column.

This final column allows you to use Bulk Add to recreate the map.

[rjmcnamara]

Does this method still work for you?   I'm pasting the entries into Excel and both source and destination address cells are not plain text -- they're objects where  half of each cell is obscured and the other half has the addresses.   Sorting seems to do nothing.  Copying cells likewise does nothing (though I can double-click the text within a single cell to copy it).

[khagen]

Same here

[ConnectIT]

We have over 600 addresses in ours, it's bad that we can't download the list as a CSV so I can send it for auditing. What's made worse, is we USED to have this function previously.

[dovops]

It's really annoying, but I found a way.  Just go to the routing page (which contains the link to the routes) -  (e.g. /u/2/ac/apps/gmail/routing) and once on the page where you would edit the forwarding rules, you can view-source (at least as of dec 25 2023), and search for an email address you know will be in there, and you'll find some javascript arrays buried in a function.

You should be able to play with those a bit (copy just that array of pairs of email addresses, and reprint them to the console as tab-delimited) then you can paste it into excel. Annoying but it works.

I did  it in a google sheet AppScript

var foo = [paste just the email array in here];

var str=""; foo.forEach(a=>{str+=`${a[0]}\t${a[1]}\n`;});

Logger.log(str);

Then you have the tab delimited array to copy into your google sheet. Better than nothing.