Combine Sheets
This add-on pulls data from numerous spreadsheets into one as values or as a formula in just 3 quick steps. Even if your tables differ in column order, contents, or formatting, Combine Sheets will perfectly join everything you have in one table by common column headers. 🔁 GET THE AUTO-UPDATED RESULT The add-on can combine sheets using a formula. This way, your result will be in-sync with the source tables, and all changes made in the original sheets will be reflected in the result automatically. Try it yourself and you won't regret it. 💡 PERKS OF COMBINE SHEETS • Combine as many spreadsheets as you need • Include extra sheets to the existing result at any time • Add sheets from Google Drive using the quick search field • Pull data from the entire sheet or adjust the range manually • Pick columns to combine if needed • Sort the combined result by multiple columns • Keep the formatting of the original datasets • Put the result into an existing or new file, sheet, or cells of your choice • Separate combined sheets with empty rows or sheet names for better navigation • Add sheet names to the result to identify the source of each combined table 💾 SAVE TIME WITH SCENARIOS If you frequently combine the same data, save your preferred settings as scenarios to skip repetitive steps. Simply create, name, and run a scenario to combine your data instantly. 👥 SHARE SCENARIOS WITH YOUR TEAM Export your scenarios to share with your team or across accounts, and import shared scenarios to start combining data using preconfigured settings immediately. 30 DAYS OF FREE USE Fully functional 30-day trial period. All payments are secure and include an unconditional 30-day money-back guarantee. If you have any questions about consolidating data from many Google Sheets, please post them here: https://www.ablebits.com/docs/google-sheets-combine-multiple-sheets/ We'll be happy to assist! Combine Sheets is a proud member of the Ablebits product family. We build add-ons that help you make the most of Google Workspace. Visit our official website to learn more: https://www.ablebits.com/google-sheets-add-ons/index.php ––––––––––––––––––––––––––––––––––––– WHAT'S NEW ***** V1.8 (04 Feb 2025) ***** ★ New features ★ - Sort the result. Whether you combine data with or without a formula, you can have the result sorted by any number of columns A>Z or Z>A. - Scenarios. Save the options you use most often and give this set a name – this is your scenario. Once you run it, your data will be processed right away, and you won't need to go over the same steps again. - Share saved scenarios. Export and import your saved scenarios to share them with your teammates or just make their backups on your Drive or computer. - New place for your resulting files: browse your Drive and pick a certain folder. Improvements: - The formula ignored sheets that didn't have the required columns. Now these sheets are included in the result in case the required data appears in future. - Combine even more sheets using the formula since we adjusted it so it's harder to reach the limit for 50k characters for formulas. - Minor UX improvements. Fixed: - The formula didn't work if empty sheets were included in the result for possible future use. ***** V1.7 (30 Aug 2024) ***** ★ New features ★ - You can now select columns to combine. Make the add-on auto-detect common columns across the sheets or pick desired columns manually. - Optionally have sheet names in a new column to the right of your result table so you always have an idea where that data came from. Improved: - Pulls notes associated with cells to the result as well. - When combining as values, the result will inherit some formatting of the original cells: vertical alignment, column width, row height, wrapping, and data validation. - Minor UX and UI improvements. Fixed: - If there were 3 or more columns with identical headers, their content could get lost in the result. - Cut zeros and leading spaces from the names of the combined sheets on the 'Connect files to IMPORTRANGE' sheet. - Couldn't process data that contained some non-printing characters. - Couldn't process sheets that had a plus symbol (+) in their names. ***** V1.6 (23 December 2023) ***** Improved: - When you add sheets to the result using a formula, they are now being added to the end of the whole table. - It's now possible to look for the files in the folder with Starred items of your Drive. - The limit for total cells in a spreadsheet is expanded to 10 million cells. - Minor UX improvements. Fixed: - The option 'Add to the result' replaced the existing formula instead of updating it. - Treated the same headers written in different cases as distinct ones and didn't combine them. - Unlike the formula, treated different columns with blank headers as distinct ones. - Changed the Date format in the combined data. - Couldn't locate spreadsheets in Drive if your search name started with an apostrophe. - The add-on couldn't paste data into the file without a set time zone. ***** V1.5 (18 October 2021) ***** ★ New features ★ - Quickly add more files to the existing result with a corresponding new option. No need to combine all sheets all over again. Just select the new sheets you want to add to the result and the result itself. Select the previously combined data as the one to update and the add-on will do the rest. Visit the help page for all the details. Improved: - Significant performance improvements in processing large amounts of data. - Minor UX improvements. Fixed: - Placing the resulting formula into your custom location removed existing conditional formatting, Data validation rules and comments. ***** V1.4 (5 May 2021) ***** Improved: - Performance improvements in processing large amounts of data. - Minor UX and UI improvements. Fixed: - Didn't accept custom ranges entered from the keyboard. - Didn't work if you chose to preserve formatting but one of your tables contained headers with blank colored rows. - Minor UX issues. ***** V1.3 ***** ★ New features ★ - One more way to combine data – with a formula! Have the add-on build a formula to join all existing and future records from the chosen sheets together. The formula is always connected to your original files. Hence, all source changes, all new cells, rows and columns will appear in the combined table automatically. Make sure to visit the help page for more details. Improved: - Minor UX improvements. Fixed: - In some cases, the add-on couldn't combine lots of spreadsheets and fired error. Now it offers you to try and process data again or email our customer support service. - Couldn't add files from Drive if they were previously excluded from the add-on tree-view. - Used to add only up to 10 files from Shared Drive. - Minor UI issues. ***** V1.2 ***** Improved: - When picking spreadsheets from Drive, files and folders are now sorted A>Z. - The limit for cells has been increased to 5M cells. - UI: elements don't overlap anymore for DPI 200%. Fixed: - The add-on counted the resulting cells incorrectly and exceeded the limit for 5M cells every time the option 'Consider table headers' was not selected. - Didn't work with a one-column range if 'All data' was selected to combine. - Accepted the incorrect range for a custom location for the results. ***** V1.1 ***** Fixed: - Wrong selected range if server response time was slow. - Modifying date format after combining. - The message "The entered range is incorrect" kept showing even after the range was corrected. - Minor UI issues.
Top keywords
- data20×1.58%
- sheets20×1.58%
- result19×1.50%
- combine16×1.26%
- formula13×1.03%
- cells10×0.79%
- columns10×0.79%
- add-on9×0.71%
- improvements9×0.71%
- minor9×0.71%
- drive8×0.63%
- files8×0.63%
ContactsFlow™ Shared Contacts for Calendar
Easily see who you’re collaborating with and share contact details with your entire team directly from Google Calendar™. You can also add notes to contacts and keep everyone synchronized. The Calendar for ContactsFlow™ app brings smart contact sharing and contact management directly into your Google Calendar™ experience. Whether you’re collaborating internally with teammates or working with external partners, this app helps you instantly add, edit, organize, and share contact information from Google Calendar™ with your entire team. What can you do with ContactsFlow™? ✅ Share and synchronize contacts effortlessly - Share any Google Contacts™ label (contact list) with individuals or Google Groups - Instantly sync shared contacts with Gmail™, Google Contacts™, mobile devices (iPhone, Android, Google phones), Calendar™, Drive™, and more - Keep your company contact lists centralized, organized, and always up to date ✅ Control permissions and visibility - Set permission levels such as View Only, Can Edit, Can Share, and Can Delete - Hide sensitive contact fields from unauthorized users - Ensure contact sharing aligns with your internal privacy and security policies ✅ Centralize and manage your Google Workspace™ directory - Synchronize your Google Workspace™ Directory and LDAP with users’ devices - Allow employees to update their own directory profiles - Build a unified and always up-to-date company address book ✅ Access shared contacts everywhere - Access shared contacts from Gmail™, Google Contacts™, Android, iPhone, Outlook, WhatsApp, Zoom, CRMs, and more - No installation required on user devices — synchronization happens automatically in real time - Enable Gmail™ autocomplete and contact visibility across Google apps ✅ Comments, notes, and notifications - Add internal notes and comments to contacts directly from Gmail™ - Mention teammates with @mentions to notify them instantly - Use notifications and history tracking to review or revert contact changes ✅ Custom fields to personalize contact cards - Create custom fields such as Customer ID, Plan Type, Onboarding Date, Birthday, or any field your team requires - Use free-text fields or dropdown menus with predefined values - Let users or AI automatically populate custom fields during contact creation or updates - Organize contacts based on your workflow or industry with fields like - Customer Type, Sales Region, Project Name, Renewal Due, or Priority Level - Improve searchability and categorization across your organization ✅ Search, filter, and organize contacts - Use advanced search filters to find contacts by company, location, job title, tags, and more - Filter contacts using custom fields, teams, vendors, customers, or departments - Organize your contacts with flexible labels and grouping options ✅ History logs and audit tracking - Track every contact change, including who edited what and when - Revert contact edits directly from notifications or history logs Improve transparency and audit readiness ✅ Unlimited backup and restore - Restore deleted contacts anytime with no time limitations - Track all updates with Shared Contacts admin logs - Investigate, revert, or restore contact data in one click using advanced search tools ✅ Integrate with the tools you already use - Works natively with Gmail™ and Google Contacts™ - Synchronize contacts from Active Directory, CRMs, ERPs, and mobile devices - Connect with CRM platforms and business applications - Integrate with helpdesks, IP phone systems, and 3,000+ apps through Zapier or our Public API Why Choose ContactsFlow™? ContactsFlow™ is one of the leading solutions for sharing and managing Google Contacts™ across teams and organizations. Whether you use Gmail™ or Google Workspace™ (formerly G Suite), you can easily create and share contact labels (contact groups) with internal users, external collaborators, and even free Gmail™ accounts. Trusted by thousands of organizations worldwide, ContactsFlow™ is a powerful alternative to solutions like Shared Contacts Manager, ContactBook, CoContacts, Shared Groups, Voyzu, and others. Contacts can be automatically captured from emails, calls, forms, and files. With flexible permission controls, you can assign access levels such as View Only, Can Edit, Can Share, or Can Delete. You never need to leave Gmail™ or Google Calendar™ to manage your shared contacts. Contacts synchronize instantly across devices and applications, eliminating duplicate work and manual updates. Every team member gets access to the right contact information with full context, notes, and collaboration history. The platform also includes backup and restore capabilities to help keep your contact database secure, synchronized, and always recoverable. Designed for businesses of all sizes, ContactsFlow™ makes collaborative contact management simple, scalable, and efficient. Install it in seconds and start collaborating immediately. Try it free and transform the way your team shares and manages contacts. 🔗 Visit contactsflow.ai for support, pricing, integrations, and FAQs. 🔍 FAQ 1. What does the Calendar Add-on for ContactsFlow™ do? When you open an event in Google Calendar™, the add-on detects participants and provides actions such as adding them to a contact list, editing contact details, or adding comments and notes directly from Calendar™. 2. Can I view full contact details from Calendar™? Yes. The app displays detailed contact cards including names, email addresses, phone numbers, companies, job titles, and internal notes shared by teammates. 3. Does it work with Google Groups? Yes. You can expand Google Groups and manage shared contact access for groups and individual collaborators. 4. Can I add new contacts from Calendar™? Absolutely. You can instantly create new contacts or shared contacts directly from Calendar™ and assign them to labels such as Clients, Vendors, or Team Members. 5. Can I assign permissions to shared contact lists? Yes. You can assign permissions including View Only, Can Edit, Can Share, and Can Delete. 6. Who can I share contact labels with? You can share contact labels with Google Workspace™ users, Gmail™ users, and external collaborators, depending on your sharing settings. 7. Can I restrict access to sensitive contact fields? Yes. Field-level permissions allow you to hide sensitive information such as private phone numbers or internal notes from unauthorized users. 8. Which apps does ContactsFlow™ synchronize with? Contacts synchronize with Gmail™, Google Contacts™, Calendar™, Drive™, Meet™, iPhone, Android, Outlook, CRMs, and thousands of applications through Zapier and APIs. 9. Can it synchronize with CRM systems? Yes. ContactsFlow™ supports CRM integrations through APIs, Zapier, and native integrations. 10. Do contacts automatically synchronize to mobile devices? Yes. Contact updates synchronize instantly with iPhones, Android devices, and Google phones with minimal setup. 11. Is ContactsFlow™ GDPR, HIPAA, and SOC 2 compliant? Yes. ContactsFlow™ complies with GDPR, HIPAA, and SOC 2 requirements and includes permission controls, audit logs, and security features. 12. Can I track who changed contact information? Yes. Every change is logged with timestamps and user tracking, and previous versions can be restored when needed. 13. What happens if a contact is accidentally deleted? Deleted contacts can be restored anytime with unlimited backup and restore functionality. 14. How do I install the Calendar for ContactsFlow™ app? Click “Install” from the Google Workspace Marketplace listing. Once installed, the app becomes available directly inside Google Calendar™ and provides access to the full ContactsFlow™ platform.