Connect 1001fx and Microsoft 365 Excel integrations
Connect 1001fx and Microsoft 365 Excel with any of your favorite apps in just a few clicks. Design, build, and automate anything for your work by integrating apps like 1001fx and Microsoft 365 Excel to create visual automated workflows. Choose from thousands of ready-made apps or use our no-code toolkit to connect to apps not yet in our library.
Adds a specified number of days, months, etc. to a given date. It can also subtract dates by adding negative values. - More informations: https://1001fx.com/functions/addtodate
Places provided image on every page of provided pdf. - More informations: https://1001fx.com/functions/addwatermark2pdf
Adds an image as watermark to a video at a given position. The result is an URL to the mp4 that is available for 48 hours. - More informations: https://1001fx.com/functions/addwatermark2video
Get answer from am AI based on predefined templates or a custom prompt. Will be charged per used tokens. Predefined prompts are: - Summarize Text - Make Longer - Make Shorter - Check Spelling and Grammar - Change Tone - Simplify - Translate - Explain This - Find Action Items - Continue Writing - Anonymize Text - Improve Writing - Custom - More informations: https://1001fx.com/functions/askai
Checks a date against different conditions. - More informations: https://1001fx.com/functions/checkdate
Check if the given date is a holiday in a country and optionally in a state. Please refer to https://github.com/commenthol/date-holidays for available country codes. - More informations: https://1001fx.com/functions/isholiday
Converts a csv and parse it into an array of objects. The file must be a valid csv file (not an Excel or GSheet spreadsheet). - More informations: https://1001fx.com/functions/csv2array
Converts an input date to the specified timezone. - More informations: https://1001fx.com/functions/converttimezone
Converts an uploaded asset (image, zip, audio, video, pdf, ...) or loads and converts the asset from the given URL to a base64 string. - More informations: https://1001fx.com/functions/asset2base64
Converts provided geocode. - More informations: https://1001fx.com/functions/convertgeocode
Converts an HTML string or URL to an image. If an HTML string is given. Replacements for the text are processed. It is also possible to use Tailwind in classes. - More informations: https://1001fx.com/functions/html2image
Converts a mp3 into an mp4 file. Adds a thumbnail and images for given durations. The result is an URL to the mp4 that is available for 48 hours. - More informations: https://1001fx.com/functions/audio2video
Converts an office document into a pdf. - More informations: https://1001fx.com/functions/convertofficedocument
Converts multiple texts on a colored background and creates an image. Transparent backgrounds allow overlay on another image. - More informations: https://1001fx.com/functions/text2image
Creates a bar chart with custom data and styling. Output can be an image or a PDF. - More informations: https://1001fx.com/functions/barchart
Creates a line chart with custom data and styling. Output can be an image or a PDF. - More informations: https://1001fx.com/functions/linechart
Creates a pie chart with custom data and styling. Output can be an image or a PDF. - More informations: https://1001fx.com/functions/piechart
Creates realistic fake data for testing and development. Examples: address, date, lorem ipsum, commercial products, company, image, random numbers, urls and many more). - More informations: https://1001fx.com/functions/createfakedata
Creates any text from template and given data. For example, dynamically generate HTML templates with data and logic, making it useful for building dynamic web applications. Based on Handlebars - see https://handlebarsjs.com/ for more details. - More informations: https://1001fx.com/functions/template2text
Crop an Image - More informations: https://1001fx.com/functions/cropimage
Cuts a mp3 file from given file or URL. Beginning from start in seconds, the given duration (in seconds) will be cut. - More informations: https://1001fx.com/functions/cutaudiofile
Decrypts the provided PDF with the given password. The password must not be empty. - More informations: https://1001fx.com/functions/decryptpdf
Decrypts the uploaded Zip with the given password. The password must not be empty. - More informations: https://1001fx.com/functions/decryptzip
Encrypts the uploaded PDF with the given password. The password must not be empty. - More informations: https://1001fx.com/functions/encryptpdf
Encrypts the uploaded Zip with the given password. The password must not be empty. - More informations: https://1001fx.com/functions/encryptzip
Execute JavaScript code in a sandbox on our server. The following npm packages can be used: momentjs, cheerio, handlebars, ... (see https://1001fx.com for full list). Exceptions will be caught and returned. Strict is forced and imports are not allowed. - More informations: https://1001fx.com/functions/executejavascript
Extracts the audio from a video. The result is an URL to the mp3 that is available for 48 hours. - More informations: https://1001fx.com/functions/extractaudio
Filters an array by an given comparison operator. - More informations: https://1001fx.com/functions/filterarray
Formats a given date and time to the specified ouput format. - More informations: https://1001fx.com/functions/formatdatetime
Playground function with JSON body input and JSON body output for demos and testing. Use it to learn how to work with 1001fx. Charge is always 0. ApiKey is required. - More informations: https://1001fx.com/functions/hello
Returns the first given file. Playground function with file input and output to test files input and file retrieval. Charge is always 0. ApiKey is required. - More informations: https://1001fx.com/functions/hellofiles
Generates a HTML email body from a MJML template - More informations: https://1001fx.com/functions/mjml2html
Generate a QRCode - More informations: https://1001fx.com/functions/generateqrcode
Looks up a provided longitude and latitude values and returns location informations. - More informations: https://1001fx.com/functions/geocode2location
Gets the content of an URL in a structured way. Has specialised handling for dedicated domains like YouTube videos, tweets and LinkedIn posts. - More informations: https://1001fx.com/functions/getcontent
Retrieves data from HelloSpaces for the given Space ID. - More informations: https://1001fx.com/functions/gethellospacesdata
Get all EXIF data from an given image. - More informations: https://1001fx.com/functions/getimageexif
Returns two arrays. One containing the keys and on containing the values of the object. - More informations: https://1001fx.com/functions/getjsonkeysandvalues
Returns the width, height, file extension, mimetype, and presence of alpha channel of an image (bmp, gif, jpeg, png and tiff). - More informations: https://1001fx.com/functions/getimagemeta
Gets the current balance of credits for your API key. - More informations: https://1001fx.com/functions/getcredits
Implements a hlookup function similar to the GSheet and Excel functions. Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. - More informations: https://1001fx.com/functions/hlookup
Looks up a provided IP and returns geo informations. - More informations: https://1001fx.com/functions/ip2geocode
Looks up a provided location and returns geo informations. - More informations: https://1001fx.com/functions/location2geocode
Performs an arbitrary authorized API call.
Creates an image with a circle mask. - More informations: https://1001fx.com/functions/maskcircleimage
Masks a source image to this image using the average pixel color. A completely black pixel on the mask will make a pixel in the image completely transparent. - More informations: https://1001fx.com/functions/maskimage
Merges up to three PDFs into a single PDF. The orientation of each merged PDF is preserved. - More informations: https://1001fx.com/functions/mergepdfs
Modifies the EXIF data in an given image. Provided data will be merged with existing data. - More informations: https://1001fx.com/functions/modifyimageexif
Overlays two images to create a new image with the second image placed as an overlay. Uses the png file format for transparency. Canvas size is preserved. - More informations: https://1001fx.com/functions/overlayimages
Implements a pivottable function similar to GSheet and Excel functions. Aggregate fields with given operator. Multiple fields can be aggregated. Aggregate functions are: count, sum, min, max and mean. - More informations: https://1001fx.com/functions/pivottable
Removes duplicates from an array. If the fields parameter is empty, all fields of the first array element are used for the comparison. - More informations: https://1001fx.com/functions/removeduplicates
Remove all EXIF data from a given image. - More informations: https://1001fx.com/functions/removeimageexif
Fills the provided carbone template with data. This function uses the Carbone JS Community Edition on 1001fx servers. - More informations: https://1001fx.com/functions/rendercarbonetemplate
Resizes an image to the specified width and height. - More informations: https://1001fx.com/functions/resizeimage
Scales the image by the specified factor. - More informations: https://1001fx.com/functions/scaleimage
Scales an image to the largest size that will fit within a rectangle of the specified width and height. - More informations: https://1001fx.com/functions/scaleimagetofit
Scrape a provided HTML string or Website. - More informations: https://1001fx.com/functions/scrapehtml
Deep searches in all keys of a given JSON object. The result is an array of key/value pairs the matches the criteria - More informations: https://1001fx.com/functions/deepsearchjson
Splits the uploaded PDF into seperate pages and returns a zip file containing all individual pages. - More informations: https://1001fx.com/functions/splitpdf
Implements a sumif function similar to GSheet and Excel functions. Sum elements of an array by a given criterion. - More informations: https://1001fx.com/functions/sumif
Transform a JSON input to another JSON format using a template.
Uploads an asset (image, zip, audio, video, pdf, ...) to our storage and returns an URL for downloading. The asset will be automatically deleted at the end of the next day. - More informations: https://1001fx.com/functions/uploadasset
Validates if a given string is in provided format. Formats are :URL, email, IBAN, BIC, VAT, ISBN and Regular Expresssion - More informations: https://1001fx.com/functions/validatestringformat
Implements a vlookup function similar to the GSheet and Excel functions. Searches for a value in the first column of a table or an array of values, and then returns a value in the same column from a column you specify in the table or array. - More informations: https://1001fx.com/functions/vlookup
Adds a new table.
Adds a new table column.
Adds a new table row.
Adds a new worksheet to a workbook.
Adds a new worksheet row.
Deletes a table.
Deletes a worksheet row.
Downloads the content of a specified Excel workbook.
Gets the metadata of a specified table.
Performs an arbitrary authorized API call.
Updates an existing table.
Updates an existing table column.
Updates an existing worksheet row.
Retrieves a list of all table rows in a workbook.
Retrieves a list of all table objects.
Retrieves a list of worksheet rows.
Retrieves a list of worksheet objects.
Retrieves data for a given range.
Searches for Excel workbooks.
Trusted by thousands of fast-scaling organizations around the globe
Automate your work. Build something new.
Just drag and drop apps to automate existing workflows or build new complex processes. Solve problems across all areas and teams.
Build your 1001fx and Microsoft 365 Excel integrations.
Create custom 1001fx and Microsoft 365 Excel workflows by choosing triggers, actions, and searches. A trigger is an event that launches the workflow, an action is the event.
Adds a specified number of days, months, etc. to a given date. It can also subtract dates by adding negative values. - More informations: https://1001fx.com/functions/addtodate
Places provided image on every page of provided pdf. - More informations: https://1001fx.com/functions/addwatermark2pdf
Adds an image as watermark to a video at a given position. The result is an URL to the mp4 that is available for 48 hours. - More informations: https://1001fx.com/functions/addwatermark2video
Adds a new table.
Adds a new table column.
Adds a new table row.
Adds a new worksheet to a workbook.
Adds a new worksheet row.
Get answer from am AI based on predefined templates or a custom prompt. Will be charged per used tokens. Predefined prompts are: - Summarize Text - Make Longer - Make Shorter - Check Spelling and Grammar - Change Tone - Simplify - Translate - Explain This - Find Action Items - Continue Writing - Anonymize Text - Improve Writing - Custom - More informations: https://1001fx.com/functions/askai
Connect any app with 1001fx and Microsoft 365 Excel
Popular 1001fx and Microsoft 365 Excel workflows.
Looking to get more out of 1001fx and Microsoft 365 Excel? With Make you can visually integrate 1001fx and Microsoft 365 Excel into any workflow to save time and resources — no coding required. Try any of these templates in just a few clicks.
Send WhatsApp messages for new Excel rows
Every time a new row is added to your Excel spreadsheet, Make will automatically send a message in WhatsApp.
TRY IT ->Add a new row in Microsoft Excel for every Stripe event
Streamline your financial tracking by automatically adding new Stripe event data to Microsoft Excel. With this template, every time a new event occurs in Stripe, Make will create a new row in your Excel worksheet, ensuring that your financial records are always up-to-date and easily accessible for analysis. Perfect for businesses looking to enhance their accounting processes and maintain accurate financial documentation.
TRY IT ->Add new Gravity Forms entries as rows in Microsoft Excel
Streamline your data collection process by automatically transferring new entries from Gravity Forms to Microsoft Excel. With this template, every time a new form submission is received in Gravity Forms, Make will seamlessly add a new row to your Excel worksheet, ensuring your data is organized and easily accessible for analysis. This integration eliminates manual data entry, saving you time and reducing the risk of errors. Perfect for managing responses, feedback, or any other data collected through your forms.
TRY IT ->Add a new row in Microsoft Excel for every JotForm submission
Streamline your data collection process by automatically adding new JotForm submissions to Microsoft Excel. With this template, every time a user submits a form on JotForm, Make will create a new row in your Excel worksheet, ensuring that all your responses are organized and easily accessible for analysis. This integration eliminates manual data entry, saving you time and reducing the risk of errors. Perfect for managing surveys, registrations, or feedback forms.
TRY IT ->Add new Jotform submissions as rows in Microsoft Excel
Streamline your data collection process by automatically transferring JotForm submissions to Microsoft Excel. With this template, every time a new submission is received in JotForm, Make will seamlessly add a new row to your Excel spreadsheet, ensuring that your data is organized and easily accessible for analysis and reporting. Say goodbye to manual data entry and enhance your productivity with this efficient workflow.
TRY IT ->Send an email with Microsoft Excel workbook as an attachment
Streamline your communication process by automatically sending emails based on data from your Microsoft Excel workbook. This template allows you to extract information from your Excel files and create personalized email messages using Microsoft Email, ensuring that your outreach is efficient and data-driven. Perfect for managing contacts, sending updates, or following up on important tasks, this integration saves you time and enhances your productivity.
TRY IT ->Create new completions with OpenAI ChatGPT from worksheet rows in Microsoft Excel
Save time by automatically generating completions to any topic, for example, SEO keywords from your content topics. [Learn more](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796?utm_source=make&utm_medium=in-app&utm_campaign=template)
TRY IT ->Save Facebook Lead Ads leads to a Microsoft 365 Excel worksheet
Automatically add a new row to your Microsoft 365 Excel worksheet every time there's a new lead in Facebook Lead Ads. Your Microsoft 365 Excel worksheet has to contain at least 4 headers to see the template's default settings.
TRY IT ->Add data to a Microsoft Excel worksheet received from a Webhook
Integrate webhooks with Microsoft Excel to automatically import and update vital information, streamlining data management and enhancing your spreadsheet productivity.
TRY IT ->
FAQ
How it works
Traditional no-code iPaaS platforms are linear and non-intuitive. Make allows you to visually create, build, and automate without limits.
Trusted by 500,000+ Makers
"Make really helped us to scale our operations, take the friction out of our processes, reduce costs, and relieved our support team. It is difficult to not become a fan."
"Make drives unprecedented efficiency within our business in ways we never imagined. It’s having an extra employee (or 10) for a fraction of the cost."
"The simplicity, flexibility and ability to build real complex automations without any knowledge of programming makes it the best thing since sliced bread."
"True citizen development in the entire company. Make is present in every department, empowering the company to offer a unique customer experience."