"Using Excel to Read and Import Data" matching MCP tools:

• firmaradar_get_regnskapsrapportA

  FirmaradarA

  Order a formatted, downloadable financial report (Excel or PDF) for a Norwegian company — the same multi-source-fused figures, layout and source note as the report a customer would download in the Firmaradar portal, ready to file or forward. Returns a short-lived download link + metadata (years covered, source, currency), NOT the file itself and NOT base64 data — fetch the download_url separately, no further auth required, within expires_in seconds. Use `get_company_financials` instead when you need the raw figures to reason about, not a document to hand off. Requires the Excel-export or PDF-export add-on (matching the requested format) on the caller's account. Charges 1 credit per financial year included in the report.

  ConnectorNo auth

• submit_enquiryA

  siteA

  Submits an enquiry to Car Import Calculator — NOT a purchase, NOT a guaranteed quote. Step 1: call with the answers (keyed by field key from enquiry_fields) and consent=true; it validates and returns a summary, the consent line and a confirmation token — show the person the summary and the consent line. Step 2: only if the person agrees, call again with the same answers, consent=true and the confirmation token; the enquiry is then submitted, and the person receives an email with a link they must click before any provider sees it. Consent means the person has read and agreed to: "Send my contact details to up to three relevant vehicle import agents, chosen by Car Import Calculator, who'll contact me directly. I'll be emailed each firm's name as my details go to it, and can stop any more firms getting them."

  ConnectorNo auth

• list_test_data_setsA

  RoutebaseA

  List the data sets of a test suite — the tables that drive data-driven runs. The list gives names and row counts; pass dataSetId to get one set including its columns and rows. Use this to browse data sets; to create, change or import one use manage_test_data_set. Requires project context.

  ConnectorAPI key

• list_libraryA

  DreamfareA

  Read what the traveler has saved: their places with folders, their travel-tips notebook, and the results of an import. Topic/area search can refresh missing or expired venue photos from public place providers without changing the saved entries. Pass importId to follow an import started by import_places: while status is neither done nor failed, call again after about 15 seconds. Pass query or area to search places and tips together, with the source each one came from. Pass folderName, type or sort to browse the places shelf itself, and offset with the returned nextOffset to continue. Tips are advice, never itinerary stops. Put library places on a trip with add_to_trip source=saved_places (by savedPlaceIds, folderName or importId), or plan days around them with plan_trip. Retains an account-bound result for 30 minutes for later display; does not start an import, spend credits or change library entries. Returns data plus display.resultId; call display_card to show it. presentation (optional) shapes what is shown without changing the action: compact or full layout, and only the limit, ids or sections this tool advertises.

  ConnectorNo auth

• upload_data_sourceA

  clariBI.comA

  Create a new data source from an inline base64-encoded file (CSV, TSV, JSON, Excel, TXT, PDF). The file goes through the same validation and preprocessing as a web upload. Returns the data_source_id you can pass to run_analysis as soon as preprocessing completes (poll get_data_source_schema for readiness or pass wait_seconds to block here).

  ConnectorNo auth

• get_componentA

  UploadkitA

  Fetch full metadata plus a ready-to-paste React usage example for one specific UploadKit component. When to use: once you know the exact component name (from list_components or search_components) and need to show the user how to drop it into their code. The returned "usage" field is copy-pasteable TSX including the correct import line and the styles.css import. Returns: JSON { name, category, description, inspiration, usage }. If the name does not match any component, returns a suggestion message with the 5 closest matches. Read-only, idempotent.

  ConnectorNo auth

• activate_projectA

  2oolsB

  Record the person's one-time choice to use this already-connected 2ools client with one exact saved project. Call only after the person approves in the inline card or explicitly in chat. This does not read or import local files and does not start work or a build.

  ConnectorNo auth

• ado_read_attachmentA

  ALM X++ MCP ServerA

  AZURE DEVOPS ONLY -- Reads the ACTUAL CONTENT of a file attached to a work item (Excel spreadsheet, Word document, text/CSV/JSON/XML file, or image). WHEN: a work item (FDD/RDD/CR/Bug/Task/User Story) has an Excel/Word attachment with requirements, field mappings, mockups, or specs that need to be read to understand the ask. Triggers: 'read the attachment', 'open the excel file on the work item', 'what does the attached document say', 'lis le fichier joint', 'ouvre l'excel du ticket'. Call ado_analyze_workitem first (or ado_query_workitems) to discover attachment file names if you don't already know the exact fileName. Supported: .xlsx/.xlsm (returns sheet names + a markdown table of the requested/first sheet), .docx (returns extracted markdown text + tables), .txt/.csv/.json/.xml/.md/.log (returned as-is), images (.png/.jpg/.jpeg/.gif/.bmp/.webp, returned as a base64 data URI for visual analysis, max 4 MB). Other binary formats (PDF, .pptx, .zip, etc.) are NOT parsed -- returns metadata + a manual download link instead. Max attachment size read: 25 MB. Requires DEVOPS_ORG_URL + DEVOPS_PAT env vars.

  ConnectorNo auth

• pdf_to_excel_inspectA

  John's EssentialsB

  PDF to Excel Inspector — Non-destructive scan of a PDF's tables before converting: per-table row/column counts, confidence flags, warnings. [category: pdf]

  ConnectorOAuth

• get_inquiry_statusA

  vipcarsA

  Check the processing status of an inquiry previously sent with send_inquiry, using the status_token from its response. The token is issued ONLY to the inquiry's creator — possession proves ownership; there is nothing to guess or enumerate. Returns ONLY the processing status, never any customer data. Status values: novo (received, not yet read), procitano (read by the sales team), odgovoreno (the team has contacted the customer), zatvoreno (closed).

  ConnectorNo auth

• import_scriptA

  LoadsterA

  Import an open-source load test (JMeter .jmx, k6 .js, or Locust .py) into an existing script, converting it to Loadster commands. An import may create script assets, datasets, and a scenario; replace=true also replaces the script's existing commands and variables. Returns action items to review. For OpenAPI/Swagger or Postman, read the spec yourself and build commands with create_script instead.

  Connector

  Destructive

  OAuth

• get_customs_country_tradeA

  China NMPA Medical Device DataA

  Query China merchandise trade by partner country/region, including all-partner totals using country TOTAL. Inputs: period, country and optional flow. IMPORT and EXPORT are China imports and exports; BOTH is recorded combined trade. Returns recorded trade values and units (currently 1000USD), scope, source_class, provenance, snapshot, pagination and limits. No commodity filter or currency conversion. No match returns an empty data array. Required: period, country. Missing required or invalid input produces an argument error.

  ConnectorNo auth

• get_customs_country_tradeA

  China Trade & Market DataA

  Query China merchandise trade by partner country/region, including all-partner totals using country TOTAL. Inputs: period, country and optional flow. IMPORT and EXPORT are China imports and exports; BOTH is recorded combined trade. Returns recorded trade values and units (currently 1000USD), scope, source_class, provenance, snapshot, pagination and limits. No commodity filter or currency conversion. No match returns an empty data array. Required: period, country. Missing required or invalid input produces an argument error.

  ConnectorNo auth

• get_testA

  UxiaA

  Read metadata for one accessible test using testId from list_tests: title, goal, status, type, source, creation date, version, result flag and Uxia link. Does not return findings, screenshots or session data; use result tools for those.

  ConnectorOAuth

• get_guideA

  QuillmA

  Returns the complete how-to for Quillm: the view code contract, a working template, the libraries you can import, styling rules, and dataset conventions. Read this once per session before you call create_view or update_view. It is short.

  ConnectorOAuth

• get_auditA

  webabilityA

  Check an audit started with start_audit: returns overall status, per-step progress (scan → viewports → screenshots → agent → excel → publish), and — once complete — a severity summary plus short-lived download URLs for the report (JSON) and the Excel workbook. Poll every ~15s while status is pending/running. Only the account that started an audit can read it. Free with a WebAbility account.

  ConnectorNo auth

• workbook_roundtrip_verifyA

  AINumbers Fintech Intelligence SuiteC

  Compares a WB-2 Spreadsheet Input Manifest (expected digests) against pasted-back CSV/TSV text per manifest range (observed, e.g. after a recompute in Excel) and returns an XLR-1 round-trip receipt -- `result: "match"|"mismatch"` plus a `mismatches[]` cell list when expected_by_ref text is also supplied. SAME comparator module as the tools/ round-trip page (XLR-2/XLR-3) -- byte-identical receipt for the same inputs. Paste-intake is untrusted: finite-gate (#NUM! for NaN/Infinity) and CSV-injection sanitization apply identically to WB-1's CSV import. Verify-only -- never operates Excel, never ingests .xlsx.

  ConnectorNo auth

• dmf_transform_excelA

  ALM X++ MCP ServerA

  Transform a multi-sheet Excel (.xlsx) into DMF-ready rows using a data-driven JSON mapping -- equivalent to FO_TransformExcelForDMF. NO FO credentials required (offline transform). Provide the workbook via ONE of: sourceUrl (Blob/SharePoint SAS URL or Graph downloadUrl), filePath (local .xlsx) or fileContentBase64 (inline upload, small files only). The mappingJson spec supports: sourceSheet, targetSheet, columnMappings {source->target}, conditionalValues [{sourceColumn,matches[],values{}}], staticValues{}, deduplicateOn[] and autoGeneratedFields (array OR object keyed by sheet, e.g. {"Products V2":["PRODUCTNUMBER"]}) which are removed so FO generates them. Returns CSV (default, feed to dmf_import_file) or JSON (feed to odata_upsert_rows). Set listSheetsOnly=true to just inspect the workbook's sheet names.

  ConnectorNo auth

• layerz_list_transactionsA

  LayerzA

  Returns a data source's staged transactions (API connector or csv/fec file import) annotated with their routing: the target item and whether a `rule` or an `auto`-created item matched, the skip reason otherwise (mapping is the only routing path, no fuzzy match), or `ignored` for a row an `__ignore__` rule routes nowhere on purpose. `period` (YYYY-MM) and `q` (substring on description/category) filter the rows. `format: 'csv'` returns instead a 24h signed `download_url` of the full staged import as a CSV file (no filters, no annotations). A materialized legacy import derives one row per owned cell from the model's input rows.

  ConnectorOAuth

• geocode_addressesA

  VepathosA

  Turn street addresses into latitude/longitude using Vepathos Smart Import. Requires a depot lat/lng or a city. Each stop includes matched_address (what the gazetteer matched) — use it to catch bad pins. Charges Smart Import quota, not route stops. When needs_confirmation is true, tell the user which ids are missing or uncertain before optimizing. Do not invent coordinates. Returns pins, or a geocode_id for get_geocode_result. It carries ADDRESSES AND NOTHING ELSE: a customer, phone, package count, weight, volume, note or delivery window sent here is dropped without a word. Rows carrying any of those are a delivery list, however few, and go to import_deliveries, which keeps them and geocodes them itself. Use this one for bare addresses: checking a handful, or placing a depot.

  ConnectorOAuth

• read_onedrive_fileA

  Higgs HubB

  Open one file and return what is in it. Text, CSV, JSON, HTML and code files come back as themselves; images come back as pictures the assistant can look at. Excel workbooks are refused in favour of read_excel_range, and PDFs and Word documents cannot be read yet. Get the id from list_onedrive_items or search_onedrive_items.

  ConnectorOAuth