Home
Marketplace
Blog
Discord
Search…
About
What's New?
FAQ
Site Status
Getting Started
Hello World
Variables
Modules
Script Flow
Triggers
Looping / Iteration
Conditionals
Functions
Code Editors
File System
Sharing
Debugging
Feedback and Bug Reporting
Power Users
Test Mode
Library
Triggers
Logic
Modules
Airtable
Alexa
Alpha Vantage
Article Extractor
BigPanda
Bing
Bittrex
Bulk SMS
Calculator
Calendly
Chart
CircleCI
Cities
Clearbit
Cloudflare
CouponTools
Crunchbase
CSS
CSV
Dashboard Response
Datadog
Date Time
Diffbot
Discord
Dropbox
Excel
Figma
Financial Math
Full Contact
FuzzyWuzzy
Giphy
GitHub
GiveButter
Gmail
Google Assistant
Google Calendar
Google Sheets
GraphQL
Guesty
Hacker News
HTML
HTTP Response
Hunter.io
Java
JavaScript
Jira
JSON
Mailchimp
MapQuest
Medium
Monday
Name Parser
News API
NLP
NY Times
Outlook
Phillips Hue
Pushbullet
Python
Reddit
RegEx
Requests
RocketReach
Rollbar
RSS Feed
Salesforce
Scryfall
Send Email
SendGrid
Shell Script
Slack
SMTP Email
Spotify
SQL
Stripe
Text Message
Trello
Twilio
Twitch
Twitter
TXT File
Udemy Instructors
URL Encoder
Verify Emails
Watson
Weather API
Website Searcher
Wikipedia
Word
Yahoo Finance
Yellow Pages
Yelp
YouTube
Zendesk
ZenHub
Zillow
APIs
Python
JavaScript
CLI (alpha release)
Account Management
Updating Your Name, Email, and Username
Changing Your Password
Managing Your Plan
Managing Your API Key
Managing Your Linked Accounts
Phone Number Verification
Two-Factor Authentication
Team Management
Other Information
IP Addresses
Security
Powered By
GitBook
CSV
Seamlessly integrate CSV files with your favorite APIs, databases, and programming languages, using WayScript.
Read and Write to CSV files.
📖
Read File
Import columns from a CSV as WayScript variables.
📂
Select or Upload CSV
CSV files on your account will appear as options. Use the 'Upload File' button to add a new file.
🌟
Create Variables
Once a file is selected to read, a table with the file's contents will appear in the Outputs section.
☑
Ignore Headers
Specify whether or not to ignore the first line of the file when assigning variables.
➕
Assigning Variables
Naming a column in the table creates a
List
variable with that name containing all entries in that column.
Note that first row is ignored in creating variables
✍
Write File
⚙
Select File
Use the file dropdown to select an
existing file on your account
or create a new one.
☑
Include Headers
If checked, the variable name will be written as the first row of each column.
✏
Write Mode
1.
Add to File: Every time the program runs, new rows of data will be added to the bottom of the CSV file.
2.
Replace File: Every time the program runs, the file will be cleared before writing new data.
Headers will only be written when the file is blank.
If 'Include Headers' is selected, changing a variable name when adding to an existing and non-empty file will not replace the header row.
➕
Adding Variables
Each time the CSV Module executes in Write Mode, one row of data is added.
To write each entry of list to a new row, use a
Loop
.
🔎
Preview
As variables are added and removed, the Outputs section displays a preview of what will be written.
Previous
CSS
Next
Dashboard Response
Last modified
1yr ago
Export as PDF
Copy link
Contents
Read File
Select or Upload CSV
Create Variables
Ignore Headers
Assigning Variables
Write File
Select File
Include Headers
Write Mode
Adding Variables
Preview