How to Turn Notes Into Google Sheets Rows

To turn notes into Google Sheets rows, paste them into one column, then split each line into cells. If your lines all follow the same pattern, Data → Split text to columns does it in two clicks. If they're messy, use SPLIT and REGEXEXTRACT formulas, Google's =AI() function, or an app that reads your columns and adds one row per item. Below are before/after examples for each.

The problem: notes aren't rows

Notes are written for speed. A spreadsheet wants structure. Here's a typical running list from a phone's notes app, written over a week:

lunch w sam 14.50
uber 23 tue
groceries 61.18 aldi
coffee 4
parking $8 on friday

And here's what it needs to look like in a sheet with Date, Item, Category and Amount columns:

The gap between the two is the whole job. The amount moves around, the date is sometimes a weekday and sometimes missing, and the category isn't written down at all. Each method below closes part of that gap.

How do you turn notes into Google Sheets rows?

There are four ways. They differ mainly in how messy the notes can be.

The short version: use Split text to columns when the notes are tidy, formulas when there's a pattern, and AI when there isn't one.

Method 1: Split text to columns (tidy notes)

This is the built-in, no-formula option. It works when every line has the same fields in the same order with the same separator.

Before (column A):

2026-11-09, Lunch, Food, 14.50
2026-11-10, Uber, Transport, 23
2026-11-11, Groceries, Groceries, 61.18

Steps:

1. Paste the notes into column A. Sheets puts each line in its own cell.
2. Select column A.
3. Go to Data → Split text to columns.
4. In the separator box that appears, choose Comma (or Detect automatically, Semicolon, Period, Space or Custom).
5. Check that dates and amounts are right-aligned, which means Sheets read them as dates and numbers, not text.

After: four columns, one row per line, ready for totals.

Where it breaks: the lines in the example at the top of this post. "uber 23 tue" split on spaces gives three cells, "lunch w sam 14.50" gives four, and the amount ends up in a different column on every row. Split text to columns has no idea which part is the amount.

If you keep notes you plan to paste later, the cheapest fix is to write them in a fixed order with commas. That makes Method 1 work every time.

Method 2: SPLIT and REGEX formulas (notes with a pattern)

Formulas help when the notes aren't in a fixed order but follow a pattern you can describe, such as "there's always one number, and it's the amount".

Split one pasted cell into rows

If you pasted the whole note into a single cell (A1), break it into one line per row first:

=TRANSPOSE(SPLIT(A1, CHAR(10)))

CHAR(10) is the line break, so SPLIT cuts at each new line and TRANSPOSE stacks the pieces down a column.

Split a tidy line into cells

For a line like "Uber, Transport, 23" in A2:

=ARRAYFORMULA(TRIM(SPLIT(A2, ",")))

TRIM removes the spaces left after each comma. This is the formula version of Method 1, and it updates when the note changes.

Pull the amount out of a messy line

For "uber 23 tue" or "parking $8 on friday" in A2, grab the first number:

=VALUE(REGEXEXTRACT(A2, "\d+(?:\.\d+)?"))

REGEXEXTRACT returns text, so VALUE turns it into a number your totals can add up. Then take everything except the number as the item:

=TRIM(REGEXREPLACE(A2, "\$?\d+(?:\.\d+)?", ""))

Before → after:

Where it breaks: the formulas find the number, but "tue" and "on friday" stay in the item, nobody fills the Date column, and categories still need to be typed. A note with two numbers ("2 coffees 9") gets the wrong amount. Formulas get you about halfway; the rest is tidying by hand.

If you do categorise by hand, a dropdown keeps the labels consistent. See how to make category dropdowns in Google Sheets.

Method 3: The =AI() function (messy notes, eligible plans)

Google Sheets has an AI function that runs a prompt on a cell. You can type =AI() or =Gemini(). As of November 2026, Google's AI function help page says it needs an eligible Google Workspace or Google AI plan. The free personal Google account doesn't include it.

Use one formula per column, each with a narrow prompt:

=AI("Return only the amount as a number, no currency symbol", A2)
=AI("Return a short item name in title case", A2)
=AI("Pick one category: Food, Transport, Groceries, Bills, Other", A2)

Before → after:

That's a big step up from regex on messy text. A few things to know:

• It returns text. Wrap amounts in VALUE() before you sum them, and check that dates come out as real dates.
• Relative dates are hard. "tue" or "on friday" only means something if the model knows when the note was written, and a cell doesn't carry that. Add the date yourself or put it in the prompt.
• It has usage limits and works cell by cell, so a long note means many calls.
• Check the answers. AI output can be wrong in ways that look right, and a wrong amount quietly breaks your totals.
• Your note goes to Google for processing, under your Google plan's terms.

Once the values are right, copy the columns and use Paste special → Values only so the results don't recalculate later.

Method 4: Quick Capture in Voice Sheet (notes from your phone)

The first three methods all happen inside a sheet, usually on a computer. Most notes are written on a phone, though, and the Sheets mobile app is awkward for splitting and formulas. That's the gap Voice Sheet's notes to Google Sheets feature, Quick Capture, is built for.

How it works:

1. Connect a Google Sheet in the Voice Sheet app on iPhone or Android. It can be an expense sheet or any other sheet you add rows to.
2. Open Quick Capture from the app, or tap the home screen widget, which opens the text box directly.
3. Paste or type your notes, up to 1,000 characters. New lines, commas, bullets, full stops and "and then" all count as separators, and you can mix them.
4. Tap Submit.

Before: the same messy list from the top of this post.

After: five rows in your sheet. Each part is matched to your column names:

• Dates: "tue" and "on friday" are worked out from your phone's date. Items with no date get today.
• Amounts: "$8", "8 dollars" and "8" all become the number 8.00.
• Categories: dropdown columns only get options you've already defined, never a made-up one.
• Text: items are cleaned up and capitalised.

Entries are added as soon as you submit. If one comes out wrong, edit it in Recent Entries in the app or fix it in the sheet. With no signal, your text is kept as a draft for that sheet until you're back online.

To dictate the list instead of typing it, tap the microphone on your phone's keyboard inside the Quick Capture box. For a single entry spoken into the app with a review step before it's saved, use voice entry; the in-app microphone listens in your app language.

What happens to the text: Voice Sheet sends it, together with your column names and dropdown options, to Google Gemini to fill the columns. The rows are written to your own Google Sheet. Voice Sheet doesn't keep a server database of your entries.

The free plan includes one Quick Capture (or home screen widget entry) a day, plus a form built from your sheet's columns, which suits one entry at a time. Premium ($4.99 a month or $39.99 a year) makes Quick Capture unlimited. More on how the app maps columns to fields is on the Google Sheets data entry page.

Which method should you use?

• You control the note format: write "date, item, amount" with commas and use Split text to columns. Free and instant.
• The notes follow one rule, like "one number per line": SPLIT and REGEXEXTRACT formulas.
• The notes are messy and you're at a computer with an eligible Google plan: the =AI() function, with a check before you trust the totals.
• The notes live on your phone, or you add them every day: Quick Capture, so the rows go into the sheet without opening it.

If your notes are mostly spending, the sheet they land in matters as much as the method. How to track expenses in Google Sheets covers the columns and formulas, and the voice expense tracking guide covers capturing spending as it happens, so there's less to catch up on later.