ZeroWork
  • 👋Home and Welcome
  • 🚀Getting Started
  • ⬇️Install the Agent
  • 🧑‍💻Crash Course
  • Using ZeroWork
    • 🖥️General: Run, Schedule, Share, Webhooks
      • Run
      • Stop
      • Log in to the Agent
      • Run Modes
        • Run Incognito
        • Run Non-Incognito
        • Run in My Regular Browser
      • Run Settings
        • Run in Background
        • Stay on Page after Run
        • Bring Pages to Front
      • TaskBot Sharing Options
      • Cookies
      • Scheduler
      • Trigger Run via Webhook
      • Proxies
      • Remote (Cloud) Execution
      • How to Check and Update Your Agent
      • Install ZeroWork Agent on VPS
    • 📔Using Selectors
      • What Are Selectors
      • Use Element's Text
      • Copy Selectors
      • How to Build Custom Selectors
        • Basic Concepts of Selectors
        • One Element Can Have Many Selector Expressions
        • Check if Selector Is Correct and Unique
        • Exact or Loose Match
        • Hierarchy
        • Combine Filters with Standard CSS Logic
        • Lists: Incremental CSS Selectors
        • Addressing Siblings
      • How to Use XPath in ZeroWork (advanced)
    • 🏗️Using Building Blocks
      • Open Link
      • Save Page Url
      • Switch or Close Tab
      • Go Back or Forward
      • Switch Frame
      • Browser Alert
      • Click Web Element
      • Check Web Element
      • Save Web Element
        • Save Lists
        • Enrich Existing Data
        • Stop Run If Selector Is Not Found Option
      • Insert Text or Data
      • Hover Web Element
      • Select Web Dropdown
      • Keyboard Action
      • Start Condition and Set Condition
        • Actions = & ≠
        • Actions <, ≤, >, ≥
        • Data Found & Data not Found
        • Contains & Does Not Contain
        • Before (Date) & After (Date)
      • Start Repeat
        • Standard Loop
        • Dynamic Loop
        • Continue until No Element Is Found
        • Auto-Scroll
        • Auto-Continue from Last Row or Element
        • Nested Loops - Handle Pagination
      • After Repeat
      • Break Repeat
      • Try-Catch
      • Raise Error
      • Abort Run
      • Update Data
      • Number Operations
        • Example: Standardize different formats
      • Format Data
        • Remove Words
        • Shorten Content Length
      • Split Data
      • Apply Regex
      • Remove Duplicates
      • Delete Data
      • Ask ChatGPT
      • Send Notification
      • APIs: Send HTTP Request
      • Write JavaScript
      • Save File
      • Upload File
      • Delay
      • Record Date
      • Take Screenshot
      • Save from Clipboard
      • Log
      • Building Block Options
        • Delay Times between the Building Blocks
        • Randomize Delay Time
        • Deactivate Building Blocks
        • Shortcuts
        • Spintax
        • Auto-Align
        • Sticky Notes
    • 🔀Using Variables
    • 💿Using Tables
      • How to Add Tables
      • Native Tables
      • Google Sheets
      • Import Data from CSV
      • Using Google Sheet vs. Native Tables
      • Create Columns
      • Export Data as CSV
      • Convert Native Table to a Google Sheet
    • 📄Using Run Reports
    • 😑Common Problems
      • My TaskBot Does Not Start Run
      • When I Use Data from Table, No Data is Being Pulled
      • Website is Glitching and Flashing
      • No Selector is Found
      • My TaskBot Saves Some Data but Not All
      • Data Is Saved in Wrong Format
      • Website Requires SMS or Email Verification
      • Keyboard Action Is Not Working As Expected
      • Check Web Element Identifies Selector as Found but Next Action Does Not
      • When Using Insert Data Block, First Letters Are Cut Off
      • Workflow Has More than One Starting Building Block
      • TaskBot Does Not Automatically Scroll
  • Support
    • 🆘Getting Support
  • 🆕Release Notes
    • Version 1.1.61
    • Version 1.1.62
    • Version 1.1.63
    • Version 1.1.64
    • Version 1.1.65
    • Version 1.1.66
    • Version 1.1.67
    • Version 1.1.68
Powered by GitBook
On this page
  • Create a New Table from a CSV File
  • Update Existing Native Table with CSV
  • How to Import Data from a CSV File to a Google Sheet?

Was this helpful?

  1. Using ZeroWork
  2. Using Tables

Import Data from CSV

PreviousGoogle SheetsNextUsing Google Sheet vs. Native Tables

Last updated 7 months ago

Was this helpful?

You can either create a new table from scratch that is created based on CSV data or, import CSV data to an existing native table.

Create a New Table from a CSV File

A native table (see Native Tables) will be created based on the columns inside the CSV file. Upon creation, the data from that CSV file will be imported.

Update Existing Native Table with CSV

You can manually update your table by importing data from a CSV file. This option is accessible in More Actions on your TaskBot page.

Column matching

Whenever you import data from a CSV file to an existing table, make sure that the column names in CSV match the column names in your table.

If some columns are not matching, the table will still be updated but non-matching columns will be left out (ignored).

Sequence of columns in CSV versus your table does not matter.

Name of the file name versus table name does not matter either.

Column matching is not case-sensitive.

The data is always appended, unless you check this checkbox. 👇

Checkbox "overwrite current data"

By checking this checkbox, the current data in your table will be overwritten by the data from CSV. The existing data in your table will be permanently deleted. If you want to secure your data before overwriting it, you can simply Export Data as CSV first. If left unchecked, per default, the data would be appended. This means that the data in your table would be "merged" with the new data from your CSV.

How to Import Data from a CSV File to a Google Sheet?

It is also accessible on the tables list page as well as inside the table itself in More Actions.

Google Sheet allows you to import data from a CSV file, too. Simply click on File -> Import inside your Google Sheet. If you are not sure how to do this, check this guide where you'll find some screenshots: .

💿
https://creator.zerowork.io/datagroups
External Link - How to Import CSV to a Google Sheet