--- title: Connect SharePoint or OneDrive CSV Files to Marq description: Connect your CSV files stored in Microsoft SharePoint or OneDrive directly to Marq's data connections. This allows your data to automatically sync and update your designs. --- [Skip to content](https://help.marq.com/connect-sharepoint-or-onedrive-csv-files-to-marq#main-content) English Show submenu for translations ![marq.svg\]](https://help.marq.com/hubfs/Brand%20Logos/marq.svg) Open main navigation Close main navigation - English Show submenu for translations - - [Projects](https://app.marq.com/documents#/documents) [Projects](https://app.marq.com/documents#/documents) How can we help? - There are no suggestions because the search field is empty. 1. [Help Center](https://help.marq.com/?hsLang=en) 2. [Integrations](https://help.marq.com/integrations?hsLang=en) 3. [Data integrations](https://help.marq.com/integrations?hsLang=en#data-integrations) # Connect SharePoint or OneDrive CSV Files to Marq ## Connect your CSV files stored in Microsoft SharePoint or OneDrive directly to Marq's data connections. This allows your data to automatically sync and update your designs. #### Before you start ✅ **You'll need:** - A CSV file saved in SharePoint or OneDrive - Admin access to your SharePoint/OneDrive account - Access to Marq's data connections feature ⚠️ **Important:** This process creates a public link to your file. Only use this method with non-sensitive data. #### Step 1: Prepare your CSV file 1. **Save your file** as a `.csv` format in your SharePoint or OneDrive account 2. **Verify your data** - ensure your CSV has clear column headers and clean data 💡 **Tip:** Test your CSV by opening it in a text editor first to ensure it displays correctly. --- #### Step 2: Create a shareable link ### In SharePoint or OneDrive: 1. **Navigate to your file** and click the **Share** icon next to the file name Show Image ![](https://help.marq.com/hs-fs/hubfs/image-png-Jun-13-2025-10-41-23-3349-PM.png?width=688&height=173&name=image-png-Jun-13-2025-10-41-23-3349-PM.png) 1. **Click the permissions dropdown** in the "Send Link" window ![](https://help.marq.com/hs-fs/hubfs/image-png-Jun-13-2025-10-41-48-4779-PM.png?width=191&height=240&name=image-png-Jun-13-2025-10-41-48-4779-PM.png) 1. **Select "Anyone with the link"** and click **Apply** Show Image ![](https://help.marq.com/hs-fs/hubfs/image-png-Jun-13-2025-10-42-57-0577-PM.png?width=252&height=458&name=image-png-Jun-13-2025-10-42-57-0577-PM.png) 1. **Copy the link** by clicking the "Copy link" button ✅ **Success indicator:** You'll see a confirmation that the link was copied ![](https://help.marq.com/hs-fs/hubfs/image-png-Jun-13-2025-10-43-15-7744-PM.png?width=188&height=141&name=image-png-Jun-13-2025-10-43-15-7744-PM.png) --- #### Step 3: Convert to direct download link The link you copied won't work directly in Marq - you need to modify it first. 1. **Open a text editor** (like Notepad or any plain text editor) 2. **Paste your copied link** - it will look something like this:   ``` https://companyoffice365.sharepoint.com/:w:/s/ITLDTeamSpace/EXFW_yOGwdxFubfOL2bOrgARQ1xxqqQxhczJ16p2PyZQMA?e=uzMCD4 ``` 3. **Find the question mark (?)** in your link 4. **Replace everything after the ?** with `download=1` **Before:**   ``` https://companyoffice365.sharepoint.com/:w:/s/ITLDTeamSpace/EXFW_yOGwdxFubfOL2bOrgARQ1xxqqQxhczJ16p2PyZQMA?e=uzMCD4 ``` **After:**   ``` https://companyoffice365.sharepoint.com/:w:/s/ITLDTeamSpace/EXFW_yOGwdxFubfOL2bOrgARQ1xxqqQxhczJ16p2PyZQMA?download=1 ``` 5. **Copy your modified link** - you'll use this in Marq --- #### Step 4: Connect to Marq 1. **Go to your Marq data connections page** 2. **Click "Add a Data Set"** and select **CSV** ![](https://help.marq.com/hs-fs/hubfs/image-png-Jun-13-2025-10-44-08-9734-PM.png?width=822&height=412&name=image-png-Jun-13-2025-10-44-08-9734-PM.png) 1. **Paste your modified link** in the "Enter URL" field 2. **Click Connect** to test the connection ✅ **If successful:** You'll see a preview of your data --- #### Step 5: Configure your data ### Select your unique identifier Choose the column that contains unique information (like ID numbers, names, or email addresses). This helps Marq properly map your data. ![](https://help.marq.com/hs-fs/hubfs/image-png-Jun-13-2025-10-44-28-7944-PM.png?width=577&height=442&name=image-png-Jun-13-2025-10-44-28-7944-PM.png) ### Choose image columns (optional) If your CSV contains image URLs, select those columns so Marq can display images in your designs. ![](https://help.marq.com/hs-fs/hubfs/image-png-Jun-13-2025-10-44-47-5782-PM.png?width=528&height=386&name=image-png-Jun-13-2025-10-44-47-5782-PM.png) ### Preview your data Review how your data will appear in Marq's editor and make any necessary adjustments. --- #### Test your connection 1. **Save your data source** 2. **Create a test design** using your connected data 3. **Verify the data displays correctly** 🎉 **You're done!** Your CSV data is now connected and will update automatically when you change the source file. --- #### Troubleshooting ### Common issues and solutions **❌ "No data found" error** - Check that your link ends with `?download=1` - Verify your CSV file isn't empty - Ensure the file permissions allow "Anyone with the link" **❌ "Connection failed" error** - Test your download link in a browser - it should automatically download the file - Try creating a new share link and repeating the process - Check that your CSV file is properly formatted **❌ Data not updating** - SharePoint/OneDrive links update automatically, but changes may take a few minutes to appear - Try refreshing your Marq data connection - Verify you're editing the correct file in SharePoint/OneDrive **❌ Formatting issues** - Ensure your CSV uses standard comma separation - Check that special characters display correctly - Verify column headers are clear and descriptive #### Security considerations ⚠️ **Important:** This method creates a public download link. Anyone with the link can access your file. Only use this method with: - Non-sensitive business data - Information you're comfortable sharing publicly - Data that doesn't contain personal or confidential information For sensitive data, consider using Marq's other data connection options or contact our support team for enterprise solutions. - [Intro to Marq](https://help.marq.com/intro-to-marq?hsLang=en#main-content) - [Getting started](https://help.marq.com/intro-to-marq?hsLang=en#getting-started) - [Tips and tricks](https://help.marq.com/intro-to-marq?hsLang=en#tips-and-tricks) - [Common issues](https://help.marq.com/intro-to-marq?hsLang=en#common-issues) - [Get support](https://help.marq.com/intro-to-marq?hsLang=en#get-support) - [Other resources](https://help.marq.com/intro-to-marq?hsLang=en#other-resources) - [Content AI](https://help.marq.com/content-ai?hsLang=en#main-content) - [AI Assistant](https://help.marq.com/content-ai?hsLang=en#ai-assistant) - [AI Marqet](https://help.marq.com/content-ai?hsLang=en#ai-marqet) - [Brand Guardian](https://help.marq.com/content-ai?hsLang=en#brand-guardian) - [Account setup and billing](https://help.marq.com/account-setup-and-billing?hsLang=en#main-content) - [Account settings](https://help.marq.com/account-setup-and-billing?hsLang=en#account-settings) - [Storage](https://help.marq.com/account-setup-and-billing?hsLang=en#storage) - [Billing and plans](https://help.marq.com/account-setup-and-billing?hsLang=en#billing-and-plans) - [Privacy and security](https://help.marq.com/account-setup-and-billing?hsLang=en#privacy-and-security) - [Creating your design](https://help.marq.com/creating-your-design?hsLang=en#main-content) - [The Editor](https://help.marq.com/creating-your-design?hsLang=en#the-editor) - [Document and page settings](https://help.marq.com/creating-your-design?hsLang=en#document-and-page-settings) - [Templates](https://help.marq.com/creating-your-design?hsLang=en#templates) - [Images](https://help.marq.com/creating-your-design?hsLang=en#images) - [Text](https://help.marq.com/creating-your-design?hsLang=en#text) - [Shapes and graphics](https://help.marq.com/creating-your-design?hsLang=en#shapes-and-graphics) - [Layers and objects](https://help.marq.com/creating-your-design?hsLang=en#layers-and-objects) - [Elements](https://help.marq.com/creating-your-design?hsLang=en#elements) - [Video and interactive objects](https://help.marq.com/creating-your-design?hsLang=en#video-and-interactive-objects) - [Tables](https://help.marq.com/creating-your-design?hsLang=en#tables) - [Locking](https://help.marq.com/creating-your-design?hsLang=en#locking) - [Uploading](https://help.marq.com/creating-your-design?hsLang=en#uploading) - [Automation and other advanced features](https://help.marq.com/creating-your-design?hsLang=en#automation-and-other-advanced-features) - [Exporting and sharing](https://help.marq.com/exporting-and-sharing?hsLang=en#main-content) - [Collaborate](https://help.marq.com/exporting-and-sharing?hsLang=en#collaborate) - [Export to social media](https://help.marq.com/exporting-and-sharing?hsLang=en#export-to-social-media) - [Embedding](https://help.marq.com/exporting-and-sharing?hsLang=en#embedding) - [Publishing](https://help.marq.com/exporting-and-sharing?hsLang=en#publishing) - [Printing](https://help.marq.com/exporting-and-sharing?hsLang=en#printing) - [Downloading](https://help.marq.com/exporting-and-sharing?hsLang=en#downloading) - [GIFs](https://help.marq.com/exporting-and-sharing?hsLang=en#gifs) - [Admin settings and team management](https://help.marq.com/admin-settings-and-team-management?hsLang=en#main-content) - [Managing your team](https://help.marq.com/admin-settings-and-team-management?hsLang=en#managing-your-team) - [Licensing and roles](https://help.marq.com/admin-settings-and-team-management?hsLang=en#licensing-and-roles) - [Brand assets](https://help.marq.com/admin-settings-and-team-management?hsLang=en#brand-assets) - [User experience and workflows](https://help.marq.com/admin-settings-and-team-management?hsLang=en#user-experience-and-workflows) - [Settings and configuration](https://help.marq.com/admin-settings-and-team-management?hsLang=en#settings-and-configuration) - [Implementation resources](https://help.marq.com/admin-settings-and-team-management?hsLang=en#implementation-resources) - [Integrations](https://help.marq.com/integrations?hsLang=en#main-content) - [Printer integrations](https://help.marq.com/integrations?hsLang=en#printer-integrations) - [Data integrations](https://help.marq.com/integrations?hsLang=en#data-integrations) - [Custom integrations](https://help.marq.com/integrations?hsLang=en#custom-integrations) - [Security and sign-on integrations](https://help.marq.com/integrations?hsLang=en#security-and-sign-on-integrations) - [Email integrations](https://help.marq.com/integrations?hsLang=en#email-integrations) - [Productivity and analytics integrations](https://help.marq.com/integrations?hsLang=en#productivity-and-analytics-integrations) - [Workflow Integrations](https://help.marq.com/integrations?hsLang=en#workflow-integrations) - [Salesforce](https://help.marq.com/integrations?hsLang=en#salesforce) - [MediaValet](https://help.marq.com/integrations?hsLang=en#mediavalet) - [Training videos](https://help.marq.com/training-videos?hsLang=en#main-content) - [View](https://help.marq.com/training-videos?hsLang=en#view) - [Courses](https://help.marq.com/courses?hsLang=en#main-content) - [View](https://help.marq.com/courses?hsLang=en#view) - [Tutorials and resources](https://help.marq.com/tutorials-and-resources?hsLang=en#main-content) - [View](https://help.marq.com/tutorials-and-resources?hsLang=en#view) - [Design services](https://help.marq.com/design-services?hsLang=en#main-content) - [View](https://help.marq.com/design-services?hsLang=en#view) - [Events](https://help.marq.com/events?hsLang=en#main-content) - [View](https://help.marq.com/events?hsLang=en#view) - [Analytics](https://help.marq.com/analytics?hsLang=en#main-content) - [Account Setup](https://help.marq.com/analytics?hsLang=en#account-setup) - [Basic Analytics](https://help.marq.com/analytics?hsLang=en#basic-analytics) - [Advanced Analytics](https://help.marq.com/analytics?hsLang=en#advanced-analytics) - [Navigating Reports](https://help.marq.com/analytics?hsLang=en#navigating-reports) - [Glossary of Terms](https://help.marq.com/analytics?hsLang=en#glossary-of-terms) - [App Marketplace](https://help.marq.com/app-marketplace?hsLang=en#main-content) - [Workflow Connectors](https://help.marq.com/app-marketplace?hsLang=en#workflow-connectors) - [Campaigns](https://help.marq.com/campaigns?hsLang=en#main-content) - [Getting Started](https://help.marq.com/campaigns?hsLang=en#getting-started) - [Connect to Facebook](https://help.marq.com/campaigns?hsLang=en#connect-to-facebook) - [Industry](https://help.marq.com/campaigns?hsLang=en#industry) - [Objectives](https://help.marq.com/campaigns?hsLang=en#objectives) - [Analytics](https://help.marq.com/campaigns?hsLang=en#analytics) - [Creator Studio](https://help.marq.com/creator-studio?hsLang=en#main-content) - [Getting Started](https://help.marq.com/creator-studio?hsLang=en#getting-started) - [Studio FAQ](https://help.marq.com/creator-studio?hsLang=en#studio-faq) - [Templates](https://help.marq.com/templates?hsLang=en#main-content) - [Getting Started](https://help.marq.com/templates?hsLang=en#getting-started) - [Advanced Features](https://help.marq.com/templates?hsLang=en#advanced-features) - [Team Management](https://help.marq.com/templates?hsLang=en#team-management) - [Troubleshooting](https://help.marq.com/templates?hsLang=en#troubleshooting) - [CRM Integrations](https://help.marq.com/crm-integrations?hsLang=en) - [DAM Integrations](https://help.marq.com/dam-integrations?hsLang=en) - [Marq 2026 Packaging Updates](https://help.marq.com/marq-2026-packaging-updates?hsLang=en) - [AI Brand Creations](https://help.marq.com/ai-brand-creations?hsLang=en) [![Chill listening crop-3](https://help.marq.com/hubfs/Brand%20Logos/marq.svg "Chill listening crop-3")](https://help.marq.com?hsLang=en) Copyright © 2026, Marq