Guides and How-to's

Step-by-step guides and how-to articles for getting data into your store: importing products and customers, AI-assisted column mapping, scheduled imports from URL or FTP, Google Sheet–to–store sync, and troubleshooting common file import issues.

We recommend File2Cart for file-based import and scheduled feeds and Sheet2Cart for Google Sheet sync. Use our homepage to choose the right tool, then follow these guides to set up and run imports with confidence.

What you'll find

  • Import basics: First-time setup, connecting your store, and uploading CSV or Excel
  • Column mapping: Matching file columns to product, variant, and inventory fields—with AI suggestions
  • Scheduled sync: URL, FTP, and Google Sheets as recurring data sources
  • Platform-specific: Shopify, WooCommerce, Wix, BigCommerce—see our platform guides for more
  • Troubleshooting: Validation errors, format issues, and common import fixes

Home · Platform guides · Insights

Mastering Data Cleanup: Extracting Names in Google Sheets for E-commerce Efficiency
Google SheetsMar 8, 2026

Mastering Data Cleanup: Extracting Names in Google Sheets for E-commerce Efficiency

Learn how to efficiently extract and reformat names (last name, first initial + last name) from your e-commerce data using powerful Google Sheets formulas. Streamline your catalog, customer, and supplier management.

Shopping Cart Import Team

Ready to get started?

Browse our how-tos and guides for store data import and sync.

Get Started with How-tos