App Icon
The all-in-one data-processing tool for Google Sheets
Listing updated:October 21, 2021
Works with:
104,707
Overview
Use Logic Sheet to manipulate data in your spreadsheets for free! 

Google Sheets is one of the most acclaimed data-processing tools, but many users find it limited to do the kind of advanced data processing and analytics they desire. Data analysts typically go back and forth between using spreadsheets and writing code. This is very time-consuming, tedious, and error-prone.

Introducing Logic Sheet: a data-processing add-on for Google Sheets that lets you do all kinds of data processing tasks with one click right in your Google Sheet. No more copy/pasting and coding.

In short, Logic Sheet is like a Swiss Army Knife for data processing. It does everything from importing and parsing data to analyzing statistics and sorting any kind of data.

With our intuitive user interface, you no longer have to worry about writing complicated formulas or dealing with redundant code to make sense of your data.

A typical data-analysis task involves three steps: data collection, data cleaning, and data analyzing. With Logic Sheet, you can do them all in only one tool.

=====Data collection=====

In the data collection process, you can use Logic Sheet to import data from external sources into Google Sheets. That includes importing data from API, databases, or webpages. Our API Connector can help you make GET and POST requests to API, and the Database Connector can help you pull data right from an online database.

With Logic Sheet's API Connector function, it's now easy to make POST/GET requests to any JSON data source and import REST API data directly to your spreadsheet. This means you can import JSON from any URL. 

Features:

- Data organizer: Import nested JSON data into Google Sheets
- Use OAuth authentication and simple API key authentication
- Data connector for Salesforce, Airtable, IBM, Alpha Vantage, Crunchbase, DeepL, Facebook ads, Goole Analytics, HubSpot, Instagram, Spotify, Apple Music, Mailchimp, Salesforce, Xlminer, Flex.io, Slack, Youtube, and Stripe using our API connector
- Data connector for Salesforce
- Send data to API from your worksheets.

Database browser: You can use Logic Sheet to connect to a MySQL database and import data from the database using our database connector function. 

Data scraping: Scrape structured data from any website page using our webpage crawl (ImportFromWeb) function.

=====Data cleaning=====

In the data cleaning stage, you can use Logic Sheet to remove incorrect or superfluous data, as well as check for incompleteness or inconsistencies. For instance, you can use Logic Sheet to remove spaces in front of letters or symbols or remove duplicates. Logic Sheet also lets you filter rows depending on conditional rules like “contains,” “is larger than,” or “is empty.”

- Remove duplicates: Remove all extra rows that have duplicate values in each cell to clean dataset.
- Case Converter: Change text casing of all values of the selected range into upper case, lower case, pascal case, title case, proper case, camel case, snake case, sentence case, train case, or kebab case.
- Unpivot data: Transform a pivot table into a regular tabular sheet.
- Split names: Use the Split names function to split a full name into smaller parts (first name, middle name, last name, salutation, suffix, etc.). The Split names function recognizes over 100 titles (Mr. Dr. Prof. etc.) and 50 post-nominals (CFA, Ph.D., etc.)
- Split address: Parse a column of addresses into smaller parts (street address, city, state, postal code, etc.)

Other clean data features:

- Round number
- Remove leading spaces
- Trim trailing spaces
- Remove non-numbers
- Remove number
- Remove punctuations
- Format data and clean data
- Convert Unix timestamps

=====Data analytics=====

Finally, you can use Logic Sheet to run statistical analysis on your data and extract meaningful insights from it. That includes ANOVA, F-test, T-test, and more. With our analysis tools, you will be able to find hidden patterns, relationships, insights, and predictions from your data.

>> Data Analysis Toolpak 🛠

- ANOVA, or Analysis of variance: Use Logic Sheet to do ANOVA analysis, calculate the sum of squares, variance, mean squares, P-value, and F crit value. Both ANOVA (ANOVA Single Factor) and two-way ANOVA (two-factor ANOVA) are supported.

- Correlation: Find the correlation coefficient between two or more variables.

- Covariance: Calculate the joint variability of two random variables.

- Descriptive Statistics: Describe the basic features of the data including Mean, Standard Error, Median, Mode, Standard Deviation, Sample Variance, Kurtosis, Skewness, Range, Confidence Level (Confidence Interval), and more.

- F-Test for two sample variances: A test that uses the F-distribution. This function uses the F Test to compare two variances.

- z-test: a hypothesis test that determines whether two population means are different when the variances are given.


=====Other features=====
 

>> Calculate 🧮

Use Logic Sheet to insert a cumulative sum column or insert a growth rate column next to the selected column.

- Insert running totals: Insert a column of cumulative totals of the selected column next to it
- Insert growth rate: This function will insert a column of growth rate values of the selected column next to it

______________________________________________________________________________

>> Finance 💵

Logic Sheet can help you import stock prices, financial statements, and foreign exchange rates into your spreadsheets and simplify your financial analysis workflow.  It's easy and flexible to use.

> Get real-time share price or weekly and monthly stock price history of a company

> Import company financial information, including income statement, earnings, balance sheet, cash flow, and company overview into your spreadsheet

> Import real-time forex rates (foreign exchange rates) and historical forex rates

> Import real-time cryptocurrency prices or historical data

Supported cryptocurrencies: Bitcoin (BTC), Ethereum (ETH), Ripple (XRP), Tether (USDT), Stellar (XLM), Litecoin (LTC), Polkadot (DOT), Cardano (ADA), Bitcoin Cash (BCH), Binance Coin (BNB), Uniswap (UNI), USD Coin (USDC), Celsius Token (CEL), Wrapped Bitcoin (WBTC), EOS (EOS), Bitcoin SV (BSV), Tron (TRX), VeChain (VET), Synthetix Network Token (SNX), Monero (XMR), DogeCoin (DOGE), and more. See the full list here: https://app.logicsheet.co/financesupport#supported-cryptocurrencies 

______________________________________________________________________________

For more information about Logic Sheet, please visit: https://app.logicsheet.co/

If you have any questions, please contact the developer at wei@logicsheet.co, I will reply to you in less than 24 hours.

If you have any trouble using Logic Sheet, please take a look at our detailed documentation here: https://app.logicsheet.co/docs
Additional information
PricingNot available
Privacy policy
Terms of service
Logic Sheet - Data Processing & Data Analysis will ask for the permissions shown below. Learn more
Logic Sheet - Data Processing & Data Analysis will need access to your Google account
This will allow Logic Sheet - Data Processing & Data Analysis to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
Hugo Huruki
April 16, 2021
Amazing tool, great support!
Is this review helpful?
Yes
No
Profile Picture
Tyler Devito
March 3, 2021
Lifesaver, saved me tons of hours from copy-pasting numbers. Plus, this is a truly free API importer! Cheers!
Is this review helpful?
Yes
No
Profile Picture
Bruno Calhiari
September 8, 2021
If you're afraid of missing Excel functionalities when starting using Sheets, fear no more! This app is a must if you work with data!
Is this review helpful?
Yes
No
Profile Picture
Ian Wong
February 21, 2021
Great tool for data processing tasks! I love the import cryptocurrency exchange rates feature. Would be great if you can add more crypto-related features.
Is this review helpful?
Yes
No
Profile Picture
Jitin Sipahimalani
July 19, 2021
Logic Sheet is a must-have for all Google Sheets users. I believe Logic Sheet has got the right set of features for both newbies and more advanced level of users who manage their data in google sheets. This is a great tool for anyone who needs to clean up their data before it's ready to be used or analyzed. I've also found that it is easy to use. I really like the interface and the functionality of this tool. I also love the fact that the tool is always updated and is constantly being improved.
Is this review helpful?
Yes
No
Profile Picture
Ivan Hoi Wang LAW
June 2, 2021
Great use of good tools, thank you!
Is this review helpful?
Yes
No
Profile Picture
Mail Sentencess
March 20, 2021
My colleague recommended this add-on to me. It has so far made my job a lot more easier. I would say Google Sheets is only comparable with Excel when you have Logic Sheet installed.
Is this review helpful?
Yes
No
Profile Picture
Aizat Hawari
July 23, 2021
Amazing developer, friendly and helpful. Taught me how to use his add-on and even taught me trick or two on Google Sheet. Great add-on! This add-on helps you to clean your data, run statistical test, pull data from other data providers via API. Cleaning the data, by isolating content based on Keywords was also possible - Who would have taught to implement that? Wei from Logic Sheet did! :D It's a really great add-on worth the investment and no surprise it's one of the best for Google Sheets.
Is this review helpful?
Yes
No
Profile Picture
Dr.Vijay B. Musai
May 26, 2021
Very nice
Is this review helpful?
Yes
No
Profile Picture
Conor Healey
April 21, 2021
This add on is so crucial for what you're trying to accomplish from a Finance standpoint. Im using it to ingest Crypto information into my personal Google sheet and so far its been a splendid experience!
Is this review helpful?
Yes
No
1-10 of 11
Search
Clear search
Close search
Google apps
Main menu