Parses CSV text into a 2D array of values.
class Utilities method .parseCsv()
Utilities is the Apps Script service.
.parseCsv() is the method name you will see after a dot in your code.
What it does
Why it's used
- Turn pasted or fetched CSV into a 2D array for setValues.
- Import upload content without manual splitting.
Common errors
- Forgetting parentheses on parseCsv. Write Utilities.parseCsv(), not Utilities.parseCsv or parseCsv by itself.
- Skipping dots between chained calls. Each step needs a dot, like Utilities.parseCsv().
- Adding spaces where they do not belong. Write Utilities.parseCsv(), not Utilities .parseCsv(), Utilities.parseCsv (), or Utilities . parseCsv().
- Wrong capitalization. Use Utilities and parseCsv, not utilities or parsecsv.
Explore
Related methods
-
.jsonParse()
Parses a JSON string into a JavaScript object.
-
.jsonStringify()
Converts a JavaScript object into a JSON string.
-
.base64Decode()
Decodes a Base64 string back into raw data.
-
.newBlob()
Creates a blob object from text or binary data.
-
.formatDate()
Formats a date using a pattern and time zone.
More Apps Script
Better Sheets tutorials
No tagged tutorials yet. Fetch Apps Script from the harvest table and this page fills automatically.
Related blog posts
Written guides about Utilities.parseCsv().
What's Better Than Google Sheets?
Nothing is better than Google Sheets. You just need to learn more about the unlimited power of Google Sheets. Functions, Formulas, Apps Script and more.
Read post →How to Send Google Forms Entries Automatically with Apps Script
Google Forms provides basic email notifications for form submissions, but enhancing these notifications with detailed summaries can significantly improve productivity and response management.
Read post →Explore Coding in Google Sheets
Did you know you can actually code in Google Sheets?
Read post →