You can export data from Etsy in CSV and JSON formats. Learn how you can do this natively, and discover what other exporting options are available.
Master your data operation skills every day
Read a tutorial about what customer lifetime value is, why it matters and how to calculate CLV for your particular project.
Learn how you can import large data sets into Google Sheets via APIs using paginated requests, using the example of the Shopify API.
Learn all possible options to total values with and without conditions in Google Sheets in one blog post about SUM, SUMIF, and SUMIFS.
Read this blog post to become a professional in sharing Google sheets and spreadsheets. Learn how to share one tab only, including answering the question of how to share a spreadsheet with non-Gmail users.
Learn the fundamentals of using pivot tables in Google Sheets to manipulate and organize your data efficiently.
Learn the basics of ETL (extract-transform-load) process and check out how it works in the example of a real-life ETL tool.
Learn how you can build a custom currency exchange rate monitor in your spreadsheet, or import financial data using API without a single line of code.
Check out both formula and formula-free solutions to combine data ranges with a different number of columns from multiple sheets into one.
Check out the formula and no-formula solution to combine tabs from an internal or external Google Sheets file into one master view