No code › Get short Wikipedia summaries
Get short Wikipedia summaries in Excel and Google Sheets
One-line description and summary for every name in a list. Put the list in a spreadsheet, Radar fills in the answers. 500 checks a month free.
What you get for each topic
descriptionextracturlExample: Eiffel Tower
Check a whole list now: upload Excel or CSV
Google Sheets
Once: Extensions → Apps Script → paste this script, put your key in line 9, Save. Then:
No script at all: =IMPORTDATA("https://radarbg.com/v1/cell/wikipedia-summary?format=csv&key=YOUR_KEY&value="&ENCODEURL(A2)) gives the whole answer row.
Excel (Windows) and LibreOffice
Change field= to any column above. The key is visible inside the formula: use a separate free key for files you share.
Automatic: n8n, Make, Zapier
Download the n8n workflow (n8n → Import from file → paste your key). Make: HTTP → Make a request; Zapier: Webhooks → POST:
Developers: full API page · docs. Rather not do it yourself? We do the list for you.
Get your free key
500 checks a month free, no card. The key arrives on the next screen. More: €9 a month for 5,000, €29 for 25,000 (all plans).
Questions
How do I get short Wikipedia summaries in Google Sheets?
Paste our script once (Extensions → Apps Script), put your free key in it, then type =RADAR("wikipedia-summary", A2) next to your list and drag it down.
How do I get short Wikipedia summaries in Excel?
In Excel for Windows use =WEBSERVICE("https://radarbg.com/v1/cell/wikipedia-summary?field=description&key=YOUR_KEY&value="&ENCODEURL(A2)). On a Mac, upload the file on this page instead.
Do I need to know programming?
No. Upload a file, or paste one formula in Excel or Google Sheets. The key is just a password-like code that counts your checks.
How much does it cost?
500 checks a month are free with no card. Then €9 a month for 5,000, €29 for 25,000 or €79 for 100,000. One key works for every check and for our API.
What counts as a check?
One value that got an answer, for example one IBAN. Values without an answer are free, and the same value again within 24 hours is free, so a sheet that recalculates does not use up your checks.
Is my data safe?
Only the value in the cell is sent, nothing else from your sheet. Uploaded files are deleted after 72 hours and never shared. We never ask for passwords.
Where do the answers come from?
From official and public sources: EU VIES for VAT, the Deutsche Bundesbank file for German banks, EU and UK customs tariffs, OFAC/EU/UK/UN sanctions lists, official address registers and the domains' own records.