What replaces From Text in Google Sheets?
Excel From Text / Get Data from Text walks CSV and fixed-width imports. Google Sheets uses File > Import, drag-and-drop upload, or IMPORTDATA for published CSV URLs. Set separator and locale during import to match Excel's wizard.
When to use it
Use File > Import when moving delimiter files from Excel text import.
When to skip it
Skip repeated manual imports when a Drive drop folder plus one IMPORTDATA URL is stable.
Better Sheets resources
Related Tutorials
Watch how From Text works
Create Hundreds of Tweets in a Google Sheet
How to Replace Text with a Blank Cell in Google Sheets
Embed a Headline in a Website from Google Sheets
Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.
Add Title Case to Google Sheets
Embed a Number in a Website from a Google Sheet
Related blog posts
Guides that explain From Text in more depth.
Extract URLs from Google Sheets
Extract url from hyperlink google sheets.Skip the Command K. This Google Sheet tutorial will make it easier for you to extract URLS from Google Sheets.
Read post →Explore Coding in Google Sheets
Did you know you can actually code in Google Sheets?
Read post →Spreadsheets Explained! 5 Levels of Difficulty: From Basic Text Input to Google Apps Script
Five increasingly difficult ways of explaining spreadsheets in Google Sheets: The basics of Google Sheets text Menu items in Google Sheets Math inside Google Sheets Using Formulas in Google Sheets Apps Script in Google Sheets
Read post →Related terms
CSV and Google Sheets
CSV (comma-separated values) is a plain-text table format Sheets opens, imports, and exports easily. Use File > Import for controlled uploads or File > Download > CSV for handoffs to other tools. Watch encoding, delimiters, and date formats because CSV does not store types the way a native sheet does.
Read guide →importing data into Sheets
Importing means pulling external data into a spreadsheet tab: from a file upload, another Google Sheet, a published CSV URL, or a function like IMPORTRANGE. The import dialog controls separator, locale, and whether new rows replace or append existing data.
Read guide →IMPORTDATA
IMPORTDATA retrieves a text file from a web address and parses it into sheet cells. It works with comma- or tab-separated values published at a stable URL. Government open data, published exports, and simple report endpoints are common sources.
Read guide →Locale separators
Locale controls whether function arguments separate with commas or semicolons and whether decimals use dot or comma. A sheet set to France may expect =SUM(A1;A10) while US expects =SUM(A1,A10). CSV imports and array literals also clash when decimal commas meet comma separators. File > Settings > Locale sets the default behavior for new formulas in that file.
Read guide →Done reading about From Text?
Membership unlocks 637+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.