# Ft Filter Csv Or Google Sheet By Url

**Use case:** 

Load a public CSV, Excel or Google Sheet by link, keep and rename the columns you need, map country codes to continent names, filter to two continents, sort and dedupe, then download the result as CSV and Excel. Uses the open country-codes dataset as a live example; swap in your own file link.

## Input

```json
{
  "fileUrl": "https://raw.githubusercontent.com/datasets/country-codes/main/data/country-codes.csv",
  "fileFormat": "auto",
  "data": [
    {
      "name": "  jane doe ",
      "email": "JANE@Example.com",
      "country": "US",
      "revenue": "$12,500.00",
      "active": "yes",
      "signupDate": "2026-03-14"
    },
    {
      "name": "Bob Smith",
      "email": "bob@example.com",
      "country": "GB",
      "revenue": 400,
      "active": "no",
      "signupDate": "2026-05-02"
    },
    {
      "name": "Ana Silva",
      "email": "ana@example.com",
      "country": "BR",
      "revenue": "2,300",
      "active": "yes",
      "signupDate": "2026-06-19"
    },
    {
      "name": "  Chen Wei",
      "email": "chen@example.com",
      "country": "US",
      "revenue": "n/a",
      "active": "yes",
      "signupDate": "2026-07-01"
    },
    {
      "name": "Sam Lee",
      "email": "sam@example.com",
      "country": "US",
      "revenue": 9800,
      "active": "yes",
      "signupDate": "2026-08-05"
    }
  ],
  "transforms": [
    {
      "op": "keep",
      "fields": [
        "official_name_en",
        "ISO3166-1-Alpha-2",
        "Continent",
        "Capital",
        "Currency_Name"
      ]
    },
    {
      "op": "rename",
      "from": "official_name_en",
      "to": "country"
    },
    {
      "op": "rename",
      "from": "ISO3166-1-Alpha-2",
      "to": "iso2"
    },
    {
      "op": "mapValues",
      "field": "Continent",
      "map": {
        "EU": "Europe",
        "AS": "Asia",
        "AF": "Africa",
        "NA": "North America",
        "SA": "South America",
        "OC": "Oceania",
        "AN": "Antarctica"
      },
      "into": "continentName"
    }
  ],
  "filters": [
    {
      "field": "Continent",
      "operator": "in",
      "value": [
        "EU",
        "SA"
      ]
    }
  ],
  "filterCombineMode": "AND",
  "caseSensitiveFilters": false,
  "lenientNumbers": true,
  "sortBy": [
    "country"
  ],
  "distinctBy": [
    "country"
  ],
  "exportFormats": [
    "csv",
    "xlsx"
  ]
}
```

## Output

```json
{
  "name": {
    "label": "Name",
    "format": "text"
  },
  "email": {
    "label": "Email",
    "format": "text"
  },
  "country": {
    "label": "Country",
    "format": "text"
  },
  "revenue": {
    "label": "Revenue",
    "format": "number"
  },
  "active": {
    "label": "Active",
    "format": "text"
  },
  "signupDate": {
    "label": "Signup date",
    "format": "text"
  },
  "summary": {
    "label": "Summary",
    "format": "text"
  }
}
```

## About this Actor

This example demonstrates how to use [Dataset Filter & Transform](https://apify.com/nerolabs/dataset-filter-transform.md) with a specific input configuration. Visit the [Actor detail page](https://apify.com/nerolabs/dataset-filter-transform.md) to learn more, explore other use cases, and run it yourself.


## How to integrate an Actor?

If asked about integration, you help developers integrate Actors into their projects.
You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready.
This Task's input is already configured above — use it as-is rather than inventing a new one.

- **AI agents and MCP clients** — the [Apify MCP server](https://docs.apify.com/integrations/mcp.md) at `https://mcp.apify.com` (remote, streamable HTTP, OAuth on first use).
- **Agentic workflows and local Actor development** — [Agent Skills](https://apify.com/.well-known/agent-skills/index.json) with the [Apify CLI](https://docs.apify.com/cli/docs.md): `npm install -g apify-cli`, then `apify login`.
- **JavaScript/TypeScript projects** — the official [JS/TS client](https://docs.apify.com/api/client/js/docs.md): `npm install apify-client`.
- **Python projects** — the official [Python client](https://docs.apify.com/api/client/python/docs.md): `pip install apify-client`.
- **Any other language** — the [REST API](https://docs.apify.com/api/v2.md).

For full API examples (JavaScript, Python, CLI, MCP, OpenAPI), see this Task's Actor page: https://apify.com/nerolabs/dataset-filter-transform.md

For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt).