# CSV Import Previewer (`autosecurelogin/csv-import-previewer`) Actor Preview creates, updates, unchanged records and errors in a CSV import against your supplied snapshot. Download a row-by-row review without database writes. - **URL**: https://apify.com/autosecurelogin/csv-import-previewer.md - **Developed by:** [Hunter Melnick](https://apify.com/autosecurelogin) (community) - **Security:** Limited permissions - **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks - **User rating**: No ratings yet ## Pricing $0.05 / actor start This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events. Learn more: https://docs.apify.com/actors/running/actors-in-store.md#pay-per-event ## What's an Apify Actor? An Actor is a serverless cloud program that runs on the Apify platform. It has two run modes. In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours, and optionally produces a well-defined JSON output, datasets with results, or files in key-value store. In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server. Apify vocabulary and the platform model are defined once, in the agent quickstart at https://apify.com/agents.md. ## 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. Do not guess an integration path. Every one of them is in the agent quickstart at https://apify.com/agents.md: the Apify MCP server, Agent Skills with the Apify CLI, the JavaScript and Python clients, the REST API, and the account-free path for an agent with no human to sign in. It also carries the rule on stating cost before the first paid run. For examples already wired to this Actor's own input schema, see the [API](#api) section below. Each client library has reference documentation the quickstart does not restate: [JavaScript/TypeScript](https://docs.apify.com/api/client/js/docs.md) (`npm install apify-client`) and [Python](https://docs.apify.com/api/client/python/docs.md) (`pip install apify-client`). # README ## CSV Import Previewer Preview creates, updates, unchanged records and errors in a CSV import against your supplied snapshot. Download a row-by-row review without database writes. ### Run and download 1. Keep the included sample or replace **Input data** with your own authorized records. 2. Start a run. Open **Report and CSV downloads** when it finishes. 3. Open **OUTPUT** for the complete JSON report and download the CSV records. 4. Review the findings before importing or publishing changes. This Actor never writes to a store. ### Hosted limits Up to 2000 CSV data rows, 2000 existing records and 1 MiB total input. These tighter hosted limits take precedence over the core format limits below. Memory is fixed at 256 MB. Default timeout is 60 seconds. Output includes one dataset summary row; individual findings and records are delivered in OUTPUT and CSV files. No model subscription, external API key or other product purchase is required. ### Price **$0.05 per run**, charged once when the Actor starts. All report and CSV output is included, with no per-row fee or platform-usage surcharge. Set the maximum run cost to at least $0.05. Starts that reject invalid input or produce no findings still incur the start charge; validate the input before running. ### Storage and support Apify stores supplied data and generated reports under its storage access/retention settings. This hosted edition sends input to Apify; it is not the local-only edition. Remove sensitive run data when no longer needed. URLs in input are never fetched. Use the Actor issue tracker for support with a non-sensitive example and run ID. Do not post private exports or credentials. Hosted use does not grant source redistribution rights. ### Input contract The JSON has csv (comma-separated text), key (the identifying field), fields (explicit mapping and rules), and optional existing (a snapshot array). Use the prefilled example. Every field declares column, type (string, number or date), and required (boolean). Optional min/max apply to numbers; enum is a list of literal allowed strings. No arbitrary regular expressions or executable validators are accepted. Identifiers must be required string fields. Each field maps to one unique, exact CSV header. Existing records use exact string values, with unique, nonempty keys. Numbers are validated as plain decimals and dates as real YYYY-MM-DD calendar dates. All proposed values remain strings, preserving leading zeros and decimal precision; no numeric conversion is exported. Bounds use JavaScript numeric comparison, so use string-only fields for quantities requiring arbitrary-precision range comparisons. All copies of duplicated input keys become errors. Missing fields and invalid values appear per record. Updates compare mapped fields to the existing snapshot; other fields are retained in existing evidence and are not proposed for deletion. Whitespace is preserved, not silently trimmed. Unmapped columns are explicitly reported and excluded from proposed records. CSV row numbers count logical data records, not lines inside quoted fields. Unknown headers do not silently become database fields. Limits: 1 MiB input, 2000 data records, 100 columns/fields, 20000 characters per cell. CSV supports UTF-8 BOM, CRLF/LF, quoted commas, doubled quotes and embedded newlines. Malformed quoting, duplicate/blank headers and inconsistent row widths are refused. Only comma-separated UTF-8 input is supported. Export spreadsheets to CSV first. JSON contains all records, before/after changes, errors and an input SHA-256. CSV is a review report, not a database import file; it protects formula-like prefixes. Nothing contacts or changes a database. This product intentionally has no commit feature: any real import must implement its own permissions and transaction handling. Snapshot freshness and correctness remain the user's responsibility. # Actor input Schema ## `payload` (type: `object`): Up to 2000 CSV data rows, 2000 existing records and 1 MiB total input. ## Actor input object example ```json { "payload": { "csv": "Account,Name,Quantity,Start\n0001,Ada,5,2026-10-30\n0002,Bea,2,2026-02-30\n0003,Cam,4,2026-11-01\n", "key": "account", "fields": { "account": { "column": "Account", "type": "string", "required": true }, "name": { "column": "Name", "type": "string", "required": true }, "quantity": { "column": "Quantity", "type": "number", "required": true, "min": 0 }, "start": { "column": "Start", "type": "date", "required": false } }, "existing": [ { "account": "0001", "name": "Ada", "quantity": "3", "start": "2026-10-30", "note": "Retain this unmapped field" } ] } } ``` # Actor output Schema ## `files` (type: `string`): Open OUTPUT for full JSON and the .csv records for exports. ## `summary` (type: `string`): One summary row per run; detailed findings are in the report and CSV files. # API You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup. ## JavaScript example ```javascript import { ApifyClient } from 'apify-client'; // Initialize the ApifyClient with your Apify API token // Replace the '' with your token const client = new ApifyClient({ token: '', }); // Prepare Actor input const input = { "payload": { "csv": "Account,Name,Quantity,Start\n0001,Ada,5,2026-10-30\n0002,Bea,2,2026-02-30\n0003,Cam,4,2026-11-01\n", "key": "account", "fields": { "account": { "column": "Account", "type": "string", "required": true }, "name": { "column": "Name", "type": "string", "required": true }, "quantity": { "column": "Quantity", "type": "number", "required": true, "min": 0 }, "start": { "column": "Start", "type": "date", "required": false } }, "existing": [ { "account": "0001", "name": "Ada", "quantity": "3", "start": "2026-10-30", "note": "Retain this unmapped field" } ] } }; // Run the Actor and wait for it to finish const run = await client.actor("autosecurelogin/csv-import-previewer").call(input); // Fetch and print Actor results from the run's dataset (if any) console.log('Results from dataset'); console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`); const { items } = await client.dataset(run.defaultDatasetId).listItems(); items.forEach((item) => { console.dir(item); }); // 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs ``` ## Python example ```python from apify_client import ApifyClient # Initialize the ApifyClient with your Apify API token # Replace '' with your token. client = ApifyClient("") # Prepare the Actor input run_input = { "payload": { "csv": """Account,Name,Quantity,Start 0001,Ada,5,2026-10-30 0002,Bea,2,2026-02-30 0003,Cam,4,2026-11-01 """, "key": "account", "fields": { "account": { "column": "Account", "type": "string", "required": True, }, "name": { "column": "Name", "type": "string", "required": True, }, "quantity": { "column": "Quantity", "type": "number", "required": True, "min": 0, }, "start": { "column": "Start", "type": "date", "required": False, }, }, "existing": [{ "account": "0001", "name": "Ada", "quantity": "3", "start": "2026-10-30", "note": "Retain this unmapped field", }], } } # Run the Actor and wait for it to finish run = client.actor("autosecurelogin/csv-import-previewer").call(run_input=run_input) # Fetch and print Actor results from the run's dataset (if there are any) print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}") for item in client.dataset(run.default_dataset_id).iterate_items(): print(item) # 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start ``` ## CLI example ```bash echo '{ "payload": { "csv": "Account,Name,Quantity,Start\\n0001,Ada,5,2026-10-30\\n0002,Bea,2,2026-02-30\\n0003,Cam,4,2026-11-01\\n", "key": "account", "fields": { "account": { "column": "Account", "type": "string", "required": true }, "name": { "column": "Name", "type": "string", "required": true }, "quantity": { "column": "Quantity", "type": "number", "required": true, "min": 0 }, "start": { "column": "Start", "type": "date", "required": false } }, "existing": [ { "account": "0001", "name": "Ada", "quantity": "3", "start": "2026-10-30", "note": "Retain this unmapped field" } ] } }' | apify call autosecurelogin/csv-import-previewer --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "type": "http", "url": "https://mcp.apify.com/?tools=fetch-actor-details,autosecurelogin/csv-import-previewer" } } } ``` The hosted server signs you in with OAuth on first connect, so no API token belongs in this config. Clients without OAuth support can send an `Authorization: Bearer ` header instead, using a token from API & Integrations in Apify Console (https://console.apify.com/settings/integrations). ## OpenAPI specification Download the OpenAPI definition: https://api.apify.com/v2/actors/AEUc9AlB6iBS8Ocjd/builds/pOEreHMLTFjIHnbge/openapi.json