No-Code Data Pipeline: Join, Filter, and VLOOKUP CSV Files in Browser

TLDR

Merging CSV files or running VLOOKUP formulas across multiple spreadsheets in Excel often leads to frozen workbooks, broken cell references, and manual copy-paste errors. GINEXYS Table Formatter (TAFNE) Node Editor provides a visual data graph engine where you connect sheet nodes to Filter, VLOOKUP, Join, and API nodes, executing data transformations automatically inside a background Web Worker.

The Search Query: No-Code Browser CSV Data Pipeline

Data analysts search for:

• "no code browser data pipeline tool join filter vlookup csv online"
• "visual spreadsheet join tool inner join left join without sql python"
• "excel vlookup alternative browser node editor data graph"

Node Graph Architecture and Sheet Manager Sync

Every sheet in TAFNE Sheet Manager is instantly available as a node in Node Editor. Connecting node ports creates a visual data execution graph:

[Sheet: Sales_Log] ---\
                      +---> [JOIN Node (Inner, Key='Rep ID')] ---> [Filter Node] ---> [Build Table]
[Sheet: HR_Roster]  ---/

Rule of thumb: use a visual node graph to construct multi-table joins and data filtering pipelines rather than nested VLOOKUP formulas.

Topological Node Graph Execution Engine

Clicking Run Pipeline triggers the topological execution engine (nodeExecutor.js). Nodes execute in dependency order, passing tabular arrays through Web Worker threads:

// Topological graph execution signature in nodeExecutor.js
import { executeNodeGraph } from '../features/nodeExecutor.js';
const pipelineNodes = [     { id: 'n1', type: 'SHEET_SOURCE', sheetId: 'sheet-sales' },     { id: 'n2', type: 'SHEET_SOURCE', sheetId: 'sheet-hr' },     { id: 'n3', type: 'JOIN', config: { mode: 'INNER', key: 'Rep ID' }, inputs: ['n1', 'n2'] },     { id: 'n4', type: 'FILTER', config: { col: 'Region', operator: 'EQUALS', value: 'West' }, inputs: ['n3'] } ];
const finalSheet = await executeNodeGraph(pipelineNodes); console.log(Pipeline complete. Output rows: ${finalSheet.rows.length});

Pulling Live Endpoints with the API Node

You can add an API Node to fetch JSON endpoints directly into your data pipeline:

1. Drag API Node onto the canvas.
2. Enter REST API URL (e.g. https://api.example.com/v1/rates).
3. Set JSON response path mapping (data.rates).
4. Wire output into a Join or Formula node.

Conclusion

Node Editor transforms complex multi-sheet joins and VLOOKUP workflows into clear, reusable data pipelines.