- [Case Studies](https://www.mergado.com/category/case-studies)
- [eCommerce tips](https://www.mergado.com/category/ecommerce-tips)
- [Online Store Solutions and Platforms](https://www.mergado.com/category/online-store-solutions-and-platforms)
- [Mergado Pack](https://www.mergado.com/category/mergado-pack)
- [Mergado tips](https://www.mergado.com/category/mergado-tips)
- [Mergado News](https://www.mergado.com/category/mergado-news)
- [eCommerce News](https://www.mergado.com/category/ecommerce-news)
- [How to use Mergado](https://www.mergado.com/category/how-to-use-mergado)
- [Interviews with e‑commerce gurus](https://www.mergado.com/category/interviews-e-commerce-gurus)
- [Extensions](https://www.mergado.com/category/apps-bidding-image-marketing-and-more)
- [Expansion with Mergado](https://www.mergado.com/category/expansion-with-mergado)
- [Mergado Lifestyle](https://www.mergado.com/category/mergado-lifestyle)
1. [ Home ](https://www.mergado.com/)
2. [ Mergado Blog ](https://www.mergado.com/blog)
3. [ Case Studies ](https://www.mergado.com/category/case-studies)
4. **Get data from Google Sheets to Mergado**
# **Get data from Google Sheets to Mergado**
[  Lukáš Horák ](https://www.mergado.com/blog/lukas-horak) [Case Studies](https://www.mergado.com/category/case-studies) , [How to use Mergado](https://www.mergado.com/category/how-to-use-mergado)
26. 11. 2019
2 minutes read
Some time ago, we showed you how to get [data from Mergado to Google Sheets](https://www.mergado.com/data-into-google-sheets). Today we will show you **the opposite way**. It saves you a lot of time by using a **CSV** **file** to quickly import data to Mergado as you need it. Let’s take a look at **two** **options**.
function tableOfContents() {
return {
headings_menu: [],
heading_active: '', // Added to track the active section
shouldBeSticky: false,
generateToC() {
const headings = document.querySelectorAll('.js-article-full-headings h2, .js-article-full-headings h3');
let headingMap = {};
headings.forEach((heading) => { // Use an arrow function to maintain `this` context
// Normalize heading text to remove diacritics, then replace non-alphanumeric characters with dashes
var normalizedText = heading.textContent.normalize("NFD").replace(/[\u0300-\u036f]/g, ""); // Remove diacritics
var id = heading.id ? heading.id : normalizedText.trim().toLowerCase()
.split(' ').join('-').replace(/[^a-z0-9\-]/ig, ''); // Updated regex to replace non-alphanumeric characters
headingMap[id] = headingMap[id] !== undefined ? ++headingMap[id] : 0;
// Use the updated `id` with diacritics removed for the heading id and the TOC
const finalId = headingMap[id] ? `${id}-${headingMap[id]}` : id;
this.headings_menu.push({
id: finalId,
title: heading.textContent,
level: heading.tagName.toLowerCase(), // Track heading level
active: false, // Initially set active to false
});
heading.id = finalId;
});
},
checkStickyNeeded() {
const ul = this.$el.querySelector('ul');
if (ul) {
this.shouldBeSticky = ul.scrollHeight < window.innerHeight;
}
},
setActiveHeading() {
// disabled not working with active state on click
// add @scroll.window="setActiveHeading()" to the parent div
// const headings = document.querySelectorAll('.js-article-full-headings h2');
// let activeHeading = '';
// let closestHeadingDistance = Infinity;
// headings.forEach((heading) => {
// const rect = heading.getBoundingClientRect();
// const offset = rect.top - window.innerHeight / 2; // Consider heading in the middle of the screen as active
// if (offset < 0 && Math.abs(offset) < closestHeadingDistance) {
// activeHeading = heading.id;
// closestHeadingDistance = Math.abs(offset);
// }
// });
// // Update the active state in headings_menu
// if (activeHeading !== this.heading_active) {
// this.headings_menu = this.headings_menu.map(item => ({
// ...item,
// active: item.id === activeHeading,
// }));
// this.heading_active = activeHeading;
// }
},
setActiveItem(clickedId) {
this.headings_menu.forEach(item => {
item.active = (item.id === clickedId);
});
this.heading_active = clickedId; // Optionally update the heading_active property if used
},
};
}
1. —
Some time ago, we showed you how to get [data from Mergado to Google Sheets](https://www.mergado.com/data-into-google-sheets). Today we will show you **the opposite way**. It saves you a lot of time by using a **CSV** **file** to quickly import data to Mergado as you need it. Let’s take a look at **two** **options**.
## 1. Create a new export
You can easily get data from [Google Sheets](https://www.google.com/intl/cs_cz/sheets/about/) to Mergado in the traditional way — **with a new export**.
**Instructions:**
- **Create** a spreadsheet in Google Sheets.
- In the settings, **click** the *File > Share* section and select *Publish to the web*.
- In the *Link* section, **select** *Sheet* (not Entire Document) and **select** *CSV format* **with comma-separated values**.
- Click *Publish* and **copy** the link.
- **Use** the copied link **as the source file** for the new export.
[  ](https://www.mergado.com/sites/default/files/perm/paragraph-image/sheets-eng.png)
Do you want to import elements **according to your needs** from the Google Sheets Export to [Mergado](https://www.mergado.com/get-started)? Do it using our **Custom** **format**. By using it correctly, you can be sure that the rules and all other important processes will **work** **well**.
## 2. Use the Data File Import rule
You can import edits to existing Mergado items using the recently added [Data File Import](https://www.mergado.com/csv-import-to-ease-your-work-with-mergado) rule. **You do not have to create a new export**, but just add a new rule to the existing one, which easily gets the selected data into Mergado.
We’ve described how to create a CSV link from Google Sheets above. When creating a new rule, you only need to **choose** whether you want to apply it to **all products or only to specific queries**.
And that’s all. The use of Google Sheets and their connection with Mergado offers interesting reporting options. **Learn how to use it**.
### **You could be also interested in:**
[ 
### Simplify your advertising settings with Mergado apps
](https://www.mergado.com/mergado-apps-overview)
[ 
### MASTER PROMPT TEMPLATE FOR ECOMMERCE
](https://www.mergado.com/blog/master-prompt-eshopy-b2c)
[ 
### How Feed Optimization Unlocked Meta Ads Performance without Increasing Ad Spend
](https://www.mergado.com/blog/feed-optimization-for-meta-ads)
[  ](https://www.mergado.com/blog/lukas-horak)### [ Lukáš Horák ](https://www.mergado.com/blog/lukas-horak)
Lukáš takes care of most of the Czech and English communication in Mergado. Through blogs, e‑mail, and social networks, he regularly supplies readers with e‑commerce news and news and tips from Mergado. In his time off, he enjoys simple things like badminton, digging the hidden gems of the 80’s, and seafood served with red wine.
## What you *might be interested in next*
[ 
### How Feed Optimization Unlocked Meta Ads Performance without Increasing Ad Spend
](https://www.mergado.com/blog/feed-optimization-for-meta-ads)
[ 
### The Real Impact of Visual Product Image Optimization on Meta Campaign Performance
](https://www.mergado.com/blog/visuals-for-meta-campaigns)
[ 
### How We Migrated an E‑Shop from Shoptet to Shopify with Mergado: A Complete Migration Without Data Loss
](https://www.mergado.com/blog/how-we-migrated-e-shop-shoptet-shopify-mergado-complete-migration-without-data-loss)
## Don’t miss *anything*
Sign up for our newsletter
By logging in, you agree that we will process your data by the [terms of personal data protection](https://www.mergado.com/cookies).
Thank you, you have successfully joined our subscriber's list.
function ml_webform_success_5807248() {
var r = ml_jQuery || jQuery
r('.ml-subscribe-form-5807248 .row-success').show(), r('.ml-subscribe-form-5807248 .row-form').hide()
}